Viewing 15 posts - 3,031 through 3,045 (of 5,678 total)
New Nickname: Evil Steve. There's an E in my last name somewhere. 😉
[rant]
Anyway, having done a number of interviews lately (as a consultant, go figure...) I'm sick and bloody...
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 8, 2011 at 4:08 am
wta306 (6/7/2011)
I have about 3 yrs...
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 7, 2011 at 5:08 pm
wta306 (6/7/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 7, 2011 at 3:04 pm
GilaMonster (6/7/2011)
The client-from-hell is no more.
Hopefully that doesn't mean the same for your general employment? Either way, still less stressful.
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 7, 2011 at 11:35 am
davidsalazar01 (6/7/2011)
Your suggestions are great. I wanted to know if either one had some time today or this morning and would be willing to connect to...
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 7, 2011 at 11:29 am
Do the count as a subquery and join to it to avoid the outer query caring about it.
Do what Jason recommended below, much cleaner.
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 6, 2011 at 5:05 pm
m_cg (6/6/2011)
Someone else addressed the quote that it appears to remind 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 6, 2011 at 5:00 pm
Bill Tidwell (6/6/2011)
Craig,The quotations in your footer have peaked my interest. Who is Douglas Adams?
BT
http://en.wikipedia.org/wiki/Douglas_Adams
Author to "The Hitchhiker's Guide to the Galaxy".
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 6, 2011 at 2:50 pm
If 17k works and 20k doesn't, set the default max rows to 15000 and give it a try.
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 6, 2011 at 11:36 am
calvo (6/6/2011)
GSquared (6/6/2011)..."Billion" means two different things on different sides of The Pond.
wow. I was about to question this when I looked it up, totally threw me for a loop.
How...
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 6, 2011 at 11:35 am
SQLRNNR (6/6/2011)
Agreed - just making sure I'm not giving off anti-war undertones.
You can be pro-war and still want to see the people you know safe. Double bonus.
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 6, 2011 at 10:58 am
Phil Parkin (6/6/2011)
Aargh, Farrelled again! 😀
ROFL! I don't think I've ever heard my name used as a verb before...
... well, not for anything good. 😉
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 6, 2011 at 10:55 am
davidsalazar01 (6/6/2011)
Day 1 (Monday):
Select getdate() and the last 2 months
Day 2 (Tuesday):
Select getdate() and the last 2 months
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
June 6, 2011 at 10:55 am
Have you thought about storing the configuration in SQL Server instead of in an XML File? Then you can just update the configuration values via T-SQL procedure before kicking...
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 6, 2011 at 10:23 am
Sachin Nandanwar (6/6/2011)
I am reading one book on SQL Server internals.When explaining the checkpoint process it states that
"....If the LSN of the dirty page is greater than the LSN...
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 6, 2011 at 10:09 am
Viewing 15 posts - 3,031 through 3,045 (of 5,678 total)