which are...

Good luck with the testing. Don't forget to size tempdb appropriately and not wait for autogrowths to size it for you.

Can you say which function call it was in the where clause and how you fixed it? Not sure I see it in your OP statement - or was...

Aditya-313343 (1/4/2011)

---

HI ,

Breif: Can some one plase suggest me how to lock a table when inserting data into it by a process,to make sure other process which might run simultaneously...

Thanks for the props Gail! Look forward to seeing you again at the MVP Summit in 7 weeks!

I didn't see anyone mention it yet, but RedGate has recently announced V2 of their Monitor product. It does quite nicely I think.

If you want something more high-end I...

As someone else said - installing SQL Server to a non-root drive still puts a LOT of crap in the root!! I would do one of two things: ...

You have unfortunately chosen a horrible storage construct for your data known as Entity Attribute Value Pairs. Your use of it is absolutely unscalable and there is essentially nothing...

6 out of 8 is likely a tad too high, but not enough to cause you problems like you are seeing. Only SQL - so you are not using...

1) WHY do you think you want to partition this table??

2) Partitioning is a VERY advanced topic that you have essentially no chance of doing completely optimally the first time...

ola.hallengren.com

that one is best IMHO because it offers up much more than just index maintenance stuff.

In my experience (which is a LOT when it comes to sql server perf analysis and tuning) the vast majority of async network io waits are caused by slow client...

calvo (1/4/2011)

---

This isn't a major issue just something I've been researching. Here's some background on my situation.

I have an admin database that I use to track performance and other items...

run sp_whoisactive (find it online) while the bad query is running to see what it is waiting on or blocking.

also look at the query plan it creates - you...

something like this:

select *

from namestable n 1

where exists (select * from namestable n2 where n2.name = n1.name and n2.address <> n1.address)