Viewing 15 posts - 7,981 through 7,995 (of 22,219 total)
I'm very busy working right now. Didn't just see that corner kick by Cameroon. Nope. Working on an article for Red Gate. That's what I'm doing.
"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
June 13, 2014 at 10:26 am
Yeah. Those cost estimates can be quite high for fairly simple queries that won't benefit from parallelism. Bumping up the default value is one of the first things I do.
Well,...
"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
June 13, 2014 at 10:19 am
Anyone else getting real weird formatting in the text box when replying to posts? It's all squished over to the left side of the screen.
"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
June 13, 2014 at 6:52 am
I've done all the looping outside the procedure.
"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
June 13, 2014 at 5:52 am
Adding to Kevin's list, what's the compatibility level of the database? Have you generated an execution plan on the 2008 box and the 2012 box to figure out what's different?
There...
"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
June 13, 2014 at 4:17 am
I don't trust the DTA recommendations on anything. It makes way too many suggestions and misses really obvious ones. You'll note that it almost never suggests a clustered index or...
"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
June 13, 2014 at 4:11 am
Functions on columns like that are a common code smell. They will prevent the use of statistics or indexes and will result in full table scans to satisfy the criteria....
"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
June 13, 2014 at 4:08 am
You're just showing us parameter sets. We can't tell anything about what's happening inside the stored procedure based on a set of parameters. We need to see the actual SELECT......
"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
June 13, 2014 at 4:06 am
A WHILE loop? No, I haven't done that sort of testing at all. It's not something I'd write within T-SQL or expect to perform well, natively compiled or 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
June 13, 2014 at 3:50 am
Suresh Arumugam (6/12/2014)
SO, do you mean that even if there are 500 tables in Sybase, we need to manually add source and destination data flow...
"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
June 13, 2014 at 3:48 am
Dave62 (6/12/2014)
OCTom (6/12/2014)
...Any bickering between developers and DBAs is childish and is counter-productive to the goal of delivering quality.
Tom
BUT THEY STARTED IT!!!
:hehe:
Winner of the Internet this morning. Well done!
"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
June 12, 2014 at 7:20 am
IT researcher (6/12/2014)
GilaMonster (6/12/2014)
IT researcher (6/12/2014)
"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
June 12, 2014 at 7:19 am
IT researcher (6/12/2014)
Why?
SQL instances don't need to be rebooted daily. Hell, I know of instances that have been running over 6 months.
The SQL server instance is used by...
"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
June 12, 2014 at 7:02 am
GilaMonster (6/12/2014)
IT researcher (6/12/2014)
The sql server starts everyday at 8:30 AM and stops around 9:30 PM.
Why?
SQL instances don't need to be rebooted daily. Hell, I know of instances...
"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
June 12, 2014 at 6:47 am
OCTom (6/12/2014)
Any bickering between developers and DBAs is childish and is counter-productive to the goal of delivering quality.Tom
THIS!
"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
June 12, 2014 at 6:43 am
Viewing 15 posts - 7,981 through 7,995 (of 22,219 total)