Viewing 15 posts - 2,371 through 2,385 (of 5,678 total)
Jeff Moden (11/1/2011)
You're already at the "leading" row during an UPDATE... add it to the SUM.
Calculate...
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
November 1, 2011 at 12:35 pm
Heh, I wonder if we're thinking along the same lines Jeff. I'm currently puzzling out a rolling window mechanic that should only need one (maybe two) passes on 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
November 1, 2011 at 3:10 am
Jeff Moden (10/31/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
November 1, 2011 at 3:05 am
Jeff Moden (10/31/2011)
Evil Kraig F (10/31/2011)
Jeff Moden (10/31/2011)
Kiara (10/31/2011)
Jeff Moden (10/29/2011)
Any interest in a bit of table redesign that will greatly improve performance for this particular query? One 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
October 31, 2011 at 7:30 pm
L' Eomot Inversé (10/31/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
October 31, 2011 at 7:26 pm
gcresse (10/31/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
October 31, 2011 at 6:51 pm
gcresse (10/31/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
October 31, 2011 at 6:31 pm
rka (10/31/2011)
Dummy Management Unit PO BOX 999 Dept of Energy, Training and The Arts CITY EAST DummyState 9999,
Unit 1/100 Dummy Street, DummySuburb,...
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
October 31, 2011 at 5:58 pm
Welsh Corgi (10/31/2011)
Thanks Kraig.
My pleasure. You're correct though, you do want NOCOUNT off, but that's standard for me (sorry, was pseudocode above). FMTDATA setting is only needed under...
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
October 31, 2011 at 5:55 pm
Ten Pounds of Knowledge, One pound bag. Lesson one: Learn the keywords and what it can do, and lookup how to do it after. Eventually the methods will...
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
October 31, 2011 at 5:40 pm
Jack Corbett (10/31/2011)
Evil Kraig F (10/31/2011)
SQLRNNR (10/31/2011)
HAI have no aspirations of catching Steve in the next year, let alone 3 years.:-D
You guys are looking at a race, I'm trying 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
October 31, 2011 at 5:36 pm
Jeff Moden (10/31/2011)
Kiara (10/31/2011)
Jeff Moden (10/29/2011)
Any interest in a bit of table redesign that will greatly improve performance for this particular query? One that will give the reporting performance...
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
October 31, 2011 at 3:51 pm
SQLRNNR (10/31/2011)
HAI have no aspirations of catching Steve in the next year, let alone 3 years.:-D
You guys are looking at a race, I'm trying to figure out how to grab...
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
October 31, 2011 at 3:49 pm
Yeah, it's fine except you have to put in a metadata component first.
SP as a data source runs into trouble when it's multi-statement, particularly if you use INSERT INTO #tmp....
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
October 31, 2011 at 3:47 pm
Banana-823045 (10/31/2011)
Is there more to the story behind wanting to manage number of total logins/users?
Yeah, it's one ROYAL PITA. You're not just on the hook at 2AM for server...
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
October 31, 2011 at 2:30 pm
Viewing 15 posts - 2,371 through 2,385 (of 5,678 total)