Viewing 15 posts - 11,686 through 11,700 (of 22,224 total)
I'd pick up a book called Powershell in a Month of Lunches. That'll get you going quick. Same author has a more detailed book, PowerShell TFM. Get the 2.0 version.
"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
October 25, 2011 at 4:49 am
I would absolutely advocate against this with every breath I took, but yes, you could shut down the server, then copy the database and log files, then restart the 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
October 24, 2011 at 10:14 am
kstjacques (10/23/2011)
Grant Fritchey (10/23/2011)
I just hope the vendor isn't one near & dear to my heart.
Yeah, there are lots of reasons to use a third party backup method. For example,...
"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
October 24, 2011 at 4:37 am
What are you using the 68k records for? That's going to take a while to move into SQL Server... a long while. If you're doing an import you might want...
"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
October 23, 2011 at 6:10 am
Fal (10/23/2011)
Ah bugger. New Zealand won the Rugby Union World Cup. A certain someone is gonna be absolutely intolerable now. 😛Steve.
Now?
😀
"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
October 23, 2011 at 6:00 am
LutzM (10/22/2011)
kstjacques (10/21/2011)
So the good news is the vendor is saying they will look into fixing the issue.
My favorite part of the latest...
"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
October 23, 2011 at 5:59 am
I'm more than a little confused by the question. The Merge Join operator inside of an execution plan is one of the most efficient operations there is. Problems around 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
October 23, 2011 at 5:52 am
How long does the oracle query take if you just run it on oracle? And how much data is being returned?
"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
October 23, 2011 at 5:47 am
If you're just getting started as a DBA, first thing, treat production like a patient and you're a doctor, do no harm.
After that, the list of things you 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
October 23, 2011 at 5:45 am
Clint-525719 (10/21/2011)
1) We do not have the AdHoc optimization turned on, and actually, I'd forgotten about it. I've...
"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
October 22, 2011 at 5:25 am
Jack Corbett (10/21/2011)
Steve Jones - SSC Editor (10/21/2011)
Jack Corbett (10/20/2011)
"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
October 21, 2011 at 1:15 pm
Jack Corbett (10/20/2011)
On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?
Throw out an old one 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
October 21, 2011 at 10:08 am
If it's not turned on already, turn on optimizer for ad hoc workload.
Next, news to me, but worth mentioning, NUMA (which most systems have these days) makes the normal page...
"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
October 20, 2011 at 11:25 am
Piling on at this point, but nope. Not a chance. the DMO objects store either real time information or aggregation information. They couldn't store historical information without the system databases...
"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
October 20, 2011 at 11:20 am
You'd need to get into querying against the DMOs. sys.dm_exec_query_stats will have it.
"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
October 20, 2011 at 11:00 am
Viewing 15 posts - 11,686 through 11,700 (of 22,224 total)