Viewing 15 posts - 19,351 through 19,365 (of 22,226 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2008 at 5:28 am
Is that accuracy without precision or precision without accuracy?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2008 at 11:53 am
Yeah, post the actual execution plans, I think that's where you'll see the problem displayed clearly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2008 at 7:24 am
Steve Jones - Editor (10/29/2008)
I thought this was a little silly...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2008 at 7:15 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2008 at 5:55 am
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2008 at 5:51 am
Something else is going on. All things being equal, a static set of data and a static set of code is going to return the same values. As others have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2008 at 5:44 am
Brackets are the way to go. If you used brackets within custom coding work in or around TSQL for anything other than naming database objects, you might be in trouble.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2008 at 5:42 am
Viewing 15 posts - 19,351 through 19,365 (of 22,226 total)