First Impressions
SELECT @@Version
Microsoft SQL Server “Denali” (CTP1) – 11.0.1103.9 (X64)
I’ve been playing with the CTP for a few days (with absolutely no...
2010-11-09
1,430 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
A Trio of Table Variables
So, it’s the second Tuesday of the month again, and it’s time for T-SQL Tuesday again. This month it’s hosted...
2010-10-12
1,272 reads
One wide index or multiple narrow indexes?
Or “If one index is good, surely many indexes (indexes? indices? indi?) will be better”
This is a question that comes...
2010-09-14
1,582 reads
Come and gone
Or “Plan cache monitoring – insert and remove”
Previously I took a look at the CacheHit and CacheMiss events to see how...
2010-08-31
1,821 reads
Hit and miss
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there...
2010-07-27
1,145 reads
Does a missing data file send a database suspect?
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,040 reads
DBA Hell
On the first day of DBA hell, the server gave to me
A database with damaged system tables and no good...
2010-06-15
967 reads
In, Exists and join – a roundup
Over the last several months I’ve had a look at IN, Exists, Join and their opposites to see how they...
2010-04-27
1,355 reads
Help, my database is corrupt. Now what?
The stuff of nightmares, a corrupt database. However Gail Shaw gives you some advice about how to handle this situation.
2010-04-23 (first published: 2009-02-16)
64,540 reads
2010-04-01
3,279 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