Viewing 15 posts - 1,921 through 1,935 (of 2,897 total)
Automatically Grow applies to the data file, not the log file. The log file has to be able to grow, based on the transactions that occur. You can move the...
April 1, 2009 at 3:59 pm
FWIW, our database has lots of compressed sound recordin stored in IMAGE data type fields. Not sure if that is a factor.
March 31, 2009 at 12:03 pm
On the new 2005 server, the execution plan show 2 table scans on the 2 big tables, and index scans in 2000 ..... not sure why though. The 2005 database...
March 30, 2009 at 2:01 pm
Thanks ... good points .... I inherited a ton of old procedures !
I think I found at least one problem. In this example:
SELECT distinct
'VOIP',
'DST',
l.Corp,
l.[FRAN_TX_AR],
303
FROM [Leads_DST] l
WHERE l.[List_ID] = 303
...
March 30, 2009 at 1:18 pm
GilaMonster (3/29/2009)
homebrew01 (3/28/2009)
I assume that some records will be updated and some won't ? There is no begin tran or commit that would do a rollback.
Not at all. Even...
March 29, 2009 at 11:20 am
Krishna (3/25/2009)
March 27, 2009 at 4:00 pm
The database is about 850 Gig. Previously I was writing to a Buffalo terraserver attached drive, and then the standalone server a few times. Backup times were comparable and they...
March 26, 2009 at 1:24 pm
I haven't tried multiple files. The old OS was Win Server 2003 Standard Edition SP2, and the new OS is Win Server 2003 Enterprise Edition SP2.
We're using Redgate SQL Backup...
March 26, 2009 at 1:05 pm
Idera makes a suite of tools such as Compliance Manager, Diagnostic manager & SQL Safe backup.
Redgate makes similar tools, so does Quest. Go to their sites, find ones that...
March 24, 2009 at 9:50 am
[] was the problem .. thanks !
March 20, 2009 at 11:10 am
I guess I'm wondering if there's some quirk about a particular table that could make it fail
March 20, 2009 at 10:51 am
Jonathan Kehayias (2/10/2009)
I ask myself that same question sometimes. Usually at 2:30am when I am driving to the office to begin a maintenance task like installing SP3 on SQL...
March 18, 2009 at 8:28 am
How about deleting the database, since the restore will delete it anyway. Then no one can reconnect before the restore begins.
March 18, 2009 at 8:21 am
I think Idera offers a free "Light" version of it's backup software. It would be good if you need the compression, otherwise use SQL as suggested.
March 17, 2009 at 3:43 pm
It just seems strange that a rollback can take more than 3 or more times the original time of the process !
March 17, 2009 at 1:46 am
Viewing 15 posts - 1,921 through 1,935 (of 2,897 total)