Viewing 15 posts - 5,446 through 5,460 (of 5,678 total)
chris.king (9/28/2010)
Thanks guys.I guess I'll have to live with the seven joins.
The only other option would be to de-normalise the data from Table B into Table A.
Chris
If the data from...
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
September 28, 2010 at 11:28 am
Can you alter the database engine/remote connections to local connections only via the surface area configuration? Will this work for the MDSE engine?
Best I can come up with. ...
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
September 24, 2010 at 5:44 pm
Double post, sorry. Dunno how I pulled that off.
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
September 24, 2010 at 4:54 pm
jordantx (9/24/2010)
The Widgets table has no clustered index. The WidgetDate field is the single most relevant column for searching/querying, however it can change often...
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
September 24, 2010 at 4:53 pm
Not sure what all you've looked into yet, sure you've exhausted a lot, buuut:
Is there a lot of databases on this server? http://support.microsoft.com/kb/316749 (near the bottom)
Looking at the error log...
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
September 24, 2010 at 4:16 pm
ken.trock (9/24/2010)
For now, nothing 😀 My report will produce counts in a given month for before and after the 1st ESN change in that month.Ken
So this also needs to be...
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
September 24, 2010 at 3:51 pm
jordantx (9/24/2010)
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
September 24, 2010 at 3:39 pm
Heh, sorry, for summary by column do all your row summary/setup the entire structure, then union to the tail (adding a hardvalued sortby column, per query, if necessary, to keep...
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
September 24, 2010 at 3:29 pm
Well, with no code, this is generic, but basically, put in a column that will add headers.
For example, if you pivoted across MON/TUE/WED/THU/FRI, and now want TOTAL, you'd put
[MON]+[TUE]+[WED]+[THU]+[FRI]...
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
September 24, 2010 at 2:53 pm
Sean: I've done ISS/SQL combined boxes before for dedicated apps/vendor apps before. It's not the optimal solution but it's doable if your userload isn't high. It's a special...
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
September 24, 2010 at 2:40 pm
as-534320 (9/24/2010)
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
September 24, 2010 at 12:51 pm
There's a catch-22 to being a DBA/SQL Server person and trying to instill 'customer service'. I agree, when the priority issue comes up and you've got the flying circle...
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
September 24, 2010 at 11:52 am
Gentlemen, a thank you for doing this entire thread publically. I'm relatively sure my brain is attempting an escape as I try to keep up with your experience 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
September 24, 2010 at 10:31 am
I got used to NY drivers. I drove a rig in the tri-state for a bit, and grew up there. They're not so bad, they're predictable. They're...
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
September 23, 2010 at 4:10 pm
Jeff Moden (9/21/2010)
Alvin Ramard (9/21/2010)
GilaMonster (9/21/2010)
Shawn Melton (9/21/2010)
I like this one:Knock Knock
Who's There?
sp underscore
sp underscore who?
spid1, spid2, spid3....
I told that one at a dinner at the PASS Summit a few...
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
September 21, 2010 at 10:41 pm
Viewing 15 posts - 5,446 through 5,460 (of 5,678 total)