Viewing 15 posts - 39,556 through 39,570 (of 49,571 total)
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
By the sound of it you have a...
April 23, 2009 at 1:47 pm
If you want to compare physical reads you need to clear the data cache, not the procedure cache.
Checkpoint
DBCC DROPCLEANBUFFERS
The checkpoint will write all dirty (modified) pages to disk. The DROPCLEANBUFFERS...
April 23, 2009 at 1:44 pm
Naveen Kumar Tiwary (4/23/2009)
If I am going for a Cluster Index can I include a extra column to that as suggested?
It won't be necessary. Take a look at the architecture...
April 23, 2009 at 1:07 pm
Physical reads = from disk
Logical reads = from memory
April 23, 2009 at 1:06 pm
Jesse McLain (4/23/2009)
April 23, 2009 at 11:43 am
Default autogrow on data and log
No indexes or constraints on Products. The cluster on Main is going to fragment quite badly, depending how often the inserts/updates are.
Product price is inconsistent...
April 23, 2009 at 11:15 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 23, 2009 at 11:09 am
To restore to a point in time with log backups you need a full backup and all of the log backups (unbroken chain) from the full backup up until the...
April 23, 2009 at 10:40 am
Alvin Ramard (4/23/2009)
hmmmm...Where would one look for examples of bad SQL? (I'm ducking to avoid flying pork chops) 😀
My presentation from last year had some made up bad...
April 23, 2009 at 9:49 am
dev_programmer (4/23/2009)
Please give me some practise papers that would allow me to judge myself with various sections of sql server 2005.
As i said, the only 'free' practice papers that you're...
April 23, 2009 at 9:02 am
http://sqlinthewild.co.za/index.php/2009/04/11/pass-summit-submissions/
You need the following:
- Your biography
- A title (eye catching or at least intriguing)
- Short abstract
- 3 goals of the presentation
- Requirements - what people need to know to follow
-...
April 23, 2009 at 8:17 am
dev_programmer (4/22/2009)
where can get practice test papers for free as i cant afford the amount asked.
The vast majority of 'free' practice test papers that you will find are 'brain dumps',...
April 23, 2009 at 8:09 am
Hmm, looks like you have one of the parts of a striped backup. It commonly happens when a backup is taken through management studio and there are two (or more)...
April 23, 2009 at 7:49 am
Bob Hovious (4/23/2009)
Thanks everyone, I truly hope I can be in the audience for some of your presentations.
You didn't submit an abstract?
April 23, 2009 at 7:38 am
If you've already restored the full backup, you can't go back as the restore would have overwritten the existing database. You can just run the following to bring it out...
April 23, 2009 at 7:35 am
Viewing 15 posts - 39,556 through 39,570 (of 49,571 total)