First, the positives:

Way to go on pointing out that you need to validate data during the tuning process. This is something that it's far too easy to assume and doesn't...

Instrumentation into the TSQL code itself? Heck no. But we do use trace events to monitor our apps & databases & servers in development, qa and production, in order to...

Alvin Ramard (9/9/2010)

---

Jeff Moden (9/9/2010)

---

Alvin Ramard (9/9/2010)

---

Trey Staker (9/9/2010)

---

Steve Jones - Editor (9/9/2010)

---

Twitter is a lot like The Thread, only moving at a slightly faster pace.

You can sign up and...

The best way to do this would be to have two queries, one that just selects everything, without a WHERE clause, and one that selects based on the WHERE clause....

Looking at the counts.... I'd put my money on you pulling away.

For detailed answers, please do as Gail requested.

For a quick answer, I'd look at this:

and so_ref not like '% VS'

That will lead to serious slow performance since the only...

Not knowing exactly what you need, this might be off, but what about loading the update into a MySql instance and then using SSIS to migrate the data?

If it's structures...

WayneS (9/7/2010)

---

Steve Jones - Editor (9/7/2010)

---

Actually I picture Lutz as Wayne's...

Tom.Thomson (9/7/2010)

---

Grant Fritchey (9/7/2010)

---

I agree with Tom, but I'll go a little further, I wouldn't call it "bad", but I would do whatever I could to avoid that kind of...

ranjith.Ileni (9/7/2010)

---

I tried with the following query...But

select ename,sal AS maxsal,deptid

from employees

where sal in(select max(sala)

...

You can use ALTER INDEX for a nonclustered index to disable it. If you do this for a clustered index, it makes the data inaccessible.

ALTER INDEX myIndexName ON myTable DISABLE

Homework? Please show what you've tried and is not working.

Key words you might want to check out are GROUP BY and MAX.

Place your stored procedures, indeed, your entire database, into source control. Subversion is a great opensource product. Microsoft's Team Foundation Server (TFS) is fantastic as well. There are a number...

I agree with Tom, but I'll go a little further, I wouldn't call it "bad", but I would do whatever I could to avoid that kind of circular reference. It...

Just to emphasize, except for circumstances where the system is under extreme load, you should be able to run database and log backups without interfering with the users. Even in...