SAT_SQL (6/17/2009)

---

HI

This is regarding the Trace & DTA.

Question:

1)

I am working in sql-2005,If i want to no that weather the Trace is running...

I think you've already hit the best option, use trace events to see what calls have come through. You can also query the system cache to see what's there, but...

You might want to post this in Scripts area (look to the left, just below forums on the menu choices). It's more likely to be found by people looking for...

Yeah, I was going to suggest SQLCMD as well.

Plus, why are you manually opening all kinds of windows in SSMS to do manual updates all day long? You should be...

As far as documentation goes, use the stuff that comes with VSTS:DBE. It's pretty complete, especially on installs.

You wouldn't need to uninstall Visual Studio to install the Team Edition. It...

Excellently stated. I wish I had been able to come up with these exact arguments a year ago when one of our major projects started down the object database path....

A foreign key constraint can only be placed on a primary key or on a unique constraint. So, if the parent table has another column that you can place a...

GSquared (6/15/2009)

---

Not sure what you mean. I...

Our plans are to perform most of our upgrades as side-by-side upgrades, meaning we install a new server with SQL Server 2008 and then backup & restore the 2000 databases...

No. It can't be changed.

If you need perfectly synchronized incrementally increasing numbers, you should come up with a mechanism to create them. That's not the purpose of the Identity column....

This is such a common problem. Rather than trying to roll your own queries every time you need to do this, pick up one of the third party tools that...

TRACEY (6/15/2009)

---

Got the defaults here. Cost thershold for paralleisum 5 and max degree of paralleisum 0, max worker threads 0

Processors 8 CPU

processor affinity ...

GilaMonster (6/15/2009)

---

I honestly wouldn't bother, unless you want to use it for UG presentations. The chance of it changing from alternate to accepted is slim. I mean, how many presenters...

Crap, The Thread passed me this weekend and I didn't even notice. It's officially the 15th highest poster on SSC now.

GilaMonster (6/15/2009)

---

When I got the invitation to submit a spotlight I just changed one of the existing ones from general to spotlight. Was easier than coming up with a new...