Viewing 15 posts - 7,471 through 7,485 (of 7,488 total)
dmoldovan (3/20/2009)
kevin.l.williams (3/20/2009)
March 20, 2009 at 1:23 pm
Chris Harshman (3/19/2009)
Ben Leighton (3/19/2009)
if the SET READ_COMMITTED_SNAPSHOT is set to on for the database you are using then the query will return 1 and 2...
I'm...
March 20, 2009 at 10:15 am
I guess what's improved my efficiency is remote access technology: the internet,VPNs ,VPDNs, remote desktop. VOIP. Without some of these I would have real problems with systems on...
March 20, 2009 at 9:11 am
I'm very much in the clean up camp. I have an inviolable rule that the only access applications have to the databases is to stored procedures, so that I don't...
March 2, 2009 at 7:45 am
noeld (2/3/2009)
Suppose you need to prevent changes on ONE table while you are doing some maintenance work...
February 3, 2009 at 2:51 pm
Somewhat incomplete answer: an important part of the sp is the option to raise or not raise an error if the sysname parameter is invalid. (unless that has changed in...
January 26, 2009 at 3:03 pm
J (11/6/2008)
No. YOU ARE wrong.
It does not matter if there are duplicates or not, because the question specifically mentioned that there were no duplicates.
So "UNION ALL"...
January 26, 2009 at 2:49 pm
For SQL 2000 (and the question explicitly includes "before SQL 2005") there is no way of specifying ignore_dup_key for a primary key. Any attempt to specify "with ignore_dup_key" in...
January 26, 2009 at 2:44 pm
It threw me. I assumed SSMS would behave the same way as isqlw so gave the wrong answer. I'm inclined to consider the SMSS behaviour a bug, as making...
January 26, 2009 at 1:03 pm
Piotr Rodak (11/22/2008)
The Hash Match operator that is used whenoption (hash union)
is used apparently sorts data anyway, just NULLs are added to the end of the output.Piotr
The hash...
January 26, 2009 at 11:55 am
TheSQLGuru (1/6/2009)
.... here is a quickie example. as the number of rows (or joins) goes up it gets much worse
....
This example may be rather misleading, depending on...
January 6, 2009 at 1:48 pm
Matt Whitfield (1/6/2009)
January 6, 2009 at 5:19 am
David McKinney (1/2/2009)
ANY SOLUTION based on sysdepends isn't going to work.
The obvious solution based on sysdepends - running alterproc for the SP with no changes before using sysdepends - works...
January 2, 2009 at 1:43 pm
TheSQLGuru (1/2/2009)
1) Tom, can you or anyone else give an example of UPDATEs that cannot be done without using the FROM clause that can be done with it's use?
2) I...
January 2, 2009 at 12:09 pm
Jeff Moden (1/1/2009)
npfitzner (1/1/2009)
Tom.Thomson (1/1/2009)
He wants to remove the From clause from the Update statement? Seriously?No - I think that's what the 😉 was for.
🙂
Yes! ...
January 2, 2009 at 5:57 am
Viewing 15 posts - 7,471 through 7,485 (of 7,488 total)