You didn’t specify if you had any log backups during the time that you log was growing. If you had no log backups during that time, then it...

I don’t think that you can modify the format to LiteSpeed’s format. In any case you can use other tools such as 7zip, Gzip or any other tool to...

I have to admit that I was surprised that we can name a column with the data types’ names with no problems at all. Although this can be done,...

You can’t use empty strings. Instead of the empty strings you should specify where the backup file is located and which fie you want to move.

Adi

Just use dateadd function. Use the parameters hh to specify that you want to use hours and -1 as the amount of hours that you want to add. ...

Personally I don’t like mixing test and production environment. I would prefer to have 2 different and separated environments for test and production. I think that using...

Both table variables and temporary tables are created in TempDB. There are few differents between them. When you use table variable the server doesn’t hold statistics on it...

It could be that you are using a control that does its own sorting or just doesn’t use the order of the rows that it got, but the queries should...

I wouldn’t change collation just to modify the NULL location in a recordset. Instead I would use a case statement or isnull function. Bellow are 2 examples:

SELECT WhatEver

FROM...

This is not a bug. Rowlock and pagelock are mutually exclusive, and both state to use either row locks or page locks as long as escalation to page locks...

If you are looking for the length of time that something took, then you can use the datediff function to calculate the period of time. According to it you...

I think that the recordset should still show the continent and country for each city. The presentation s in the way that you want should be done in the...

You need to be more specific about the requirements. It is unclear if you want it according to the hours or according to clock (i.e. 2:30 – 2:45 is...

Very easy to read about it on the net - http://lmgtfy.com/?q=sql+server+2008+new+data+types

Adi

While I agree that it is a good question, I think that there is a mistake in the answers. Since the question states that it is for SQL Server...