No, nothing really. Statblobs are very...

DTA will usually recommend multi-column stats. SQL will automatically create single column stats only.

That said, test out all of its recommendations (including the indexes) before making the changes in production....

I know. Wanted to know the flavour (patch/hotfix level)

SELECT @@version

?

Brian.Dunat (1/23/2010)

---

This is the proper clustered index and it makes up the primary key on the table. This is a wealth management database, so the data that will be inserted...

Jeff Moden (1/23/2010)

---

When you go to reinstate the index, ask yourself, how many times do you insert into this table and will the inserts be done near the logical end...

Use REPLACE to remove the commas, then use CAST or CONVERT. Alternatively, you could cast first to the Money data type (providing it has sufficient precision) and then cast to...

CAST or CONVERT. See Books Online (the SQL help file) for details.

malleswarareddy_m (1/23/2010)

---

even i tried like this alo but i have unique identifier for a column name benfiaryid in the above result i want show the unqiue identfier for that colmun.iam...

Brian.Dunat (1/22/2010)

---

One other thing that I wanted to see if anyone has some knowledge on is doing these updates as part of a bulk update instead of having each update...

You have a thread for your question already, don't hijack other people's threads.

Hint:

A subquery that groups by whatever column 2 is called and does a filter HAVING COUNT(*) > 1

Glad you liked them

That is almost 800 lines of code. Do you really expect people to debug that volume of code without access to the DB or any of the tables references, or...

I suspect it has to do with that db coming from a beta version of SQL Server 2005. (RTM was 1399, hence 1187 must have been one of the late...