Viewing 15 posts - 1 through 15 (of 1,412 total)
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...
February 2, 2006 at 6:33 am
DECLARE @minutes INT
SET @minutes = 200
SELECT @minutes / 60 AS hours
, @minutes % 60 AS minutes
February 2, 2006 at 6:25 am
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...
February 2, 2006 at 3:04 am
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...
February 2, 2006 at 12:53 am
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.
February 2, 2006 at 12:48 am
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...
February 1, 2006 at 5:17 am
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...
January 31, 2006 at 5:06 am
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...
January 31, 2006 at 4:27 am
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...
January 31, 2006 at 3:23 am
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...
January 31, 2006 at 12:03 am
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...
January 30, 2006 at 11:50 pm
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...
January 30, 2006 at 11:46 pm
Have you changed the 'recovery interval' database option?
January 29, 2006 at 2:33 am
Why not simply do:
set Balance = Balance - 1000
where AccNo = '13245669'
and Balance >= 1000
January 29, 2006 at 2:23 am
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,...
January 27, 2006 at 8:21 am