Viewing 15 posts - 6,961 through 6,975 (of 8,416 total)
Make sure you copy *all* the code (notice there is a scroll bar).
September 13, 2009 at 5:33 am
Thank you.
DECLARE @xml XML;
SET @xml =
N'
VenuGopal
...
September 13, 2009 at 4:42 am
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...
September 13, 2009 at 4:00 am
Alex (9/13/2009)
Sad to see that Select-*-bashing has reached a point where genuine bugs aren't called bugs anymore if...
September 13, 2009 at 3:02 am
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...
September 13, 2009 at 12:11 am
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...
September 13, 2009 at 12:02 am
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
September 12, 2009 at 11:50 pm
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...
September 12, 2009 at 11:43 pm
To illustrate Jeff's point:
SELECT SQ.char1, SQ.char2
FROM (
SELECT char1 = 'a',
...
September 12, 2009 at 11:37 pm
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,...
September 12, 2009 at 11:25 pm
Not really. My original comment was purely light-hearted.
September 12, 2009 at 11:04 pm
Just a small something to add: I notice your script includes SET ANSI_PADDING OFF.
Books Online
September 12, 2009 at 10:46 pm
Gift Peddie (9/12/2009)
September 12, 2009 at 10:43 pm
Jeff Moden (9/12/2009)
You might also want to lookup what OUTPUT does for you, as well.
Using the OUTPUT clause of the data modification statement is much to be preferred in many...
September 12, 2009 at 10:23 pm
Viewing 15 posts - 6,961 through 6,975 (of 8,416 total)