Viewing 15 posts - 4,411 through 4,425 (of 22,219 total)
I suspect this is an extension on the concepts around an ORM (Object-Relational Mapping) tool. Instead of writing T-SQL, you just access the API and the API generates any 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
September 21, 2016 at 6:32 am
I had this exact discussion with Adam Machanic once. We came down on the side, apart from index maintenance and storage (and we're ignoring some pretty big issues), as far...
"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
September 20, 2016 at 9:46 am
CELKO (9/19/2016)
"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
September 20, 2016 at 6:01 am
I'm not completely sure I understand the question.
You're saying that you use local variables instead of parameters?
What happens with this is that you are taking away the optimizers ability...
"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
September 20, 2016 at 5:59 am
That is a big number. Usually, but not always, that would indicate that the statistics are out of date or incorrect.
"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
September 19, 2016 at 7:38 pm
It's the table valued function, FullTextMatch. It says the estimated cost is zero, but I wouldn't believe that at all.
"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
September 19, 2016 at 12:43 pm
Can you post the execution plan? Save the .sqlplan file, not a picture. We need to be able to see the properties.
"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
September 19, 2016 at 11:28 am
You'd need to experiment with both. Usually, but certainly not always, a compound index is better. This is because the higher degree of selectivity caused by the compound index makes...
"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
September 16, 2016 at 10:19 am
BLOB_EATER (9/16/2016)
Grant Fritchey (9/16/2016)
Ken McKelvey (9/16/2016)
Further to Grant's post, even some basic monitoring of Latency, Waits and PLE once a month will show the way instances are heading:http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/
http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
http://blog.sqlauthority.com/2010/12/13/sql-server-what-is-page-life-expectancy-ple-counter/
I'd shy away...
"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
September 16, 2016 at 10:13 am
MiguelSQL (9/16/2016)
I said it was a bad idea because developers should generate their own test data, rater than use a copy of Prod that needs...
"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
September 16, 2016 at 8:05 am
Ken McKelvey (9/16/2016)
Further to Grant's post, even some basic monitoring of Latency, Waits and PLE once a month will show the way instances are heading:http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server/
http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/
http://blog.sqlauthority.com/2010/12/13/sql-server-what-is-page-life-expectancy-ple-counter/
I'd shy away from PLE. 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
September 16, 2016 at 8:00 am
SQL Clone will certainly help, but you'd still want to get the allocated space of the database down prior to using SQL Clone.
If shrink isn't going to work, 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
September 16, 2016 at 5:55 am
If you don't have monitoring in place, then I would start with capturing the wait statistics over time. You need to be able to compare them, today to yesterday, 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
September 16, 2016 at 5:48 am
Are you experiencing any other issues related to memory or disk? What are your top wait statistics? Are you experiencing performance issues. PLE, all by itself, doesn't really indicate much...
"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
September 16, 2016 at 5:41 am
Nope.
A temporary table is isolated by the connection that created it.
"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
September 14, 2016 at 9:08 am
Viewing 15 posts - 4,411 through 4,425 (of 22,219 total)