Gus, FWIW, I think you have an excellent list of steps to do. Can we get you to update this when you actually do move the databases to include those...

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

The optimizer would utilize the smaller index, since it knows it would have less disk IO to get the necessary information... and we all know that disk IO is THE...

Yep, good set-based code has this weird ability to usually run insanely fast. Glad you're learning (which is why we throw links at you instead of just telling you ......

ucbus 92278 (4/15/2010)

---

GSquared:

Thanks

No my company does not allow. Also it is too...

ucbus 92278 (4/15/2010)

---

. It might come down to checking the execution plan for this query... the query and/or indexes might need tweaking, and this could be causing the query to...

Yes, at...

You can also right-click the constraint (in SSMS), and select rename and do it there.

Roy, I'm sorry I wasn't clearer the first time around.:(

Not entirely sure what you're meaning with the not so common cases. You really shouldn't have a non-clustered index on the...

Alvin Ramard (4/15/2010)

---

CirquedeSQLeil (4/15/2010)

---

Which mtn...

Yes, I knew that. Everything I wrote applies with that concept.

GSquared (4/15/2010)

---

I'm setting up to move all the databases from an existing SQL 2008 Standard 32-bit server to an SQL Server Enterprise 64-bit server.

So far I've: ...

reset the server name...

ucbus 92278 (4/15/2010)

---

Our application uses a Stored procedure which formats an XML from the data retrieving from some 16 tables. The tables are hierarchial ( Parent-child-grandchild) with a single key...

Keep in mind that a clustered index IS the table, physically sorted by the key(s) of the index. A non-clustered index is just the key(s) of the index, and a...

You're pretty close. Check out GROUP BY in BOL.