GilaMonster (8/28/2012)

---

eric.lyons (8/28/2012)

---

8/19/2012 9:51spid17sCHECKDB for database 'NSMRulestat' finished without errors on 2009-09-20 18:00:09.840 (local time).

8/19/2012 9:51spid25sCHECKDB for database 'Maint' finished without errors on 2012-08-19 03:14:55.117 (local time).

8/19/2012 9:51spid36sCHECKDB...

And yet, on a job interview I was very surprised to learn about the HOURS passing waiting for a VLDB to come on line because of dbcc.

Here is my log file showing what happened at startup. If anyone knows how to disable the dbcc checkdb at startup for USER databases, I'd appreciate that piece of...

Check your log file.

dbcc checkdb runs on startup. This is an issue for any VLDB. It particularly is bad for mirroring and cluster failovers.

What the conversation doesn't mention is that a snapshot is a copy of changed records only, not a snapshot of the entire database. A record gets changed in db,...

SQLEngine (11/2/2009)

---

Thanks Ian. So based on your reply I understand that in Bulk-Logged mode the Tlog backup will be slower, because it is during this backup that the full detail...

Ii pull data from oracle all of the time.

The syntax can be "select * from table where last_update_date >= trunc(sysdate)"

This will get anything changed for current day.

or you can use...

I wince every time I hear someone use the words "cloud computing".

This is marketing hype in line with the "pet rock."

make sure sql browser is up and running.

Right click on DB -- go to tasks -- select "generate scripts", select the database you want,

then select the objects you want (schemas, stored procedure, synonyms, tables, etc...)

In response to your questions: I believe I did. It was a year ago, however, so I can't be sure.

I went through extensive process to try to resolve...

I had this problem a year ago and was given 2 options:

1) drop the replication and recreate from scratch.

2) set up a purge job in the system distribution db.

I chose...

As an oracle dba from ranging from 7.32 to 10.2, I've been reading up on 11G via the 2 day DBA documentation as well.

http://docs.oracle.com/cd/B28359_01/server.111/b28301/backrest.htm

It's a good place to...

Sequences are used to deterministic programming.

A simple Example: EDI documents outbound have unique numbers that are in sequence for EACH customer.

Customer1 receives document 5010, 5011, etc...

Customer2 receives document 2010, 2011,...