Search Results

SQL Server performance monitor counters missing!

Thread by: niall.porter, Dec 12, 2006, 2 replies, in forum: Performance Tuning for DBAs

Hi all, I installed a second instance of SQL 2000 Enterprise onto our Windows 2003 Enterprise server last week to run as a dedicated instance for...

Kill Users script

Thread by: niall.porter, Sep 22, 2006, 1 replies, in forum: General DBA Questions

Hi all, Looking for a stored procedure that will kill SPIDs in a specified database. I keep seeing links to usp_KillUsers.sql on www.admin911.com...

Home grown log shipping, need some help please!

Thread by: niall.porter, Sep 21, 2006, 3 replies, in forum: SQL Server Log Shipping

Hi all, We have a pretty basic, home-grown log shipping setup. Until now, if for some reason the secondary server is unable to apply the latest log...

Indexes and Statistics

Thread by: niall.porter, Sep 20, 2006, 4 replies, in forum: Performance Tuning for DBAs

Hi all, I'm looking at ways of improving performance on our 200GB ERP database and one of the first things I noticed was that no reindexing or...

T-SQL in SQL 2005 requires full table names, why?

Thread by: niall.porter, Sep 14, 2006, 8 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi all, Just at the very beginning of looking at SQL 2005 here. I've copied our ERP database (minus most of the actual data) to our 2005 test...

re-applying old logs - dangerous?

Thread by: niall.porter, Sep 8, 2006, 3 replies, in forum: SQL Server Log Shipping

Hi all, Just a quick one for my first post - if I apply a transaction log backup which has already been applied to the database, will the...