Viewing 15 posts - 10,066 through 10,080 (of 49,552 total)
My comment directly above stands.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2014 at 7:27 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2014 at 5:29 am
If you run a KILL for that session, what's the output that you get?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2014 at 7:47 am
An instance is the database engine that's running your queries.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2014 at 4:43 am
Chapter 4: http://www.red-gate.com/community/books/accidental-dba
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2014 at 10:27 pm
Hmmmm....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 8, 2014 at 1:02 am
Viewing 15 posts - 10,066 through 10,080 (of 49,552 total)