Viewing 15 posts - 14,251 through 14,265 (of 22,227 total)
jackimo (9/30/2010)
I do understand that and the fact is in some cases we'll have to do a full scan. Do you think that storing the message in a...
"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
September 30, 2010 at 11:39 am
Steve Jones - Editor (9/30/2010)
You can pay at the door. I'll have Grant standing there intimidating people into giving up $30 or a ticket :-P:w00t:
Or? Or a ticket. Okay. I'll...
"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
September 30, 2010 at 11:35 am
And there's a table scan:
CONVERT(DATETIME,LEFT(CONVERT(VARCHAR, b.event_time, 120),10))
Having a function on the column means that SQL Server can not know what the value is, and must scan the available values...
"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
September 30, 2010 at 9:12 am
inevercheckthis2002 (9/30/2010)
Edogg (9/29/2010)
Log backups do not shrink the transaction log.Please read through Gail's article on transaction logs. It should clear up any questions you have.
Edogg said: "Log backups do not...
"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
September 30, 2010 at 8:34 am
Last couple of years they've had craps, & blackjack that I remember. I think there might have been a roulette wheel too. I like to play craps, as long 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
September 30, 2010 at 8:31 am
Oliiii (9/30/2010)
You can do a select on sys.spatial_indexes to get all the spacial indexes (which you'll most likely never use).
Never is a big word. Where I work is already making...
"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
September 30, 2010 at 8:30 am
Gianluca Sartori (9/30/2010)
Jack Corbett (9/30/2010)
Gianluca Sartori (9/30/2010)
This is a statement generated by our BI front-end.
Surprisingly enough,...
"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
September 30, 2010 at 8:15 am
I have a few scripts on my blog, but if you really want to see stuff, you need to read Allen White's blog, Buck Woody's blog, Aaron Nelson's blog, 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
September 30, 2010 at 8:13 am
Bhuvnesh (9/30/2010)
Grant Fritchey (9/30/2010)
sp_helpindex exposes only orderable index columns; therefore, it does not expose information about XML indexes or spatial indexes.
So the short answer...
"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
September 30, 2010 at 6:55 am
Personally, based on what you're describing, I'd look into partitioning with a rolling window. You can seperate out by date into different partitions on different servers, break it up 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
September 30, 2010 at 6:29 am
All databases, all objects, automatically through SQL Server Management Studio? Nope. You can't do that. Your options are, use a third party tool (check out the Red Gate Toolbelt for...
"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
September 30, 2010 at 6:23 am
tommyh (9/30/2010)
Grant Fritchey (9/30/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
September 30, 2010 at 6:18 am
What are these interview questions? There is some relation between the three, but they're also somewhat different operations. What are you looking for specifically?
"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
September 30, 2010 at 5:45 am
From the SQL Server documentation, Books Online:
sp_helpindex exposes only orderable index columns; therefore, it does not expose information about XML indexes or spatial indexes.
So the short answer is, no.
"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
September 30, 2010 at 5:44 am
The Full recovery model is set up to allow the transaction log to retain data over time. You can then backup the log on a regular basis, say, once every...
"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
September 30, 2010 at 5:42 am
Viewing 15 posts - 14,251 through 14,265 (of 22,227 total)