Megistal (5/4/2012)

---

Thanks Grant,

It works exactly as you described. It even works when using FORCESEEK (as it should as Microsoft stated)

It would be nice having an index hint that force index...

That's not one I've hit on all the 2012 installs I've done. I'd suggest taking it to Microsoft. Go through support or post it as a Connect item.

A backup is a bit-by-bit copy at the page level of the database. No way to single out objects from it, at all. You have to script this.

700 stored procedures...

Glad the book is useful.

Not that one though. This one is out soon.

Index intersection is rare and hard to demo. I have a demo of it in my query tuning book, but it's pretty contrived. You won't see it in the wild...

Lynn Pettis (5/3/2012)

---

SQL Kiwi (5/3/2012)

---

Lynn Pettis (5/3/2012)

---

Not...

Sean Lange (5/3/2012)

---

Just an observation and a friendly reminder.

/soapbox on

We are starting to lean too far to the arrogant side with many of our replies (and yes I am guilty...

Replication & log shipping are going to require you to upgrade the servers involved, so no, you have to do a full upgrade. SSAS & SSRS can be installed seperately,...

SSIS is just like the database, you can't go backwards on the versions, so you'll have to move them by hand too.

In addition to data types, make sure you...

Take a look at Amit Banerjee's write-up on that wait type[/url]. It might be a less than optimal measure due to how it accumulates artificially.

I would not create an ID column just so that you can add a PK and make it clustered.

However, I would probably make one of the other two indexes into...

GilaMonster (5/2/2012)

---

When an index is being rebuilt online, it does not take any¹ locks. That means other processes can read the indexes and other processes can run inserts, updates and...

Ben-425648 (5/2/2012)

---

Grant Fritchey (5/2/2012)

---

Wow that's messed up. The estimated rows are different even though the values are the same. It looks like the variables, despite the recompile and the sniffed...

Wow that's messed up. The estimated rows are different even though the values are the same. It looks like the variables, despite the recompile and the sniffed values, are still...

Bhuvnesh (5/2/2012)

---

aaron.reese (5/1/2012)

---

I have run the Alter Index ()... Rebuild .... Script and activity monitor is showing the reindex as being blocked by another process (activity shows as...