More Bloopers for Memorial Day

It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in...

Optimizer Timeouts with XQuery

I was looking at performance of a database and I noticed a few of the plans were very large and...

SQL Query Run Time Estimation

A followup to a post about subqueries with an estimation for how long it would take for the query to...

Can Scrum work for the DBA?

Agile! Scrum! Development methodologies! Sprint!

If you have a manager who reads any web page about being a manager, then you...

SqlHerts–26th May 2011

Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay.  Its a true pleasure to...

Accidentally Dropped the Distribution Database

Have you made the mistake of dropping your distribution database like this?

If so, remember not to do this ever again. ...

ACID Rules in Sql Server

ACID Rules
ACID Rules:- It is a concept for evaluation of databases and their architecture.
A:- (Atomicity) – Atomicity  states the principle of  All...

DML, DDL, DCL, TCL in SQL Server

Different Types of Sql Statements:-
DMLDML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert...

Restoring a database from higher version to lower version SQL server

AdvertisementsRestoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There...

Using Views for Faster SQL Query Development

A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...