If I understand you correctly you are just looking for a way to manually craft a guid in QA? If so, you just write it as a string and set...

DECLARE @minutes INT

SET @minutes = 200

SELECT @minutes / 60 AS hours

, @minutes % 60 AS minutes

You are missing the point. By doing this in a udf that needs to be called for each row you have effectively stopped SQL Server from using an index on...

You can do it programmatically, but it will require to replace all of the tables with new tables. All the data needs to be moved to new tables, the old...

That is about as much misuse of UDFs as it is possible to do. A simple set-based statement is easy to write and will perform "infinitely" better, like Jeff shows.

Well, like I said it is just a matter of considering the cost versus the value. The best practice is to have the log file for a database on a...

Sorry if I expressed myself badly, I did not mean you said you had optimium configuration. It is just that a lot of people have heard something about moving log...

The reason why it is recommended to put the log on a separate drive is that all the I/O on the file is sequential. Therefore you get increased performance since...

You should not place more than one transaction log on each drive. So if you will be having more than one database in use you will need more than drive...

Bits are always 0 and 1. SQL Server does not have a boolean datatype, instead we use bit to represent them. Naturally it is impossible to convert a string to...

Is the listener service started? Otherwise the client does not know which port the instance is using. Is the port the instance is using open in the firewall?

Can you access...

If the table is placed on a separate filegroup you can backup that filegroup by itself. In SQL Server 2000 you can't do much with that though other than using...

Have you changed the 'recovery interval' database option?

Why not simply do:

Update Table1

set Balance = Balance - 1000

where AccNo = '13245669'

and Balance >= 1000

I implemented a SQLCLR streaming table-valued function for doing this as an experiment. I guess you are using SQL Server 2000 so it probably is not of help to you,...