Viewing 15 posts - 4,921 through 4,935 (of 5,685 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...
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...
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...
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...
November 16, 2010 at 12:14 pm
da-zero (11/16/2010)
Craig Farrell (11/15/2010)
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. ...
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...
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...
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...
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...
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. 😀
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...
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...
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...
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...
November 15, 2010 at 3:17 pm
Viewing 15 posts - 4,921 through 4,935 (of 5,685 total)