Viewing 15 posts - 14,251 through 14,265 (of 22,224 total)
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
It depends on the data. Based on the stuff you provided, '0x4C8A2BCB' is absolutely not an integer, a whole number without decimal points, which is what the int data type...
"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:40 am
The Dixie Flatline (9/29/2010)
GilaMonster (9/29/2010)
Grant Fritchey (9/29/2010)
GilaMonster (9/29/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 29, 2010 at 7:35 pm
Jeff Moden (9/29/2010)
CirquedeSQLeil (9/29/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 29, 2010 at 7:16 pm
Viewing 15 posts - 14,251 through 14,265 (of 22,224 total)