How to Read the Results of SELECT @@VERSION in SQL Server
The simple query SELECT @@VERSION can quickly tell you quite a bit about a SQL Server installation (and the underlying...
2010-01-07
4,151 reads
Glenn Berry
Early Reviews of New Intel 32nm Desktop and Mobile CPUs
Well, now that the holidays are over and the Consumer Electronics Show (CES) is nearly upon us, we are starting...
2010-01-04
646 reads
Denver SQL Server User’s Group Meeting on January 21
The Denver SQL Server User’s Group will be having their January meeting on Thursday, January 21, 2010. The meeting will...
2010-01-03
346 reads
A Small Collection of I/O Specific DMV Queries
It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many...
2009-12-30
4,238 reads
Windows ReadyBoost in Windows 7
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
2009-12-29
3,179 reads
Fun With DBCC FREEPROCCACHE
Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...
2009-12-28
21,901 reads
How To Get a Count of SQL Connections BY IP Address
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...
2009-12-28
5,182 reads
Should You Get a Netbook Computer?
On Monday, Intel officially announced the next generation Atom processors (aka Pineview) that are part of the new Pine Trail...
2009-12-23
579 reads
Two Tools For Discovering Hardware Information About Your Servers
One thing that I think is very important for a successful DBA to be aware of is their hardware environment. ...
2009-12-21
1,312 reads
Great Resource On SQL Server Wait Types
Microsoft's Bob Ward has updated his blog post about documenting SQL Server wait types, that came out of his work...
2009-12-21
932 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers