Viewing 15 posts - 5,071 through 5,085 (of 22,227 total)
Global temporary tables are removed after the last process that is referencing them closes. Because you're closing the process, and no other process is referencing the table, it gets closed....
"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 29, 2016 at 7:35 am
Without seeing the code that's calling the backups, it's hard to tell you why it continued after you killed the process. However, in terms of stopping the backups, there's no...
"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 29, 2016 at 7:33 am
If you showed what your WHERE clause is, it would be easier to answer this question.
"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 29, 2016 at 7:29 am
There are a bunch of ways to move a database into Azure and you don't have to use Management Studio for all of them. The method within SSMS is 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
February 29, 2016 at 7:27 am
In SQL Server 2012 and earlier, if the value falled outside the range of statistics, the optimizer assumed that the number of values returned was 1 row. This changed in...
"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 29, 2016 at 5:04 am
Sorry, been on the road.
First, you have OPTION RECOMPILE on your query. Whether your update your statistics or not, you're going to get a recompile every time that query runs....
"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 29, 2016 at 5:01 am
It doesn't matter if there are 50 great presentations. My favorite intro topic is backups. Why? Everyone has a backup book, article, blog post and presentation, so what is one...
"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:48 am
And that'll work, sort of. You'll have to resolve the counts on executions between each set of data collection. You'll have to sweat queries that aren't stored in cache so...
"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:43 am
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
Viewing 15 posts - 5,071 through 5,085 (of 22,227 total)