SQL SERVER : SQL Server Scheduler
While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....
2012-07-12
8,740 reads
Blog Posts
SQL SERVER : The Scene Behind NOLOCK
I have heard many time people talking about the NOLOCK hint. Some of them says it improves the performance and...
2012-07-12 (first published: 2012-07-04)
6,758 reads
SQL Server DBA Tool Kit
Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...
2012-07-12
1,078 reads
SQLSaturday #158 Event Update & Hotels - Where are you staying?
Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...
2012-07-12
1,687 reads
SQLTreeo is suspended
Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...
2012-07-12
827 reads
Stress Testing Stored Procedures with Free Tools
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...
2012-07-12
1,513 reads
Understanding the CDC State Value
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
2,224 reads
Columbia Enterprise Developers Guild meeting tonight
If you're in or around the Midlands of South Carolina area, the Columbia Enterprise Developers Guild meets the 2nd Wednesday...
2012-07-11
954 reads
Decryption and CASTing
In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...
2012-07-11 (first published: 2012-07-03)
3,413 reads
Different ways to move Sql Server file location
Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons,...
2012-07-11
1,023 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name