Make sure you copy *all* the code (notice there is a scroll bar).

Thank you.

DECLARE @xml XML;

SET @xml =

N'

VenuGopal

...

Gift Peddie,

Would you like to explain how the fact that the (deprecated since 2005) UPDATETEXT and WRITETEXT statements don't work with AUTO change tracking relates to your statement about the...

Alex (9/13/2009)

---

Perhaps I've missed something but this is a bug in SQL Server, right?

Sad to see that Select-*-bashing has reached a point where genuine bugs aren't called bugs anymore if...

Unlearning the (+) syntax is painful at first. The SQL-92 syntax is rather easier to use and read, once you become familiar with it.

The following link to the official...

Both approaches (cascading deletes and custom procedures) have strengths and weaknesses.

In a well-designed database, cascading triggers are often to be preferred since the server implements all the necessary checks and...

You could do worse than read:

http://msdn.microsoft.com/en-us/library/ms345382.aspx

and

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

Start Here

Paul

Activity Monitor has taken a major step backward in 2008.

Sadly it is so far unchanged in R2 🙁

Adam Machanic has written some awesome code, which I strongly encourage you to...

To illustrate Jeff's point:

SELECT SQ.char1, SQ.char2

FROM (

SELECT char1 = 'a',

...

Any chance of posting some detail?

It would be helpful to know exactly what the procedure contains, the definitions of the objects it references, the number of rows in each, and,...

Not really. My original comment was purely light-hearted.

Just a small something to add: I notice your script includes SET ANSI_PADDING OFF.

Books Online

---

In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications...

Gift Peddie (9/12/2009)

---

No however Varchar(max) comes with large value types out of row option which is either ON or OFF if OFF then when your data is more than 8000...

Using the OUTPUT clause of the data modification statement is much to be preferred in many...