Using @@ROWCOUNT can be a bit tricky
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...
2015-09-16
722 reads
SQLStudies
What SQL Server components are installed on this machine?
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...
2015-09-14
631 reads
Finding the worst running query in a stored procedure
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...
2015-09-22 (first published: 2015-09-10)
4,863 reads
Where you should start when managing an enterprise
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us...
2015-09-11 (first published: 2015-09-08)
1,864 reads
Learning Regular Expressions
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term...
2015-09-02
962 reads
The default instance has a name
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but...
2015-09-07 (first published: 2015-08-31)
3,279 reads
The 30 minute rule
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule....
2015-08-26
671 reads
The tail of the log
The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that...
2015-08-24
654 reads
SSMS’s Clipboard Manager
The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask...
2015-08-28 (first published: 2015-08-19)
2,821 reads
Pulling data from the error log
The other day I was asked to pull a list of errors from the SQL Server log into a table...
2015-08-25 (first published: 2015-08-17)
3,436 reads
Blogs
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....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
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