SQL Server- Output clause

Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the...

The Kind of DBA I Want to Be

The Kind of DBA I Want to Be
Rokusaburo Michiba (Iron Chef Japanese)

I was a big fan of the original Iron...

SQL server the timeout period elapsed prior to completion of the operation

AdvertisementsSQL server clustering the timeout period elapsed prior to completion of the operation
Recently I faced one of our application could...

How to set the default replication agent profile

Over the last couple of years I've come to the conclusion that the default replication agent profiles just don't cut...

Actual Emails: Is "NOLOCK is the epitome of evil?"

Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a questionWilliam,

Can you send me references to support my contention that NOLOCK...

SQL Server – Modifying Production Data Good Practise

Q. “I need to modify Production Data directly on a Production database. What are some steps I can follow to...

S3OLV – Jan 2012 Meeting Recap

Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a S3OLV or SSSOLV). Presenting at that meeting was Josh...

S3OLV – Jan 2012 Meeting Recap

Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a...

Find the version of the Master DB from a backup

Try researching recovering the master database online and you will see countless references to having to have SQL at the...

Nooner Viewing Summary

Over the last few weeks, I’ve been watching SQL Server videos and webcasts.  My primary motivator in doing this is...