Viewing 15 posts - 4,921 through 4,935 (of 5,678 total)
WayneS (11/16/2010)
When doing this, I do get an interesting missing index hint on my method to use TestDate / AccountNumber. I've changed the PK to this combination.
My concern for this...
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 16, 2010 at 1:29 pm
Some larger scale tests:
10k account, 1 year (400 days) 10x time diff. 31312 vs. 341944
Test done for 10000 unique accounts with 400 days of data, with 4/10...
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 16, 2010 at 1:17 pm
I've only had to seriously work at googlescale once. The company did a tremendous volume of broadcast sampling. I'm being vague because I'm still not sure those NDA's...
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 16, 2010 at 12:29 pm
Offhand, I'd say your 8 users on Server2 are doing a lot of ad-hoc queries with ordering and the like going on.
Drop a serverside trace on Server2 catching Batch Completed...
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 16, 2010 at 12:14 pm
da-zero (11/16/2010)
Craig Farrell (11/15/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
November 16, 2010 at 12:11 pm
Hey Wayne, I would have to disagree regarding speed, especially with a secondary filter item, like an AccountNumber. I've generated a harness in a simplified real use format. ...
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 16, 2010 at 11:34 am
Alvin Ramard (11/16/2010)
Chris Morris-439714 (11/16/2010)
WayneS (11/16/2010)
Chris Morris-439714 (11/16/2010)
Thanks guys. I'll leave him be, he's had enough prompting.Think he'll PM you again for more help?
No idea, Wayne.
That really freaked me...
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 16, 2010 at 10:53 am
Junglee_George (11/15/2010)
Can anyone explain SQL Server Query Hints in detail, in a simple fashion.
A paradoxial request. They are not simple if you get into the details. The others...
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 16, 2010 at 10:04 am
Danster (11/15/2010)
What would have taken me about half an hour in good old SQL 2000, has now wasted about 2 days 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
November 15, 2010 at 5:34 pm
Trey Staker (11/15/2010)
Take care of yourself as you are taking care of work, home and the other thousands of obligations you have.
That 'other thousands of obligations you have.' is 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 15, 2010 at 5:24 pm
LutzM (11/15/2010)
Learner1 (11/15/2010)
HAHAHAvery funny
What's so funny?
Based on the "rules" you prvided, the IDENTITY approach is valid.
I believe that was aimed at me, Lutz, not 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
November 15, 2010 at 3:56 pm
Since it had been a while since I looked this up and I hate saying "I kinda remember x, y, and z, good luck!"... I did a bit of...
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 15, 2010 at 3:51 pm
Easiest way would be with a Tally table (see my sig) to build out a quick calendar table between the start and end date, and then look for nulls in...
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 15, 2010 at 3:41 pm
qew420 (11/15/2010)
Hi,(Step I) I'm building a Package where I need to run Query to update a table say "mytable1"
Mytable is a tmp table
You're already in trouble. SSIS...
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 15, 2010 at 3:22 pm
Digs (11/15/2010)
A view, I understood a view was a no no !Question how can I use a procedure to populate a SELECT ??
Views are not the anti-god. They are...
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 15, 2010 at 3:17 pm
Viewing 15 posts - 4,921 through 4,935 (of 5,678 total)