Viewing 15 posts - 616 through 630 (of 860 total)
Round I
DBCC UPDATEUSAGE
But should this not be run after upgrading to SQL 2005?
Round II
DBCC DBREINDEX
UPDATE STATISTICS...
March 6, 2009 at 5:57 am
Alright you can use:
Use 'Databasename'
GO
SELECT * FROM sys.tables
GO
March 6, 2009 at 5:41 am
Duran (3/6/2009)
hello,When a database is backup up, either using sql or third party software, does it alter the modifed date of the datafile?
Regards,
D.
It does not at all, it only...
March 6, 2009 at 5:36 am
guptaajay1985 (3/5/2009)
My client want to see the tables and stored procedures which will be restored from that little backup...help plase
I don think that's possible without restoring the backup. The only...
March 5, 2009 at 4:00 am
Christopher Stobbs (3/4/2009)
no seriously, thanks Gail, you made my day, coming from you that is big confidence booster 🙂
wish...
March 4, 2009 at 9:40 am
Mangal9i (3/4/2009)
But I know i'm in minority.
don't think that you are in minority and I am sure no one here want that too. Of course you have your...
March 4, 2009 at 9:37 am
Then, that's it you don't have to worry too much if you think you have enough experience. Still as you know: "Practice makes man perfect"
Yes, that book is mandatory and...
March 4, 2009 at 9:19 am
Christopher Stobbs (3/4/2009)
how long would you say it takes to study for this exam say if you can do 2-4 hours a day?
humm.. I think its a bit tough to...
March 4, 2009 at 8:51 am
Derek Dongray (3/4/2009)
Mangal Pardeshi (3/4/2009)
Ok,Can we talk about the Topic now?
I already did. Just not in this thread.
To summarize:
Marking posts as 'best answer' = Bad
Marking thread as having a usable...
March 4, 2009 at 8:41 am
Mangal Pardeshi (3/4/2009)
Ok,Can we talk about the Topic now?
NOt the correct platform to talk about the personal issues.
Mangal,
Never ever reply saying 'Ok' in online forums not a good etiquette,...
March 4, 2009 at 8:30 am
Lynn Pettis (3/4/2009)
March 4, 2009 at 8:06 am
Yepp, that's true even i was not able to find much information anywhere except discussing more as a general deadlock concept.
I was asked this question and we had a...
March 4, 2009 at 7:37 am
GilaMonster (3/4/2009)
Krishna (3/4/2009)
Which one will be the victim for the dead lock agent?
Who knows?
The victim is typically the process that is cheaper to roll back. It has nothing to do...
March 4, 2009 at 7:17 am
Sorry guys just let me say a quick word.
I personally feel there is no right answer to any question, what we provide are optimal solutions and its OP's decision to...
March 4, 2009 at 6:45 am
peace2007 (3/4/2009)
Then what if I want to restore the 29th differential...
March 4, 2009 at 4:36 am
Viewing 15 posts - 616 through 630 (of 860 total)