Finnaly I found the problem, it was an application account(with sysadmin) preventing me to connect in single-user mode. Thanks again for you...
I was able to get the SQL Cluster in single-user mode using just the Instance name : sqlservr.exe -m -s <Instance_Name> Now I have another problem...
Hi MohammedU, It is not working : With : sqlservr.exe -m -s <tcdpp7xxxxx>$<yyyyyy> I get "The syntax of the command is incorrect" With :...
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...
Hi Satya, Collation at database and table level is the same. We can't force the same collation at the server level because the subscriber has...
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...
I will do so. Thanks Joe
Sorry 4 CPU's and 3 GB
Hi Joe, Yes the query completes in 10 minutes but the 10 CPU's are at 100% during this time. This is not my query and I don't know why they don't...
Hi Joe, Do you know how to convert substring(convert(char,dbo.tran_tb.tdt-7,20),1,13) to datetime ? Thanks
Thanks joe, This is the execution plan : RowsExecutesPhysical OPRowsIOCPUCOST 231NULL75,349NULLNULL256,749 231Compute Scalar75,3490.000256,749...
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...
Thanks for your information. I will try to check them to the application team. Cristian
Hi, I got this server to investigate a performace issue on the SQL Server and I have no idea how the Access application was build. I got 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 Luis, If I filter by duration it is posible that I will loose some stored procedures which are using the same tables(indexes) as the "big" ones?...
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...
Satya, Actually it is not posible to use the same publisher(server) with two distribution databases. You could have only one distribution database...
Separate names with a comma.
