Fastest row counting method
SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...
2011-07-26
6,384 reads
Projects – Win Early
Project plans should try to plan for some unknowns. For large projects they include known risks, vacation time, maybe even...
2011-07-26
675 reads
My upcoming speaking engagements
A few days ago I had an interesting conversation on Twitter about my upcoming speaking
engagements. I really realized at this...
2011-07-26
793 reads
SQL Server, Chennai and Me
It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.
While...
2011-07-26
893 reads
Optimize a query by thinking out of the box
Recently I had to create a simple query to lookup a single row in a table containing ranges that do...
2011-07-26
624 reads
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,041 reads
Columbus GA SQL Server Users Group Webinar Tomorrow
I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that...
2011-07-25
1,310 reads
Get count of folders using Power Shell
More on my recent PowerShell project. I recon I have taken on the challenge to handle this entire request using...
2011-07-25
569 reads
How to move Cluster Quorum Drive
I recently had the need to move the quorum for a cluster to a new SAN drive. It’s a quite simple...
2011-07-25
2,591 reads
Speaking Schedule! I’m here (and there, and there…) to help
Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable...
2011-07-25
571 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers