The margin of error is, I believe, +-3ms. So anything within that range is not worth talking about. Other than that, it depends on the situation. I've had two versions...

You should also be looking at the execution plans to see how they're using/not using indexes. If you're getting widely disparate behaviors on one proc based on different data, you...

Alexander Kovacs (11/3/2008)

---

Grant Fritchey (11/3/2008)

All you're doing with the -+- operators is simple math, a + adds an equivalent value and a - takes it away. +++@param is the same...

I don't understand the question?

All you're doing with the -+- operators is simple math, a + adds an equivalent value and a - takes it away. +++@param is the same...

From the sounds of it, you're planning on testing against your production system. That's a huge mistake. The chances of messing something up are just too high (and I'm assuming...

I'm just horribly disappointed that Godzilla did so poorly at the polls. I really thought he would have a shot at it...

Clearly not nearly enough people recall the SQL Server...

Or cast to a decimal.

An integer represents a whole number without decimal places: 0, -1, 23432.

As long as it's not encrypted, you can restore the database using the RESTORE DATABASE syntax. From the BOL:

RESTORE DATABASE { database_name | @database_name_var }

[ FROM ...

I know you can change the threshold without taking the server offline. Based on the BOL, I'm pretty sure you can change the max degree of parallelism in the same...

Is it 8 processors or 4 processors hyperthreading? If it's the latter, I'd go with 4, the former, 7 and maybe set affinity.

Also, since this is an OLTP system,...

TheSQLGuru (10/30/2008)

---

That still gets you a bad plan for "non-good" parameters....

I was hesitant to answer because this almost sounds like a hacking venture, but... You can do a restore without having the user name and password. Once the database is...

abhinav_k13 (10/29/2008)

---

Thanks a lot Grant. That was really helpful. A followup question to this is

Once the developers create content on the dev server(functions/ stored procedures)which is currently integerated with the...

I'd add one more:

5) Use the OPTIMIZE FOR query hint to get a plan based ona good parameter.

Is that accuracy without precision or precision without accuracy?