Viewing 15 posts - 3,886 through 3,900 (of 5,685 total)
Steve.hitch (2/25/2011)
February 25, 2011 at 11:05 am
Indianrock (2/25/2011)
We're on sql 2005 Enterprise and do have some indexed views in use. How would that work for this problem?
I think I know where Paul's going with that...
February 25, 2011 at 10:59 am
I'll give you a few hints if you'll answer my final question.
daveriya (2/25/2011)
February 25, 2011 at 10:56 am
SQL_Student (2/25/2011)
February 25, 2011 at 10:50 am
SQLLawman (2/25/2011)
February 25, 2011 at 10:29 am
Tom Van Harpen (2/24/2011)
You can check if the job is running before executing it. Let me know and I'll post the code.
Oh, no argument. I just wanted to know...
February 24, 2011 at 8:30 pm
opc.three (2/24/2011)
Here is why using the sp_ prefix for your proc names is a bad idea:
Hm, nice article find, OPC. Thank you.
To the OP: You can also have...
February 24, 2011 at 4:26 pm
Serge Mirault (2/24/2011)
How on earth is this possible if I COMMITTED the deletion in 10,000 record increments?
Do you have a higher level wrapper transaction?
Should the ROLLBACK only haved rolled back...
February 24, 2011 at 3:42 pm
Well, are you familiar with the modulo operator?
Such as:
SELECT ID FROM table WHERE id%10 = 0
February 24, 2011 at 3:35 pm
Tom Van Harpen (2/24/2011)
There may be a more elegant way of doing this but this would work.
Not really, that's the first thing that came to mind for me, too, though...
February 24, 2011 at 3:23 pm
jcrawf02 (2/24/2011)
Ian Scarlett (2/24/2011)
SQLkiwi (2/24/2011)
I hadn't realized until just now that 'Ten Centuries' was your age, not points rank :w00t:
I'm indestructable.
Hold on, you're probably too young to have seen Captain...
February 24, 2011 at 3:12 pm
GSquared (2/24/2011)
Craig Farrell (2/24/2011)
Education and Experience: Bachelor's degree in Computer Science, IS, or related degree, or equivalent experience. 5-6 years experience working with multiple...
February 24, 2011 at 3:06 pm
GSquared (2/24/2011)
... And for advertising something other than what's being sold, if beer ads were selling what they're advertising, Coors would be a national chain of brothels, not a drink.
And...
February 24, 2011 at 2:01 pm
Besides what G2 already mentioned above...
Education and Experience: Bachelor's degree in Computer Science, IS, or related degree, or equivalent experience. 5-6 years experience working with multiple database platforms, including...
February 24, 2011 at 1:54 pm
adam spencer (2/22/2011)
I mean I have to be able to access it in SSIS from a connection from server2. I would be...
February 23, 2011 at 1:15 am
Viewing 15 posts - 3,886 through 3,900 (of 5,685 total)