Which One’s Better?

During a recent webcast, someone asked if, in an EXISTS query, it is better to use “SELECT *”, “SELECT ‘1’”, or...

Worst Day of a DBAs Life

Red Gate Software is running a campaign around coping with the worst day of a DBAs life. We’ve been posting...

[BP017] DELETE statement without WHERE clause

Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...

Collaborated Training: What Legacy Will You Leave?

My very first IT job was a bit daunting for me. I really wanted to do my best but I...

Editorial: Cloud Skills

Cloud Skills is the editorial today, thinking about the changes we see in the boxed product versus the cloud and...

Free SQL Training In Sacramento

In a few short days the newest SQL Saturday event.  This one will be on the far West coast of...

Free SQL Training In Sacramento

In a few short days the newest SQL Saturday event.  This one will be on the far West coast of the United States. This marks the first time for...

How to change TempDB system Database files location?

Steps to change TempDB system Database files location :-
1) Check current file location of TempDB
Exec SP_helpDB TempDB

You can use below...

How to change TempDB system Database files location?

Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location...

Last Weeks Top “Reading” Links #91

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...