Viewing 15 posts - 5,986 through 6,000 (of 22,219 total)
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
In general practice, there's little distinction between Dynamic Management Views and Dynamic Management Functions. Most of the time they're all referred to as DMVs collectively. DBCC now means Database Console...
"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 3:36 am
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 days to trade...
"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 28, 2015 at 7:43 pm
Viewing 15 posts - 5,986 through 6,000 (of 22,219 total)