Viewing 15 posts - 1,876 through 1,890 (of 22,227 total)
Serious question for the Thread.
What do you need that I could do to help you out right now? I don't mean give you my toilet paper supply. I mean 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
March 23, 2020 at 9:41 am
Strongest possible consideration, completely ignoring your SSRS question, don't do it. Don't upgrade to 2014. It introduces problems without good solutions. 2016 or better is the way to go. It's...
"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
March 18, 2020 at 9:31 am
Now you've gone and done it - I need to boil my laptop now.
In keeping with the tenor of the times, I'm just throwing mine away rather than take...
"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
March 17, 2020 at 12:12 pm
Using Sql trace i was able to get the Username but not the Query origin.
You mean the application that made the call? Unfortunately, those are optional values in a...
"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
March 16, 2020 at 11:58 am
do NOT poke the mighty Grant on the subject of Extended Events. I learned the hard way.
He beat me like a naughty stepchild (methaphorically)
but on that version you 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
March 16, 2020 at 11:30 am
Heh... Hi! My name is Jeff. Grant has a problem with SQL Profiler and I can't fix Grant! 😀 😀 😀
HA!
And why you want to?
"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
March 13, 2020 at 6:43 pm
Backups!
Always first. Test them. The only good test is a restore.
Next, statistics maintenance. Understand how your data modifications affect your statistics and then put necessary statistics updates in place to...
"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
March 13, 2020 at 10:46 am
You simply do your best. If you are not allowed to use all the tools, then you use what you can and ask for help when you need 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
March 13, 2020 at 10:40 am
I have had to pass the parameter in to an internal variable that matches it exactly, and just assigns the value over. That made a HUGE difference when I...
"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
March 13, 2020 at 10:36 am
the only way I can see you doing that is setting up a profiler trace that saves to a table.
Ha! Gotta post this. I saw you recommend Profiler 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
March 13, 2020 at 10:32 am
Cursors in cursors? Serious anti-pattern here. I'd strongly recommend reassessing the approach.
"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
March 13, 2020 at 10:26 am
Sorry, had to step away for a presentation. I agree with the suggestions so 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
March 12, 2020 at 4:15 pm
Close off the connections or restrict access to the database would be the best guess I have. Probably you just need to plan on tearing down & rebuilding the AG...
"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
March 12, 2020 at 11:32 am
Can you show the code where the function is used? That will allow people to understand the context in which they have to work. Otherwise, the answer is, pull 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
March 12, 2020 at 11:31 am
Last I read the EU has reached out to the Airports about this. The reason they're flying the planes is because of the "use it or lose it" attitude...
"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
March 11, 2020 at 11:04 am
Viewing 15 posts - 1,876 through 1,890 (of 22,227 total)