Viewing 15 posts - 14,611 through 14,625 (of 22,227 total)
We have the same situation and basically rely on the logs as a mechanism to restore to a precise point in time. That's the best that can be achieved. If...
"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
July 21, 2010 at 7:11 am
Just understand, you're not adding indexes to a view. A view is nothing but a query. You're creating a new object, a materialized view, that is working within a set...
"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
July 21, 2010 at 7:09 am
A couple of possible suggestions...
I have a friend who works for a clothing company. They do most of the design work in the US, the marketing in US, Europe, India,...
"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
July 21, 2010 at 7:03 am
sk-458789 (7/20/2010)
Select Distinct TBL_1.EmpID, TBL_1.Name, TBL_2.UpdateTime from EmpMst TBL_1 With (Nolock)
Left Outer Join EmpMst TBL_2 With (Nolock)...
"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
July 21, 2010 at 6:08 am
There's a new post coming up on my blog on Friday that's an introduction to statistics as part of SQL University's Index Week. Keep an eye out for it. 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
July 20, 2010 at 11:18 am
It really kind of depends on your business and your systems. For example, I work for an insurance company. We don't do umpty-gazillion transactions per/second, so measuring just transactions per...
"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
July 20, 2010 at 11:10 am
"Dirty data" doesn't have a precise definition. One definition of it is data inside the system in an uncommitted state. It's in the middle of a transaction and therefore, dirty....
"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
July 20, 2010 at 9:40 am
Well, no more replies anyway... :w00t:
"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
July 20, 2010 at 9:40 am
"Dirty data" doesn't have a precise definition. One definition of it is data inside the system in an uncommitted state. It's in the middle of a transaction and therefore, dirty....
"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
July 20, 2010 at 9:30 am
We use both SCOM and Idera's Diagnostic Manager. They monitor different stuff in different ways.
"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
July 20, 2010 at 9:26 am
I'd say no. Your issue is that the procs are not in the cache, but it's not necessarily a memory problem. It's much more likely to be a coding issue....
"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
July 20, 2010 at 6:34 am
But even the management data warehouse has to be enabled and the data kept in order to go back in time to retrieve it.
Basically, the answer is, unless you'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
July 20, 2010 at 5:49 am
Jack Corbett (7/19/2010)
The Dixie Flatline (7/19/2010)
I'm getting to come again this year. How early do volunteers have to arrive?
If you mean volunteer for the Summit, there is usually...
"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
July 20, 2010 at 5:14 am
CirquedeSQLeil (7/19/2010)
Is Denny Cherry running too?
He submitted, yeah. Saw that on Twitter.
"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
July 19, 2010 at 12:32 pm
Steve Jones - Editor (7/19/2010)
Grant Fritchey (7/19/2010)
Jack Corbett (7/19/2010)
"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
July 19, 2010 at 11:55 am
Viewing 15 posts - 14,611 through 14,625 (of 22,227 total)