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....

Yeah, post the actual execution plans, I think that's where you'll see the problem displayed clearly.

Steve Jones - Editor (10/29/2008)

---

No guns at work. Chances are we're run out of developers and have to go code things ourselves. Now truncheons....

I thought this was a little silly...

That's an awful lot of work for something you can get for free if you do one of two things. You can save your delimited string to a file and...

You can set up the logins one of two ways. You can create a SQL login (not recommended) which has a name and a password. Better is to set up...