Viewing 15 posts - 3,316 through 3,330 (of 22,219 total)
Saluton, mia nomo estas Grant. Bonvolu pafi min.
"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
February 8, 2018 at 8:58 am
Great Googly Moogly.
Referencing a recent thread, and several of you know the one, I posted on Twitter that simply moving a query into a view will not improve...
"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
February 8, 2018 at 8:54 am
"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
February 8, 2018 at 6:45 am
Yeah, you've pretty much nailed the reason for it existing. The only trick is, can you readily isolate individuals within your system to limit them logically. If so, it works...
"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
February 8, 2018 at 4:52 am
Writing out a full fledged T-SQL for all that would be a full-time position and I ain't getting paid. Ha!
However, I'll offer a few pieces of advice. "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 8, 2018 at 4:50 am
Find a champion.
You want a high level person with integrity who will work with you and support your efforts. If it's family run, someone in the family. You...
"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
February 8, 2018 at 4:38 am
"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
February 7, 2018 at 7:40 am
We have a procedure which select from a lot of tables. Will there be any...
"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
February 7, 2018 at 7:12 am
I'd be interesting in know how - maybe it's not that obvious.
It was...
"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
February 7, 2018 at 7:06 am
"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
February 7, 2018 at 7:02 am
Get a copy of SentryOne Plan Explorer. It's free. Anonymize the plans (it'll clean the query & everything) and then post those. Otherwise, everything everyone is saying is just random...
"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
February 5, 2018 at 1:11 pm
This is the Minion mentioned above. Worth a look. It's a very viable alternative for most people.
"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
February 5, 2018 at 6:06 am
PBM is pretty amazing. Unfortunately it gets extremely little love from Microsoft. There have been additions to it with new functionality, but overall, it gets almost no attention. I don't...
"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
February 2, 2018 at 10:23 am
You might want to explore putting this into a columnstore index, see if that helps. It really depends on the types of queries being run against it, but pivoted storage,...
"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
February 2, 2018 at 7:14 am
Have you tried capturing sql_batch_completed and rpc_completed (maybe even toss in module_complete) using Extended Events? That's usually what I use.
"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
January 26, 2018 at 11:55 am
Viewing 15 posts - 3,316 through 3,330 (of 22,219 total)