Viewing 15 posts - 1,906 through 1,920 (of 2,436 total)
What OS and SP are you running ? What version of SQL and SP are you running ? Have the maintenance plans ever functioned correctly on the instance in question...
September 23, 2005 at 10:39 am
What version and SP is your cluster OS ? We presently have a few active/passive clusters running SQL 2KSP3a. We upgraded most of them from WIN 2K/SP4 to Win 2K3/SP1...
September 23, 2005 at 10:31 am
Database files on a SAN. The benefits of the SAN are the redundancy, the fiber-channel architecture, the ability to use many disk spindles thus distrinbuting I/O more effieciently and the...
September 23, 2005 at 10:24 am
It sounds like you are using the Veritas SQL Agent and not doing 'true' backups. At our shop, and many in the pasy that I have worked at, we have...
September 23, 2005 at 9:14 am
The information has to be 'cached' somewhere. Either the portal machine or the computer using the portal. There is no way the database on the old server could be accessed...
September 22, 2005 at 3:07 pm
truncatin logs page allocations/deallocation as opposed to rows for a delete. Still logging, just less.
September 22, 2005 at 2:49 pm
NASA gave us Tang in the 60's, the DOD via the Manhattan project gave us Teflon in the 40's. Which is more valuable today ?
(This really ought to stir things...
September 22, 2005 at 2:48 pm
We need a 'war stories' category ... I'm sure there would be lots of contributions ... not to mention 'spirited' discussion as well ...
September 22, 2005 at 2:23 pm
We need a 'war stories' category ... I'm sure there would be lots of contributions ... not to mention 'spirited' discussion as well ...
September 22, 2005 at 2:23 pm
NO. Everything is logged <period> It's just whether or not the data in the log is cleared (dependent on the receovery mode).
September 22, 2005 at 2:21 pm
yup ... you mught want to even couple it with the 'undocumented' stored procedure sp_MSforeachtable
http://www.databasejournal.com/features/mssql/article.php/3441031
September 22, 2005 at 2:19 pm
Be careful though ... the majority of this post used 'imlpicit' conversions. Experience has taught that 'implicit' (like 'default') can get you into trouble when you least expect it. Just...
September 22, 2005 at 2:15 pm
It sounds like a local computer issue to me. I just went through more than 91 entries a couple of times after first doing your search for 'trigger' ...
September 22, 2005 at 2:10 pm
Here's my process:
September 22, 2005 at 2:05 pm
you could also try something with smaller units of work to allow the transaction log to 'clean' itself ...
set rowcount 10000 --> this allows only 10,000 rows to be deleted
go
declare...
September 22, 2005 at 1:55 pm
Viewing 15 posts - 1,906 through 1,920 (of 2,436 total)