INDEX DEFRAGMENTATION SCRIPT

Advertisements 
INDEX DEFRAGMENTATION SCRIPT for 2008 / 2005
I dedicate this article to my senior DBA “Roshan Joe Joseph” who has helped me...

Roundup: Un-SQL #001 – Branding

Hi-ho all, and a wonderful Un-SQL event it’s been!  We had at least twenty-six entries!! First, the recap:
While T-SQL Tuesday...

SQL server basics for beginners

Advertisements 
In this article, I am going to discuss about the basics of SQL server which is helpful for newbies.
SQL–Structured Query...

What’s New In Denali for SSRS

I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...

XQuery for the Non-Expert – Exist

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts

In the...

Cry, Baby, Cry! Failing the MCM Test

Two things happened to me this morning.  First, I woke up and took the written test for the SQL Server...

Defensive Db Programming Chapter 09

It is down to the final two chapters of the book by Alex Kuznetsova.  Check out the previous chapter here.  The review of this book is certainly taking longer...

Defensive Db Programming Chapter 09

It is down to the final two chapters of the book by Alex Kuznetsova.  Check out the previous chapter here....

Do Foreign Key Constraints Help Performance?

Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...

Have you ever wanted to train yourself?

Hey folks, we all know that there are some great training organizations out there (AHEM Pragmatic Works, AHEM). I hate...