Search Results

Post by: gopi19, Nov 14, 2003 in forum: General DBA Questions

Thanks Satya, The name is "Scheduler Differential backups(Morning)". The script inside the job is backup database scheduler to disk =...

Thread by: gopi19, Nov 13, 2003, 3 replies, in forum: General DBA Questions

I have a differential backup plan which creates differential backups every one hour from 6AM-6PM during Week days. Can any of You let me know the...

Post by: gopi19, Nov 13, 2003 in forum: Contribute Your SQL Server Scripts

Thanks Chris, Good to know You all and thanks for the participation. I am sure the SQL statements do not matter as there is no best coding. I am...

Post by: gopi19, Nov 13, 2003 in forum: Contribute Your SQL Server Scripts

Hi Chris, I updated the statistics using sp_updatestats on the user database as per Your suggestion. (I even ran the statement on master database....

Post by: gopi19, Nov 13, 2003 in forum: Contribute Your SQL Server Scripts

Thanks Chris, That is simply wonderful to have such a small statement. On a test database here, I created 19 tables having rowcount > 10000. Using...

Thread by: gopi19, Nov 12, 2003, 6 replies, in forum: Contribute Your SQL Server Scripts

This small script might be handy to find out tables having max rows, nothing great though. Run statements below from SQL query analyser. set...