Viewing 15 posts - 5,071 through 5,085 (of 22,219 total)
OPENQUERY and passing the parameters to the remote server versus just connecting the tables and letting all the filtering occur wherever (SQL Server can, sometimes, figure out how to filter...
"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 25, 2016 at 8:41 am
You should be able to spoof the query so that the views behave as if they were just a cross-database query. It won't be. It'll be a cross-server query 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
February 25, 2016 at 7:17 am
mcopa (2/25/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
February 25, 2016 at 7:13 am
Jeff Moden (2/25/2016)
Markus (2/25/2016)
Is it possible to run profiler and see what userid is connecting and running that query?
Agreed. Setting it up to find the name of the proc...
"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 25, 2016 at 7:08 am
Views is probably the best approach. You could also look at synonyms, but I'm not sure they'll work the same way in this situation.
"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 25, 2016 at 6:10 am
Kalen Delaney's book, SQL Server Internals, covers all this extremely 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
February 25, 2016 at 6:05 am
I agree with Gail, doing this stuff in Azure is the way to go. You're going to see more and more people in a hybrid environment anyway, might as 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
February 25, 2016 at 4:11 am
Alexander Suprun (2/24/2016)
tony28 (2/24/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
February 24, 2016 at 4:18 pm
What is running in an automated fashion every 30 minutes on the system? 3rd party backup software? Something? Kevin has a pretty good order for trying to figure out what'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
February 24, 2016 at 3:29 pm
Nothing is ever 100%, but no, in most cases you're only going to see some additional I/O, CPU & memory during a stats update. It doesn't put locks on 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
February 24, 2016 at 3:27 pm
Jeff Moden (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
jasona.work (2/24/2016)
/Me leans back, grabs bucket of popcorn
Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus...
"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 24, 2016 at 3:19 pm
You're not actually referencing partitions. Here's a good article on setting [/url]up sliding window partitions, which is almost what you're describing. The thing about partitions and partitioning is, that you're...
"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 24, 2016 at 11:50 am
I've been speaking publicly for 10 years and I still get nervous and, depending on who is in the audience, I can be intimidated. However, you just keep going. Remember...
"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 24, 2016 at 11:35 am
spaghettidba (2/24/2016)
Actually, I never perform cache analysis in production.I usually dump the whole cache to a table in my local sql server and start from there.
Good plan. And, 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 24, 2016 at 7:28 am
It's not magic. It has to be something. Either a SQL login that he has the password for, or he's in a group that's in a group that has access....
"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 24, 2016 at 6:50 am
Viewing 15 posts - 5,071 through 5,085 (of 22,219 total)