Having some problems using the SQL Server Health and History tool. We have a mixture of SQL Server 2005 (standard and EE) and I'm using SQL Server...
According to BOL you can configure an Alert based on the the Blocked Process Threshold configuration parameter, but I'm having some problems figured...
We have a group of jobs that are scheduled on SQL Server and managed by a team of developers. In SQL 2000 we created an account the development team...
We have a 64 bit server with 4GB of RAM and I'm installing SQL 2005 standard edition. I'm looking for recommendations on what to set the maximum...
Each morning we take a backup of a production database and restore it to another database for reporting purposes using a RESTORE REPLACE. This job...
We have a server with a single raid five array for all data files and tlogs. We've been having a discussion concerning the merits of creating...
I've just inherited a canned package that has a couple of real performance stinkers. There are two SQL Servers. Server A is for internal access,...
I have a server with 4 CPU's and 8GB of memory. The OS is Windows 2003 32 bit. I'd like to install SQL 2005 64 bit, but the server admins aren't...
If running SQL Server 2005 32 bit on a 64 bit Windows 2003 OS with 8GB of RAM, what needs to be done to allow SQL Server to address memory above...
Can I install 64 bit SQL 2005 and 32 bit Reporting services on the same server? We are installing MOM and 64 bit Reporting services is not...
Does anyone have a link to a white paper or website with information on conducting a performance Audit in SQL 2005?
I'm selecting three columns from a SQL table: survey_respondent question_number answer I need to put these into an Excel document with respondents...
We have a SQL 2005 Server with an hourly tlog backup job scheduled. The server was taken down last night for maintenance and one of the hourly tlog...
I recently migrated one of our databases used by a third party application to new hardware and I'm setting up the logins and passwords in the new...
Our production instance has not been recycled in over 6 months and the SQL Server Log (not the transaction log, the SQL log) has grown so large that...
We store our database/Tlog backups on a separate set of physical spindles, but we are running out of room due to rapid database growth (200GB). Does...
I've always been told that an average disk queue greater than 2 per disk needs to be investigated. How do you determine this when the disk in...
I recently migrated some user tables from Access to SQL Server while leaving the forms, reports, and queries in Access with Linked tables to the SQL...
I'm trying to figure out a way to use the new DDL trigger functionality along with one of the dynamic performance views (sys.dm_exec_sessions?) in...
Separate names with a comma.
