maruf24 (8/5/2008)

---

Wat i hav found tht there is some change in java code as i m a dba ...

..... i dnt no wat are the changes has been made but...

Gareth (8/5/2008)

---

One simple question.

The main advantage of partitioning is the parellel processing you gain from it correct?

If so, then perhaps I need to make my partitions smaller so that multiple...

See BOL for example code for a login trigger. Check master.dbo.sysprocesses program_name column for their spid and you can know if they are using QA or not. If...

Nary, your example trigger is very flawed in that it doesn't handle multi-record actions.

mcloney (8/4/2008)

---

>>My point was to take away the "IN" clause and use a join or like some one else pointed out use "exists".

I hate to be a "me too" kinda...

Partitioning is a tool. And like all other tools it is only as useful as your knowledge and skill at implementing/using it. There are too many variables in...

maruf24 (8/3/2008)

---

i m hving a clusterd index on the column which cantain some duplicate records may be more than 1000 ....table contain more thn 10 millions of records....

when i...

1) IN clauses can be performance dogs. Try to rewrite query using EXISTS.

2) Post the actual execution plan and the IOs used here for review. We will need...

1) test and then upgrade to Cumulative Update 6 (or higher) to SP2 on sql server.

2) are you using lightspeed or another product to do backups?

3) run dbcc memorystatus and...

See this series for the definitive word on deadlock troubleshooting and resolution: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

If you aren't using Enterprise Edition, set sql server max memory to 2GB and see how that goes. If still get alerts, go with 1.7GB. If using EE,...

IMNSHO, trace flag usage should be reserved for addressing known, demonstrated problems that the trace flag is known to address. I do not recommend them for prophylactic purposes.

But again, unless there is a very specific reason to do so, performance is often better with all of the databases in one instance. SQL 2008 (EE anyway) will...

I would like to ask what you reasoning/justification is for having 5 instances on the same server. I can think of a number of reasons to NOT do this.

What you really need (and just like I and others told you on the public forums) is to hire a professional to assist you with the setup and configuration and...