Viewing 15 posts - 2,176 through 2,190 (of 5,678 total)
dan-572483 (12/1/2011)
What is the best way to run a slightly different query during certain hours?
I wouldn't vary the query, just vary the association. Easiest way to do...
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
December 1, 2011 at 5:46 pm
CELKO (12/1/2011)
The Dynamic SQL you posted is an admission of failure and incompetence.
Don't worry Celko, your continued posting is admission of failure on the part of evolution to remove the...
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
December 1, 2011 at 5:35 pm
Ugh, nasty. You need a row-repeater. Which means... To the TALLY!
Check out the link in my sig on tally tables if you're unfamiliar. They're nothing more then...
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
December 1, 2011 at 5:09 pm
fave_dba (12/1/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
December 1, 2011 at 4:47 pm
brian 20008 (12/1/2011)
I don't usually work with the XML execution plans so pardon me if it's not a clean post...
Brian, any chance you can bring up the actual execution plans...
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
December 1, 2011 at 3:37 pm
tacy.highland (12/1/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
December 1, 2011 at 3:07 pm
Lowell (12/1/2011)
( -- Get Non-Peer Categories without regard to Assignments
(esc.statusname != 'PEER' And @FilterAssigned = 0)
OR -- Get Non-Peer Categories Assigned...
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
December 1, 2011 at 2:45 pm
Unfortunately, you're going to need to do as mentioned, create a quick software in .NET (and friends) that can create a filestream, and append each row in order and rebuild...
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
December 1, 2011 at 2:11 pm
brian 20008 (12/1/2011)
Sorry, both Union and Union All take 5 plus minutes to run.
Can we see the .sqlplans for the two queries un-unioned and the unioned version?
Something's just not right...
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
December 1, 2011 at 2:06 pm
nico van niekerk (12/1/2011)
Of course, I should have attached the OPTIMIZED execution plan, too. Just an oversight, but here it is. This completed in 38 seconds.
Been there,...
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
December 1, 2011 at 1:58 pm
Two options. As Elliott already mentioned, you can use a derived column task to include the variable as the column you're looking for before getting to the destination. ...
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
December 1, 2011 at 1:41 pm
Grant Fritchey (12/1/2011)
Kiara (12/1/2011)
Brandie Tarvin (12/1/2011)
GSquared (12/1/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
December 1, 2011 at 1:31 pm
p-nut (12/1/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
December 1, 2011 at 1:30 pm
Hans80 (12/1/2011)
Anybody with an idea? The problem looks stupid and the solution will be simple... but I really don't see it...Thanks
What is the variable type you're using to store the...
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
December 1, 2011 at 1:28 pm
Jason Selburg (12/1/2011)
A UNION tells SQL Server to exclude any duplicate rows, which in turn requires grouping internally.If you are 100% sure no duplicates will occur, then use UNION ALL.
+1...
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
December 1, 2011 at 1:22 pm
Viewing 15 posts - 2,176 through 2,190 (of 5,678 total)