Viewing 15 posts - 10,066 through 10,080 (of 49,571 total)
This is a minor error, not something you particularly need to worry about. As the messages in the job output suggest, you can resolve this completely and with absolutely no...
February 11, 2014 at 6:41 am
chetan.deshpande001 (2/11/2014)
It can be addressed using repair_allow_data_loss.. but you might loose some data ... Please read more on repair_allow_data_loss option that CHECKDB provides here http://technet.microsoft.com/en-us/library/ms176064.aspx
NO! NO! NO! It does NOT...
February 11, 2014 at 6:38 am
Koen Verbeeck (2/11/2014)
Adding extra columns to the clustered index has consequences. Maybe this affects other queries who don't use those columns.
And adding extra columns to the primary key can have...
February 11, 2014 at 5:37 am
P Jones (2/11/2014)
DBCC SHRINKFILE (xyz_Log,1,TRUNCATEONLY);
nooooooo.... *sob* *weep*
Firstly, truncateOnly is not a valid option for shrinking a log. It's completely ignored when shrinking a log. It's an option only when shrinking...
February 11, 2014 at 5:29 am
If you run a KILL for that session, what's the output that you get?
February 11, 2014 at 4:19 am
Wait. Rollback usually takes longer than the roll forward. DO NOT restart SQL, otherwise the rollback will be restarted after the instance restarts, probably with the database unavailable to anyone.
February 11, 2014 at 1:27 am
Number of pages?
Unless it's either a large table or you've pinpointed the page splits as being a problem, I'd probably leave it.
February 10, 2014 at 8:35 am
How big is the table?
If I select the PK column only, then select again with an order by the PK column, both selects will return the same values in the...
February 10, 2014 at 8:14 am
Simple recovery doesn't mean the log won't grow. Simple recovery only means that inactive portions of the log are automatically marked as reusable when a checkpoint runs.
Since you're running a...
February 10, 2014 at 7:47 am
An instance is the database engine that's running your queries.
February 10, 2014 at 4:43 am
February 10, 2014 at 4:40 am
It's not ignoring your test, it's checking to see if there's a table named '#Temp_Table' in the current database. Unless your current database context is TempDB, that test will fail...
February 10, 2014 at 4:39 am
cphite (2/9/2014)
The only catch is that if for whatever reason the new location isn't accessible, SQL won't start and you'd need to restore master.
SQL won't start in that case, but...
February 9, 2014 at 10:27 pm
Hmmmm....
February 8, 2014 at 1:02 am
Viewing 15 posts - 10,066 through 10,080 (of 49,571 total)