Viewing 15 posts - 2,971 through 2,985 (of 3,010 total)
I have to ask. Why do you have to do this after loading that much data into the table?
February 12, 2007 at 2:19 pm
This is an even more effective way to get everyone out of the database and prevent them from reconnecting.
alter database MyDatabase set offline with rollback immediate
February 12, 2007 at 8:08 am
There is no reason why you couldn't use GETDATE() in your INSERT or UPDATE statement.
February 10, 2007 at 11:48 pm
It would be more efficient to set the value of DateLastEdit in the procedure that inserts or updates the data than to use a trigger
February 10, 2007 at 6:48 pm
Are you really asking us for the meaning of data in your database?
We can make guesses, but how would we really know?
February 10, 2007 at 5:24 pm
You are taking the wrong approach to shrinking the database.
The way to do it is to shrink it by database file in small imcrements in a loop, say 50 MB...
February 9, 2007 at 7:18 pm
Did you just add a table with a computed column, add a computed column to an existing table, or create an indexed view?
February 9, 2007 at 6:20 pm
Yes, you can just setup a SQL Server Agent job to run the restore each night.
February 8, 2007 at 7:31 pm
You can use this function to generate both.
Date Table Function F_TABLE_DATE
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519
This code generates a table with all days from 2000-01-01 through 2010-12-31. You can pick any date range you want...
February 8, 2007 at 7:23 pm
If you just want to be able to drop the database, use this:
use master alter database RB_Data_Services_MSCRM set offline with rollback immediate
That will kick everyone out of the database, and set...
February 7, 2007 at 8:05 pm
Since you have the dates stored in a character column, it might be faster to do string comparisons, instead of casting two columns to datetime to do the compares, especially...
February 6, 2007 at 9:26 pm
You have a bug in that code.
convert(varchar, @EndDate, 101) will be converted to a string in the format '02/06/2007' and will be compared as a string to '2/6/2007'. That would...
February 6, 2007 at 8:07 pm
I worked for a company that spent $4,000,000 on a patent enfringement case against a competitor and lost. They felt certain they had proved the case, but the grandmothers on the...
February 5, 2007 at 1:22 pm
exec sp_changeobjectowner '[oldowner].[viewname]','[newowner]'
February 5, 2007 at 12:44 pm
You have a bug in the code you posted. If the time is after 23:59:59.000 on the last day, it will not return the data. You may think there is...
February 5, 2007 at 12:40 pm
Viewing 15 posts - 2,971 through 2,985 (of 3,010 total)