I have been asked to adjust the full-text master merge so it occurs at a different time of day. It is my understanding the master merge happens...
I have a SQL Server 2005 active/passive cluster which has the quorum drive on a partitioned SAN LUN. I want to fix this and get the quorum drive on...
Does anyone have a good t-sql script to quickly delete several hundred databases?
I want to keep track of the processes that show up in sp_who2 as suspended. Is there a way to write a query against system tables to count and keep...
Does anyone have a script that will find schema changes? I want to create an alert that will send me an email when a user makes a change to the...
I need to be able to write a script to perform actions on a database and I need to be able to hand off the script to another user who might not run...
Is there a stored procedure or does anyone know an easy query that will return the accounts running the different services for SQL Server? I want to...
I am setting up server side tracing to find performance problems but I am running into a space problem. I have the trace setup to grow to 512MB and...
I am looking for a SQL script or a software package that will let me see the CPU utilization and memory used by individual SPID's on a database...
I have a large number of indexes that were created on temporary tables. The temporary tables were deleted by a scheduled SQL job but the indexes are...
I have a large database that I am having difficulty shrinking the log files with. Is there a way to use T-SQL to purge the log files so I can get...
Recently I upgraded a couple of my SQL Servers to run on Windows Server 2003. They are both SQL Server 2000 SP3a Enterprise Edition that have been...
A couple of weeks ago I replaced a database server with new, faster hardware. I moved the databases over and all the files associated with the...
Does anyone know of any SQL Server tools that are made for table partitioning? I heard that there is a tool that handles the table partitions and...
I'm looking for a way to map out usage of user tables in a database. I would like to find a way to track usage of a table over a 24 hour period so...
Just less than two week ago I installed a new server to replace older hardware. All of the databases were moved from the old server to the new...
I have an issue with a SQL Server backup that I can't figure out. The database is around 160GB in size and had been on a Windows 2000 Enterprise...
Is it possible to query the status of the SQL Server service or the SQL Agent service of one server from another? I want to be able to setup a check...
Is it possible to rename an instance of SQL Server? I have an application that has been taken off-line and rather than un-install the instance it...
I have a reporting server that I have been restoring each night from a backup of production but I'd like to switch this to either use log shipping or...
Separate names with a comma.
