In order to restore the master database in a SQL Server 2005 cluster(activepassive) I perform the next steps : 1. Identify the node SQL is running...
I have an application that is "heavy" using server side cursors and the performance is very bad for the last two weeks. I am seeing very high CPU...
Here is my problem : from time to time the data on a table used in replication is getting corrupted at the subscriber(transactional replication, push...
Hi, I have a query that is killing my 4 CPU production server. For 10 minutes the CPU's are going to 100%. The query is running against a single...
Hi, I need to export a table with an encrypted column(password). The problem is that sometime I have the {LF} character in this column(result of the...
Hi, I need to figure out why the performance on SQL Server is degrading. A small query which have 3 tables of 20 MB is running for 2 hours. I found...
Hi, I want to run Index Tuning Wizard for a 30GB database using a 200 MB trace file. The free space on the C drive is 8 GB and is getting filled up...
Hi, It is posible to use 2 distribution databases on the same server(publisher)? The server is configured to be both : publisher and distributor. We...
Anybody knows how to get a free version of Database Hammer or some other load testing tools ? Thanks
I created a table with the output of sp_lock and I added a new column object_name. Is there a way to populate ALL the object_name rows based on the...
Does anybody have a script to get the filgroups for all tables in a database Thanks
I have 8 GB RAM, and I selected MinMemory=MaxMemory=5 GB(AWE enabled), leaving 2 GB for the OS. The Process(sqlservr)Working Set = 84684800. So...
I want to reduce the % of the WRITELOG wait(now around 40%).Right now the log file is on its own array and is 2.5 GB. I am planning the next steps:...
I saw different comments on the subject of using from 2GB to 4GB of RAM on SQL Server. On the article : Configure memory for more than 2 GB in SQL...
I have a big database(mostly read-only) with a big transactional log(30 GB). We don't take SQL Server backups of this database. I plan to change the...
I create a DTS package to import a big table(50.000.000 rows). When creating the package I choose to drop and recreate the destination table instead...
If you need to create new tables and add them to existing snapshoot replication(SQL Server 7)is this posible using only EM ? What about the...
One of my database was marked "suspect". The error log gave me this error : 2003-10-22 03:09:30.20 spid61 SQL Server Assertion: File: <S:sql...
Hi everybody, In order to determine the right fillfactor for my indexes I used the two counters: Physical Disk Object: % Disk Read Time and Physical...
Hi everybody, Do you know how much overhead will add to SQL Server if you run remotely a Performance Monitor Log for 24 hours , collecting data every...
Separate names with a comma.
