Viewing 15 posts - 5,986 through 6,000 (of 22,221 total)
I generally suggest outputting a file and querying that. It's still not fast, but you're going to generally be better off, especially in terms of the amount of information stored....
"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
June 4, 2015 at 5:34 pm
I just talked to Wendy Pastrick. They're not going to have one. There are tentative plans for one in March of next year.
"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
June 4, 2015 at 5:32 pm
Are you talking about a virtual machine or Azure SQL Database? If a virtual machine, you can set up a virtual network and then log shipping will be pretty easy...
"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
June 4, 2015 at 5:29 pm
ramana3327 (6/4/2015)
I think extended events are available in enterprise edition only. We are using standard
Extended events are available in all versions of SQL Server.
"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
June 4, 2015 at 5:21 pm
Not way after the fact, no. Even immediately following the event it may be hard to know why it happened. You'd be better off setting up monitoring through extended evens...
"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
June 4, 2015 at 1:09 pm
There's nothing directly within SSMS that does that kind of work.
"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
June 4, 2015 at 11:52 am
Brandie Tarvin (6/2/2015)
I have to say that "hi" and "hello" are among my favs, for no real...
"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
June 2, 2015 at 7:52 am
As long as you're doing a WITH REPLACE, yeah, you can restore the database if it's offline.
"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
May 30, 2015 at 3:46 am
It's hard to understand precisely what's going on. Any chance of posting the query and the execution plan that does work? Can you get an estimated execution plan from 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
May 30, 2015 at 3:46 am
cunningham (5/29/2015)
"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
May 30, 2015 at 3:40 am
Thanks for reporting back with the solution. That'll help anyone who finds your question through searches.
"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
May 29, 2015 at 2:33 pm
TheSQLGuru (5/29/2015)
Grant Fritchey (5/28/2015)
TheSQLGuru (5/28/2015)
Also, I was leery of adding OPTION (RECOMPILE) for something that runs that often.
This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these...
"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
May 29, 2015 at 2:32 pm
Lynn Pettis (5/29/2015)
< rant >
I am still amazed at how many people have 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
May 29, 2015 at 2:30 pm
I can't honestly say the number of times I've seen this go badly. Views calling other views that are joined to views which contain other nested views... It feels 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
May 29, 2015 at 2:17 pm
GilaMonster (5/29/2015)
rajeshjaiswalraj (5/29/2015)
Where DBCC or DMV will store. What its working.
DMVs don't store data, they're views into SQL's internal memory structures mostly, or database structures.
DBCC statements are very varied 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
May 29, 2015 at 6:32 am
Viewing 15 posts - 5,986 through 6,000 (of 22,221 total)