Viewing 15 posts - 19,321 through 19,335 (of 22,202 total)
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...
November 3, 2008 at 7:30 am
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...
November 3, 2008 at 6:46 am
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...
November 3, 2008 at 6:41 am
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...
November 1, 2008 at 1:13 pm
Or cast to a decimal.
An integer represents a whole number without decimal places: 0, -1, 23432.
October 31, 2008 at 7:58 am
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 ...
October 30, 2008 at 12:02 pm
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...
October 30, 2008 at 11:58 am
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,...
October 30, 2008 at 8:24 am
TheSQLGuru (10/30/2008)
Grant Fritchey (10/30/2008)
I'd add one more:5) Use the OPTIMIZE FOR query hint to get a plan based ona good parameter.
That still gets you a bad plan for "non-good" parameters....
October 30, 2008 at 7:50 am
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...
October 30, 2008 at 6:57 am
abhinav_k13 (10/29/2008)
Once the developers create content on the dev server(functions/ stored procedures)which is currently integerated with the...
October 30, 2008 at 5:41 am
I'd add one more:
5) Use the OPTIMIZE FOR query hint to get a plan based ona good parameter.
October 30, 2008 at 5:28 am
Is that accuracy without precision or precision without accuracy?
October 30, 2008 at 5:27 am
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...
October 29, 2008 at 12:55 pm
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....
October 29, 2008 at 11:53 am
Viewing 15 posts - 19,321 through 19,335 (of 22,202 total)