Tag Archives: microsoft sql server
-
I’ve gotten a transaction log full error but when I look it’s not full??
2April 16, 2018 by Kenneth Fisher
Every now and again I’ll get an error telling me a transaction log is full. This can be for any …
Continue reading -
Deleting a lot of data
5April 12, 2018 by Kenneth Fisher
I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
Continue reading -
Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101
1April 10, 2018 by Kenneth Fisher
Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. …
Continue reading -
SSMS’s Dark Theme
5April 4, 2018 by Kenneth Fisher
There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the …
Continue reading -
What’s the difference between Files and Filegroups?
2March 28, 2018 by Kenneth Fisher
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
Continue reading -
DB_NAME() vs ORIGINAL_DB_NAME()
1March 15, 2018 by Kenneth Fisher
I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular …
Continue reading -
Double hop error when using SQLCMD
2February 26, 2018 by Kenneth Fisher
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos. One of the problems with linked servers (no rude noises …
Continue reading -
Windowing without a partition by or an order by
4February 21, 2018 by Kenneth Fisher
If you’ve never worked with windowing functions they look something like this: The other day someone mentioned that you could …
Continue reading -
The default filegroup, and why you should care.
2February 19, 2018 by Kenneth Fisher
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
Continue reading -
Synonyms, how and why.
8February 15, 2018 by Kenneth Fisher
Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even …
Continue reading
SQL Studies 