Welcome to SSC!

You can use a CASE statement to convert the 0 to a 1:

DECLARE @EXPECTEDDURATION int

SET @EXPECTEDDURATION = 20

SELECT 1000.00 / CONVERT(FLOAT, CASE WHEN @EXPECTEDDURATION = 0 THEN 1...

Henrico described log shipping pretty well.

For mirroring, have a look at the mirroring states: http://msdn.microsoft.com/en-us/library/ms189284.aspx Essentially, if the mirror goes down, then the mirroring state will be...

If there is an error transferring the file, then the log shipping tools will probably retry to send the transaction log backup once the network is back up. (I've only...

Log shipping is a simpler technology - you back logs up, and you restore them at a later time on the other server. The later time may be immediately...

2147483647 is the default, which means "use as much as you can". It's not the most explanatory value, but it is more memory than a server will have for...

If a clustered index is dropped, then the nonclustered index, which points to rows using the clustered key, will no longer be valid, and will need to be rebuilt. ...

By default, SQL Server will attempt to use as much physical memory as possible in order to cache data. The more data that's cached in memory, the less the...

It looks like you've got a typo in your code. Try "sp_addextendedproc".

Hi Troy,

If performance is good enough, and you're not seeing much in the way of IO stall, you're probably OK. If the database has little TempDB usage, and little...

Unfortunately, there's no magic wand, but you might find, after monitoring the data integrity for some time, that you understand the business rules and the database structure sufficiently to attempt...

Hi Iain,

This is a good question. Generally, stored procedures shouldn't have any effect on key relationships, unless they've been coded in an odd way. Step #1 - is...

Environment variables can be set by right-clicking "My Computer", going to "Properties", to "Advanced" and then to "Environment Variables".

I asked a friend, who is a CS Ph.D student, if he could dig it up. Unfortunately, no luck. His reply:

It's referenced in the ACM digital library:

http://portal.acm.org/citation.cfm?id=655234

But...

I must confess to feeling a little self-conscious when linking to blog posts of my own, but I wrote two longish posts on hashing and various applications of what you...

Your question has made my spidey-sense tingle a little. Why are you wanting a random integer value to store as your App_ID? Is there a reason why you...