Default Instance Reports – Configuration Changes History
Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured...
2017-08-02 (first published: 2017-07-17)
1,394 reads
SQLStudies
Default reports in SSMS
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...
2017-07-27 (first published: 2017-07-13)
2,635 reads
Save and save often
It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday!...
2017-07-11
442 reads
What is the system_health extended events session?
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about...
2017-07-19 (first published: 2017-07-05)
2,152 reads
SQL Homework – July 2017
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...
2017-07-03
413 reads
SQL Crossword : T-SQL Keywords : June 2017
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked...
2017-07-07 (first published: 2017-06-28)
2,434 reads
Temp table quiz
Brent Ozar (b/t) posted a pop quiz on twitter earlier today.
Go ahead and give it a shot .. I’ll wait.
So?...
2017-06-26
677 reads
Dynamically generate the command line DMA statement for each database
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...
2017-06-21
661 reads
Adding Identity to an existing column
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...
2017-06-19
2,866 reads
Turning ANSI_PADDING off, and why you shouldn’t
I ran into an interesting error the other day while doing a partition switch.
Partition switch failed because : column ‘xyz’...
2017-06-26 (first published: 2017-06-15)
3,182 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers