Viewing 15 posts - 1,786 through 1,800 (of 5,678 total)
Brandie Tarvin (2/15/2012)
bitbucket-25253 (2/15/2012)
Brandie Tarvin (2/15/2012)
bitbucket-25253 (2/15/2012)
Brandiego here
HA! That's exactly what I need. Thanks. @=)
Now, now be honest is it the chocolate or the Martinis or maybe a...
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 15, 2012 at 2:35 pm
mythilimca89 (2/14/2012)
i can't understand the question:w00t:
I assume you're joking? If not, what in particular can't you understand?
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 14, 2012 at 12:21 pm
Sean Lange (2/13/2012)
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 13, 2012 at 12:25 pm
jdamm (2/13/2012)
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 13, 2012 at 12:24 pm
GSquared (2/13/2012)
kschwid (2/13/2012)
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 13, 2012 at 12:22 pm
To add for a moment to Paul's well answered posts, the Snapshot Isolation won't save you from the necessary locks for Truncate, but will save you from the necessary dirty...
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 13, 2012 at 11:58 am
cengland0 (2/13/2012)
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 13, 2012 at 5:56 am
Koen Verbeeck (2/12/2012)
Nice question Craig, thanks!
Thanks. I was concerned that I wouldn't explain the components well enough. Hopefully the scenario is clear and this doesn't end up as...
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 12, 2012 at 6:52 pm
I'm afraid I have to agree with Hugo on this one. The wording of the question left me to believe it was intended to mean "without using specific hints"....
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 10, 2012 at 3:43 pm
Roy Ernest (2/10/2012)
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 10, 2012 at 1:29 pm
bitbucket-25253 (2/9/2012)
Koen Verbeeck (2/9/2012)
Revenant (2/9/2012)
L' Eomot Inversé (2/9/2012)
MysteryJimbo (2/9/2012)
HowardW (2/9/2012)
MysteryJimbo (2/9/2012)
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 9, 2012 at 1:44 pm
+1 for allocating a different drive for TempDB. C:\ is usually where your OS, installs, and Swapfile go. If tempdb starts getting hammered and memory drives the swapfile...
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 9, 2012 at 12:36 pm
A) Dynamic SQL should be used sparingly and with a specific intent to optimization, otherwise: kill it with fire. Even then, # tmps work just as well in dynamic...
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 9, 2012 at 12:20 pm
At a guess it's parameter sniffing and coming up with a generic plan that's 'bad'.
Check out this blog by Gail Shaw for more information:
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
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 9, 2012 at 12:16 pm
print dateadd( ss, 60, DATEADD(hh, -6, DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)))
OR
print dateadd( n, 1, DATEADD(hh, -6, DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)))
n = minute, m = month.
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 9, 2012 at 12:13 pm
Viewing 15 posts - 1,786 through 1,800 (of 5,678 total)