Viewing 15 posts - 10,531 through 10,545 (of 22,224 total)
You might want to hire a consultant to do the interview for you. I know several people that are regularly doing interviews for employers that don't have the internal resources...
"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
August 27, 2012 at 4:39 am
In order to collect a meaningful set of data, you're going to need access to the server. You can look at the information in dynamic management objects (DMO) such as...
"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
August 27, 2012 at 4:31 am
I completely spaced asking, but who from The Thread is going to be here in OKC for #sqlsat125?
"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
August 24, 2012 at 3:07 pm
Jeff Moden (8/23/2012)
ChrisM@Work (8/23/2012)
Brandie Tarvin (8/23/2012)
... Tootsie Rolls...Are we back on Clinton??
It Depends... are you wearing a blue dress? :-):-D:-P:hehe:
I thought we had an agreement. You wear the dress. I...
"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
August 24, 2012 at 5:45 am
If you update the statistics for a table, it updates all the statistics associated with that table.
No, I wouldn't create or maintain individual statistics except in rare cases for tuning...
"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
August 22, 2012 at 3:27 am
GilaMonster (8/22/2012)
Grrr. Why do some people want to nitpick holes in things I say and do it in a way that sounds very much like a personal attack?
Same reason you...
"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
August 22, 2012 at 3:04 am
Yes, that does make sense. I'd want to see a good heavy load, especially if I was relying on the old single-threaded model of trace replay.
You'd think this would be...
"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
August 21, 2012 at 6:50 pm
You can use the old Profiler to playback a trace. That will act as a measurable set of tests and will put some load on the system. You just can't...
"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
August 21, 2012 at 5:04 am
It is amazingly faster. It's just not the same at all.
"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
August 20, 2012 at 12:47 pm
Actually, yeah, looks like 2005 might be out. That stinks. Never noticed that before.
"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
August 20, 2012 at 12:31 pm
Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.
"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
August 20, 2012 at 12:31 pm
Yes, you can point the distributed playback mechanism to 2005. It just needs a database to connect to. But, the install is 2012, so you have to have that first.
"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
August 20, 2012 at 11:20 am
The size of the index really depends on the size of the CHAR field and the size of the number field you're comparing. If the CHAR is CHAR(2) and you're...
"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
August 20, 2012 at 11:18 am
The error you're getting, "This differential backup cannot be restored because the database has not been restored to the correct earlier state.", is usually indicative that the full backup 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
August 20, 2012 at 11:14 am
I'm not worried one way or another about an index on a CHAR column. However, storing numbers in string columns is very concerning. You're going to hit issues when you...
"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
August 20, 2012 at 10:39 am
Viewing 15 posts - 10,531 through 10,545 (of 22,224 total)