Well that one just yacked me off but good. He may as well be quoting from my posts because I'm "guilty" of all the "crimes" he listed. But hey, don't...

Mangal Pardeshi (3/4/2009)

---

Please!!!!!!!

I must confess, my that comment was with one of the poster with not all of you guys.

I observe that one such member is just looking for increase...

Mangal Pardeshi (3/4/2009)

---

Sooner the better.

The rating thing, hard to know. I think if you consistently answer poorly,...

Something. That isn't closing it's connections. Could be SQL, could be something else. Probably something else.

That sounds like some app isn't closing it's connections. Lots of open connections will certainly chew up memory eventually.

It can be yes. If you look through the white paper though they're using DMV (dynamic management views) which give you a lot more detail that you'll get through the...

Stamey (3/3/2009)

---

The individual objects, like when you need to duplicate a table real quick. Used to be simple to do with SQL 2000, you got the same window as if...

Hmmm... Well, have you tried looking at the wait states and queues? That's where I'd go next. See what everything is waiting on. Here's an excellent article on it: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

One issue I've seen repeatedly with linked servers is running the query such that the filters are processed on the SQL SErver side. This requires that a SELECT * be...

Stephanie Smith (3/3/2009)

---

I am trying to query a table that has several records for each employee. Everytime there is a change to an employee in the application, a new...

I don't understand the question. Do you mean generating individual TSQL scripts through the GUI?

2005 & 2008 are pretty much the same. Where are you hitting issues?

Backup and restore works just fine. You can also detach, copy and attach as an upgrade process. Whichever you end up doing, just make sure you run it through the...

GilaMonster (3/3/2009)

---

Not with it, but Management Studio Express...

I would say both approaches are valid. You need to do what your business defines. You're already on the right track, make sure you update the statistics and defrag the...

You need to be sure that your string data is defined as unicode so that you can define the character set as well as the values. This means NVARCHAR and...