Viewing 15 posts - 6,646 through 6,660 (of 49,571 total)
sparky-407434 (1/31/2015)
February 1, 2015 at 12:16 pm
Bhushan Kulkarni (1/28/2015)
you can check the log file of master database. U can useSelect [Transaction SID],* from ::fn_dblog(null,null) where [Transaction Name] ='dbdestroy'
Master is in simple recovery model, meaning the...
January 30, 2015 at 11:17 am
Siberian Khatru (1/28/2015)
Wondering if it's possible to make the default bigger (longer)
Nope.
January 30, 2015 at 11:15 am
Database 19 will probably be the hidden snapshot that CheckDB creates.
To be honest, I suspect dropping the table will be about the only solution here, although I'd like to see...
January 30, 2015 at 10:43 am
Nasty way to store the date. Can you not store the year and the month separately? Or as a proper Datetime set to the first day?
Either would make this easier.
This...
January 30, 2015 at 7:29 am
The statement is technically correct. Shrinkfile on a log file does not move information around in the log when truncateonly is specified. The problem is that it's easy to assume...
January 30, 2015 at 6:05 am
tom.pester (1/30/2015)
I'm researching this and I think TuncateOnly is useful on log files as well
"The TRUNCATEONLY option does not move information in the log, but does remove inactive VLFs...
January 30, 2015 at 3:12 am
rob.lewis 86087 (1/30/2015)
A full back up is run
A check point is made
The transaction log off the back of...
January 30, 2015 at 2:25 am
sm_iransoftware (1/30/2015)
Because I read somewhere , PK and Clustered index, can be separate (These two do not necessarily Be one thing)
They can be, yes.
And it's better that clustered index...
January 30, 2015 at 2:16 am
Please note: 7 year old (answered) thread.
January 30, 2015 at 1:51 am
If the metadata is corrupt, you're not going to be able to drop the index, no matter what commands you try.
Before trying any more shotgun approaches...
Do you have a backup...
January 30, 2015 at 1:49 am
None.
Nightly may to be too frequent for integrity checks, unless you only keep your backups for 1 day. It's certainly not something that has to be run every day.
As for...
January 30, 2015 at 1:39 am
Sean Lange (1/29/2015)
Alan.B (1/29/2015)
I am certainly not anywhere at the same DBA skill level as say Jeff, Gail or Sean...
Gosh I am humbled to be grouped with those two in...
January 30, 2015 at 1:36 am
sm_iransoftware (1/29/2015)
I run this query on my database.Most of the result are : PK_ ... ?
Those are probably the indexes enforcing the primary keys.
What do I do now?
change cluster? delete...
January 30, 2015 at 1:33 am
Brandie Tarvin (1/29/2015)
Jeff Moden (1/29/2015)
GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
January 29, 2015 at 8:52 am
Viewing 15 posts - 6,646 through 6,660 (of 49,571 total)