Viewing 15 posts - 21,406 through 21,420 (of 26,490 total)
You don't need EE for what you want to accomplish.
What you need to do is create a new filegroup on your database and put that filegroup and file on the...
April 20, 2009 at 12:52 pm
Dave Hoogendoorn (4/20/2009)
April 20, 2009 at 12:42 pm
Depending on the query, parallelism may not be best. More processors may help by allowing additional queries to be processed at the same time.
Test your query again but with...
April 20, 2009 at 11:56 am
I am pretty sure you can't drop the indexes on just specific partitions, as indexes are created on just specific partitions. It's an all or nothing type of thing.
April 20, 2009 at 11:52 am
You are thinking human readable here. If that is the issue, then I'd build views over the tables with the columns in the "proper human readable order" and have...
April 20, 2009 at 11:47 am
Personally, I'd go with option 3. The location of the columns in the table is not relevent. If you want to keep things close together for the developeres,...
April 20, 2009 at 11:11 am
Griffster (4/20/2009)
Makes sense that.Do you have a link I could navigate to to read your article please? Interested in increasing my knowledge of this part of sql.
Not at this...
April 20, 2009 at 10:35 am
One reason I used a dynamic tally table was simple, what if you didn't already have one or you called it by another name such as Numbers? By doing...
April 20, 2009 at 10:16 am
Griffster (4/20/2009)
Lynn Pettis (4/15/2009)
declare @StartDate datetime,
@EndDate ...
April 20, 2009 at 8:21 am
Paul White (4/19/2009)
I have edited out my rant because the transaction was rolled back, and therefore it never logically existed.Anyone who saw it must have been experiencing 'dirty reads'.
😉
Paul
Took your...
April 19, 2009 at 11:41 pm
Paul White (4/19/2009)
Lynn Pettis (4/19/2009)
April 19, 2009 at 10:04 pm
And, as a final thought before I leave. As a professional, I must admit when I was wrong. Paul, I was wrong. Please except my apologies. ...
April 19, 2009 at 9:21 pm
You know, it's been a long day, I think it's time to get some sleep. Maybe then I can re-engage in a more meaningful dialog and hit the right...
April 19, 2009 at 9:17 pm
Paul White (4/19/2009)
Lynn Pettis (4/19/2009)
NOW I SEE IT. Looks like I got the wrong QUOTE >ARRRRRGGGGG!!!!! I apologize, most profusely.
50 lashes with a wet noodle!
Now I'm confused :unsure:
Perhaps I'll...
April 19, 2009 at 9:04 pm
Viewing 15 posts - 21,406 through 21,420 (of 26,490 total)