I looked up the dump using

and i was able to find the 2nd sql stmt but not the first. Thanks...

Background:

We have performance testing env, where we run 12 hour load tests. Next morning we analyze and find out a deadlock. Application executes 7-8 dml statements in a transaction (...

To avoid logging in once, add registry entry and use a service account.

Manually add the host key registry entry to [HKEY_USERS\S-1-5-21-3505284427-344095049-820599171-1160\Software\SimonTatham\PuTTY\SshHostKeys] where the SID in this case corresponds to the...

What happens if you restart from Configuration Manager ? Do u get the same error ?

I think thats because of the IMAGE datatype column which you are using in ur table.

What is the OS on the active directory ?

Can you add the login vice versa to what you are trying to do ? May be the trust is just 1-way.

This...

Here is my understanding:-

1. There are 3 delete statements on the same table.

2. One has a UPDATE Lock on the page and the other 2 have a INTENT-EXCLUSIVE locks on...

The join with balancetable results in more rows than btty table. So when u join all 3 tables in a big join there are duplicate rows which sums the duplicate...

There is no reason to avoid clustered index. You should ahead and create one on the same partition function, so that you have a aligned clustered index. But remember there...

Try

dtutil /SQL "Company List" /COPY FILE;"K:\SSISPKGS\Company List.dtsx" /Q

sp_who2 'active' returns all the active connections which are runnable.

If there is an application with a connection pool of 25 connections but is no queries are being execute via these...

I think what is happening is : one of the articles in your publication is encrypted \ using the database master key. So when the transactional replication tries to synchro...

Design your partition table in such a manner that you always split a partition which contains no data. Same goes with Merge. Otherwise your split and merge operation will consume...

Can you put some more information.

I know 3 ways of detecting high CPU usages :-

1. In Windows 2003 Server, you can configure the perfmon logs to be written directly to a SQL table. What you...