I asked if the other objects being...

Congrats to your daughter Lynn. That really is an accomplishment. And its' one that fewer and fewer people can lay claim to any more.

I don't run perfmon all day, but I do run Microsoft Operations Manager 24/7 and it's consuming performance monitor counters. As long as you're not collecting too much data or...

You can use code and SMO to replicate what SSMS does, but no, there's not any easy way to do it with TSQL alone. Besides, SSMS is useful, just don't...

Rambler (10/7/2009)

---

Well, that might be a problem, since I'm not a DBA, I'm a sysadmin with not so deep knowledge of SQL.

I'm aware of the fact, that I'm comparing apples...

rockingadmin (10/7/2009)

---

Query 1:

both the tables will have unique values. that's y i make them as primary key.

can i make custid in table2 as primary key and create a composite...

Alvin Ramard (10/7/2009)

---

Lynn Pettis (10/6/2009)

---

Steve Jones - Editor (10/6/2009)

---

It's hard to stay in the top 5-10 here since you get points for questions. It seems that we'll have a few...

The problem is, because the systems are radically different, as well as different versions of SQL Server, you're comparing apples to cannonballs. Best advice is what the post above says,...

Follow the advice in Gails articles or pick up a book on performance tuning (<cough>, look down, <cough>). You need to gather metrics to identify where your bottlenecks are, and...

What about using VARCHAR(MAX) and use sp_executesql. According to BOL the @stmt parameter in sp_executesql is only limited by available memory.

sys.dm_exec_query_stats is what I would recommend as well, but remember that it only shows the queries that are currently in cache. If queries have been executed during the day but...

You should be able to see the operations that are taking so much CPU within SQL Server. If nothing else, take a look at sys.dm_exec_requests to see what operations are...

Are the other objects being referenced views or tables? You could start trying to figure out what's happening by looking at the actual execution plan for the query and the...

You'll be able to run three instances of SQL Server on this system, certainly. The question is, what will they be doing? How much data are you storing, how many...

2Tall (10/6/2009)

---

Hi Piotr. You were correct when run as a batch option 1 was 46%, option 2 54%, run individually each were 100% (which I suppose makes sense!). Not really...