Hi

I use the standard report "Index usage statistics" in ssms. I analyse the Index usage statistics and the Index operational statistics to determine the degree of usefulness of an index.

It does depend how your delete query is doing.

If it makes a table scan for the rows to delete then it can cause a table-level lock.

If it uses an index...

The fact that his delete had been waiting to commit tells you that it's not a snapshot isolation level in use.

Thanks for this Gail!

The question "... so he can see the reads/writes used by his queries ..."

Info for logical, physical, read-ahead, ... is given.

What about the writes?

I set

SET STATISTICS IO

and made thousand...

What about in "Computer management"? You should have two menu-nodes "SQL Server Configuration Manager". Under each "SQL Server Configuration Manger" you should have "SQL Server network configuration (32bit)" and "SQL...

Don't underestimate any job. What if I were your manager and I told you to develop code to restore databases from one server to another automatically, so any time we...

Suarez

Too easy, but it's Friday 🙂

+1

Thanks too

Hi

When you make changes to the executable you can recompile the SP.

You could also create the SP with recompile option, so it removes and creates new plans for next...

Jack Corbett (6/10/2014)

---

First you have to define what you mean by fast.

My first suggestion would be to batch the updates using explicit begin and commit tran statements and...

..and what is your desire for the second row?

Hi

You reseed the identity columns with the following command

dbcc checkident('YourTable',reseed,reseed_value)

you can set the reseed_value = -1 and the identity starts from -1, otherwise it by default starts from 1.

Reference http://technet.microsoft.com/en-us/library/aa933196(v=sql.80).aspx

Hi

Did you try to find out the value for which the conversion is failing?