Thanks for the feedback.

How did you handle the apparently extra stuff at the end of the last error message?

This will get you the different errors. The issue is that the last error has additional information after the error message - you'll have to figure out how to remove...

Do you have a mirroring witness server? A log shipping monitor server? Is the snapshot offline? Are you having problems with the cluster failing over to standby nodes?

Check out your actual execution plan - that should point you to the offenders.

This is a pretty decent article for Comparing Table Variables to Temporary Tables[/url].

You can think of a CTE as a predefined sub-query, where it is defined just once instead of...

A few other things you can do with Redgate tools: you can use SQL Source Control, and source control the data in those reference tables. SQL Compare will work with...

How many rows are in Cln_ServiceInstPayer? Is there any particular reason that you don't have a clustered index on that table?

Koen Verbeeck (4/22/2011)

---

WayneS (4/22/2011)

---

Did you know that most windows programs (including SSMS; not Notepad) allow you to select COLUMNS of text? Position the cursor at the starting position, and while...

Koen Verbeeck (4/20/2011)

---

Stefan Krzywicki (4/20/2011)

---

Under your table name, click on the Columns folder and drag it to your query window and you get a complete list of all your columns....

sql2k8 (4/21/2011)

---

TABLE A values ...

Please read this article[/url] for how to perform running totals.

gonsas (4/21/2011)

---

Samuel Vella (4/21/2011)

---

Nice article, very concise (as a Spackle should be I guess)

The reason for this is simple, renaming the file in the dialogue box will not change the...

Good job Jason! (Heck, I really did like my solution, but this is so much better.)

LightVader (4/21/2011)

---

Is there an equally easy way to have the template on the network so all the developers in the company are using the same template (and it would only...

Samuel Vella (4/21/2011)

---

Another little tip when adding a template:

When adding a new item you might be tempted to change the file name in the Add New Item dialogue box.

DO NOT...