Tag Archives: microsoft sql server
-
Default Database Reports – Disk Usage by Table
4July 19, 2017 by Kenneth Fisher
Every now and again you need to know how big a table is. Or several tables. Or all of the …
Continue reading -
Default Instance Reports – Configuration Changes History
Leave a commentJuly 17, 2017 by Kenneth Fisher
Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured …
Continue reading -
Default reports in SSMS
2July 13, 2017 by Kenneth Fisher
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are …
Continue reading -
Save and save often
2July 11, 2017 by Kenneth Fisher
It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday! …
Continue reading -
What is the system_health extended events session?
5July 5, 2017 by Kenneth Fisher
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about …
Continue reading -
SQL Homework – July 2017
11July 3, 2017 by Kenneth Fisher
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a …
Continue reading -
SQL Crossword : T-SQL Keywords : June 2017
4June 28, 2017 by Kenneth Fisher
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked …
Continue reading -
Temp table quiz
10June 26, 2017 by Kenneth Fisher
Brent Ozar (b/t) posted a pop quiz on twitter earlier today. Go ahead and give it a shot .. I’ll …
Continue reading -
Adding Identity to an existing column
2June 19, 2017 by Kenneth Fisher
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He …
Continue reading -
Turning ANSI_PADDING off, and why you shouldn’t
4June 15, 2017 by Kenneth Fisher
I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
Continue reading
SQL Studies 