Viewing 15 posts - 14,236 through 14,250 (of 22,211 total)
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...
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...
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...
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...
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...
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,...
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...
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...
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...
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...
September 30, 2010 at 6:23 am
tommyh (9/30/2010)
Grant Fritchey (9/30/2010)
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?
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.
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...
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...
September 30, 2010 at 5:40 am
Viewing 15 posts - 14,236 through 14,250 (of 22,211 total)