Viewing 15 posts - 4,951 through 4,965 (of 22,219 total)
Nothing special. Treat the cache like a table. Run a query to export through BCP. Import that to another database as a table. Done. No special tricks, not moving memory...
"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, 2016 at 7:26 am
Your best bet would be to offload the XQuery part of the work. Instead of trying to run the XPath stuff, which will do what you want, on your production...
"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, 2016 at 5:53 am
You can do a trigger, but that comes with the possibility of considerable overhead depending on how it's done. You'll also have to sweat the log on the secondary database...
"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, 2016 at 5:46 am
There are a lot of complexities with the cloud providers, but, yeah, they have a model that lets you basically rent storage and cpu space. You provide all licensing from...
"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, 2016 at 4:46 am
BL0B_EATER (3/23/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
March 23, 2016 at 4:37 am
It actually kind of is impossible. The missing indexes are, at best, suggestions. You can't simply blindly apply them. Further, if you look through them, there's a lot of duplication...
"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, 2016 at 4:31 am
Mad-Dog (3/22/2016)
i update all the stats every night and rebuild the indexes once a week.
can i query 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 22, 2016 at 1:06 pm
Sachin Nandanwar (3/22/2016)
Grant Fritchey (3/22/2016)
Be very cautious here. A trace capturing execution plans is extremely costly on the server. If it's already under stress, this may not help at all.
Yes...
"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 22, 2016 at 7:14 am
There's a good article on it here. Be sure to read Paul Randals [/url]work on the subject.
"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 22, 2016 at 7:08 am
Koen Verbeeck (3/22/2016)
Grant Fritchey (3/22/2016)
Koen Verbeeck (3/22/2016)
In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all of the commotion...
Thanks for sharing 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
March 22, 2016 at 6:38 am
Nothing is ever free. However, in most cases, the load is light enough that it only marginally interferes with normal operations. If you use backups to offload it, do some...
"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 22, 2016 at 6:32 am
Koen Verbeeck (3/22/2016)
In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all of the commotion...
Thanks for sharing this. You were on my...
"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 22, 2016 at 6:28 am
In Standard Edition, while the index is being rebuilt, it is offline and user access is blocked.
Why are you updating the indexes so frequently? Unless your queries are doing lots...
"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 22, 2016 at 5:14 am
Sachin Nandanwar (3/21/2016)
Can you post...
"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 22, 2016 at 5:12 am
It's possible you're seeing bad parameter sniffing. First, identify the individual query that is running slow (you have to attack these one at a time, there aren't batch solutions for...
"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 22, 2016 at 5:11 am
Viewing 15 posts - 4,951 through 4,965 (of 22,219 total)