Viewing 15 posts - 1 through 15 (of 25 total)
GilaMonster (8/28/2012)
eric.lyons (8/28/2012)
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...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
August 28, 2012 at 2:20 pm
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.
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
August 28, 2012 at 2:17 pm
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...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
August 28, 2012 at 2:11 pm
Check your log file.
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
August 28, 2012 at 2:02 pm
dbcc checkdb runs on startup. This is an issue for any VLDB. It particularly is bad for mirroring and cluster failovers.
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
August 28, 2012 at 1:54 pm
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,...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
July 19, 2012 at 11:36 am
SQLEngine (11/2/2009)
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 28, 2012 at 3:01 pm
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...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 27, 2012 at 8:54 am
I wince every time I hear someone use the words "cloud computing".
This is marketing hype in line with the "pet rock."
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 26, 2012 at 8:08 am
make sure sql browser is up and running.
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 25, 2012 at 11:40 am
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...)
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 20, 2012 at 2:44 pm
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...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 20, 2012 at 1:47 pm
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...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 20, 2012 at 10:32 am
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 start.
I'm no...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 18, 2012 at 3:06 pm
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,...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 13, 2012 at 9:06 am
Viewing 15 posts - 1 through 15 (of 25 total)