SQL Server Database SUSPECT state

According to BOL , a database in SUSPECT state is : “At least the primary filegroup is suspect and may be damaged....

Slides & Samples from my SQLbits sessions

As
I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK,
you can find here the
Slides & Samples for...

SQL Saturday 85 Follow Up

Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve...

Dataset with Text or Stored Procedure

As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get...

SQL Saturday 97 has ended

Well it isn’t quite over for me just yet, I still have a flight home tomorrow and can’t wait to...

An Informal Compendium of SSAS Errors, Part 3: Unresolved Errors

This is the second in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...

Live Blogging SQL Saturday #97 Austin (hashtag #sqlsat97)

Hello and welcome to my live blog/recap of SQL Saturday #97 in Austin! Wes Brown and the crew from CACTUSS...

How to find out which Table is not having rows in SQL Server?

Introduction
Many times while tuning our production databases we might try to find out the list of tables not having even...

October Question: What one thing do you feel has the greatest impact on SQL Server’s performance?

When it comes to databases, many DBAs obsess over performance, and for good reason, as when user’s begain to complain...

24 HOP recordings

For all of you, that you have missed any session from the last 24 HOPass - you can check here

24 Session...