Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .

First, in BOL, for "DBCC...

Super SQLSaturday #158 Summer Spectacular Event Update & Speaker Schedule!

 
When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent...

The New Phone Book Is Here!

I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....

The report execution has expired or cannot be found. [rsExecutionNotFound]

I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:
The report execution has expired or...

Using a Symmetric Key

In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?
5 Second Rule Doesn't Apply to Dropped Databases or Does...

A Fire Drill and Voter Registration

I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent...

Down and Dark

I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly...

Locking Behavior – Foreign Keys

With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any...

Preach The Gospel Always, If Necessary Use Words

I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may...