Viewing 15 posts - 38,806 through 38,820 (of 49,571 total)
Have you checked that the database is been restored to the large drive and not to C?
May 31, 2009 at 3:09 am
_simon_ (5/31/2009)
Thanks for your reply, I changed my code, hope it is OK now:
You sure that a customer's name will be unique?
What indexes should I create on table BillOfMaterials?
Very hard...
May 31, 2009 at 2:56 am
Stupid question, but is there enough space on the disk for the files you're trying to put there? It's possible that the restored database will be larger than the backup...
May 31, 2009 at 2:53 am
You should not be trying to backup the SQL data and log files using NTBackup. The files are locked by SQL server and either NTBackup will skip them or it...
May 31, 2009 at 2:51 am
WayneS (5/30/2009)
The thing that bugs me, that I don't really understand, is:In any of these conditions, the best plan is to do an indexed seek.
Yes, but if it does the...
May 30, 2009 at 8:32 am
You could always take the DBs offline as you finish the backups. That way no one would be able to make any transactions. It may make the downtime more, but...
May 30, 2009 at 8:29 am
The data pages are backed up as the backup process reads them, so pages early in the file may be as they were at the beginning of the backup, pages...
May 30, 2009 at 2:12 am
Update statistics just updates the column stats on the table.
Rebuild index rebuild the specified index, removes fragmentation and then updates the stats for that index.
May 30, 2009 at 1:54 am
The procs that you're calling (CreateTrace, AddEvent, AddFilter, StartTrace) aren't system stored procs. They code for them should be in that article, if not, the author should have posted them
Check...
May 29, 2009 at 2:31 pm
Ken Simmons (5/29/2009)
IIf you upgrade a database from SQL Server 2000, the PAGE_VERIFY value will be NONE or TORN_PAGE_DETECTION. If it is TORN_PAGE_DETECTION, you should change it to CHECKSUM.
And...
May 29, 2009 at 2:25 pm
More shameless plug: http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/
Grant, is your book still available for download anywhere?
May 29, 2009 at 2:25 pm
Have you updated all statistics since the upgrade?
If that doesn't help, please post the query, the table definition, all the index definitions and the execuion plan (saved as a .sqlplan...
May 29, 2009 at 2:10 pm
Kit G (5/29/2009)
So the statistics either on or off won't affect what rows get returned for a query, like it isn't going to miss any rows because statistics weren't updated
No,...
May 29, 2009 at 2:07 pm
Kit G (5/29/2009)
GilaMonster (5/29/2009)
Gut feel is that those bad stats are going to bite him but he probably...
May 29, 2009 at 1:35 pm
Viewing 15 posts - 38,806 through 38,820 (of 49,571 total)