10-minute SQL: Filtered Delete: join vs. sub-select vs. exist

I was doing some simple tuning of procedures for a client when I came across some delete statements that I...

2012 PASS Elections Letter Of Recommendation From Karen Lopez

I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...

Active flag on the TCP/IP Properties page of SQL Server Configuration Manager

I’ve been unable to connect to a server via one of its aliases for about a week.  When I looked...

Finding and removing hidden characters in your data using dynamic T-SQL

It has been a long morning for me. It was supposed to be a standard run for our quarterly data...

How to Make SQL Server Listen on Multiple Ports

Have you ever needed an instance of SQL Server to listen on multiple TCP/IP port numbers but didn't know how...

Is Instance name SQLEXPRESS is fixed for Express edition only ?

A Question “SQLEXPRESS instance name is fixed for Express edition only ?” is running in my mind. SO I have decide...

Kathi Kellenberger speaking at Midlands PASS

On October 17th, Midlands PASS will welcome Kathi Kellenberger to speak on T-SQL 2012. Here's what her talk will be...

Presenting “PowerShell: Automating SQL Stats Collection”

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco...

Presenting “PowerShell: Automating SQL Stats Collection”

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco...

Presenting PowerShell: Automating SQL Stats Collection