Viewing 15 posts - 2,896 through 2,910 (of 5,678 total)
LutzM (6/24/2011)
One of the (undesired?) side effects: once you have a specific SET DATEFIRST in your batch, any following...
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
June 24, 2011 at 2:39 pm
This is a lot easier if we had some sample schema and test data to show you proven code. See the first link in my signature for help on that.
Generically:...
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
June 24, 2011 at 1:51 pm
All the data in the world doesn't have any value if it's not used. In a security context audit data isn't all that useful if it's only examined when an...
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
June 24, 2011 at 1:24 pm
jvskarthick (6/24/2011)
I have a variable and it’s used in my all stored procedure. I want to replace the variable value with new one. Is there a way we can replace...
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
June 24, 2011 at 1:08 pm
tfifield (6/24/2011)
Craig,I've ripped off a lot of your code. Nice to see I got one in!
Todd Fifield
:blush: Now, that's a compliment. Thank you. 🙂
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
June 24, 2011 at 1:06 pm
Hm, favorite drink?
At the moment, that would be a Sake Bomber with Sapporo... at least, that's what I'm looking forward to. I usually drink Stella, Heinekin, or Beck's.
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
June 24, 2011 at 12:43 pm
BCLynch (6/24/2011)
If my...
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
June 24, 2011 at 12:38 pm
Oliiii (6/24/2011)
A provider asked us how they could hide all their design from us (dba), the short answer is they can't....
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
June 24, 2011 at 12:34 pm
Jeff Moden (6/24/2011)
Craig Farrell (6/23/2011)
This conversation resparked a curiousity on my part.
When I run that code as a single unit, it keeps returning the following error...
There is already an object...
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
June 24, 2011 at 12:23 pm
BCLynch (6/24/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
June 24, 2011 at 2:15 am
Jayanth_Kurup (6/20/2011)
Try lookup under the DFT
Wouldn't work for this. Lookup is a per-row operator and he needs to collapse the rows. The only way to do that is...
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
June 23, 2011 at 6:21 pm
GilaMonster (6/23/2011)
ORs are fully SARGable, they just require a very different indexing setup than AND. http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/Also note that the parser/algebratiser expands IN into a series of OR before optimisation begins.
Hmm,...
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
June 23, 2011 at 6:07 pm
:crazy: Erm, um... no?!
Okay, there's apparently a little confusion here. The log is going to fill, constantly, even over a restart in any recovery mode besides simple. In...
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
June 23, 2011 at 5:58 pm
I always point folks to this one:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
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
June 23, 2011 at 5:35 pm
This conversation resparked a curiousity on my part.
The following was tested in a 2k8 R1 environment off my local drives. End result, and if you read the notes you'll...
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
June 23, 2011 at 5:31 pm
Viewing 15 posts - 2,896 through 2,910 (of 5,678 total)