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?

It's not that computers don't store what you tell them to. In this case it's storing exactly what you told it to. A float is an approximate number. It's not...

I was just looking at this stuff:

Target Server Memory (KB) and Total Server Memory (KB)

Target Server Memory indicates the total amount of dynamic memory SQL Server is willing to consume....