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,419 reads
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,419 reads
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,248 reads
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,557 reads
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,808 reads
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,104 reads
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,027 reads
On the first day of DBA hell, the server gave to me
A database with damaged system tables and no good...
2010-06-15
954 reads
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,336 reads
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-23
10,815 reads
Or “Shot gun query tuning”
There have been a fair few forums questions in recent months asking for help in removing...
2010-03-11
429 reads
This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...
I recently graduated with a Master’s in Strategic Communication from the University of Delaware....
By Steve Jones
Recently I was trying to delete a folder and kept getting the “something is...
Hello I have a query that works as a loop but it is slow....
If my server has dashes seems like that is throwing an error -serverinstance at-ts-cblsql ...
Hi, What's happened to this product has it now become Flyway?
There is an Automated Patching service for VMs running SQL Server in the Azure Cloud. This uses the SQL Server IaaS Agent Extension to work with PowerShell. What types of patches are installed with this service? Note: All updates are marked with tags, such as Important, Critical, or something else
See possible answers