Viewing 15 posts - 3,886 through 3,900 (of 5,678 total)
Steve.hitch (2/25/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 25, 2011 at 10:56 am
SQL_Student (2/25/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 25, 2011 at 10:50 am
SQLLawman (2/25/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 23, 2011 at 1:15 am
Viewing 15 posts - 3,886 through 3,900 (of 5,678 total)