Lynn Pettis (3/22/2010)

---

Regarding my post above, if I missed anyone (Alvin, Jack, Bob to name a few) apologies. There have been so many that have helped me learn new...

In many cases that is correct. However, it seems that the...

I tend to agree with Jeff. To become proficient at TSQL, practice a lot. Try some complex requirement and find a solution for it.

If the changes have truly made it perform that much better, I recommend you make those suggestions directly to Microsoft on their Connect site. If they deem the changes...

amandix (3/22/2010)

---

Yes I’m aware of the risk… but since SQL 2000 to 2005 only work it out for the best. Must be a way to do the same in SQL...

I think you are creating more work for yourself and will make maintenance on the database a little more difficult.

http://www.developer.com/db/article.php/3622881/Basics-of-Statistics-in-SQL-Server-2005

That link discusses some of the workings of statistics. Statistics...

You're welcome.

amandix (3/22/2010)

---

Doing your suggestion, i can't move to step 5, because it didn’t change the original procedure and therefore when the system calls the sp, my changes would not be...

Since you have added logging to it, that is good.

Does the stored procedure run in a transaction?

Maybe encapsulate the statements in the proc within a try...catch block and output errors...

Jeff Moden (3/22/2010)

---

Gianluca Sartori (3/22/2010)

---

A consulting company here installed a SQL clustered Server with two nodes...

amandix (3/22/2010)

---

Thanks.

Here follows step by step (SQL 2005 solution):

1. Copy the mdf and ldf of mssqsystemresource and rename both with copy in the end “mssqsystemresource_copy.mdf” and “mssqsystemresource_copy.ldf”

2. Attach this...

The datasource is Oracle. The reportserver is obviously MS SQL. Which (source db or report db) is showing the contention/ blocking?

The Dixie Flatline (3/22/2010)

---

Jason, I just searched back through T-SQL QotDs looking for the string "Name" and couldn't find it. 🙁

I distinctly remember some of the odd things...

In follow up to Waynes post, please document the Cluster Names, Node Names, Group names and let us know what they are (so proper advice can be given).

Also, it would...

Silaphet Mounkhaty (3/22/2010)

---

Dear SQLGuru,

I have two flat files that we process nightly say file1.txt and file2.txt. We process file1 at 12:45am and file2 at 4:45am nightly. The size of file1...