Viewing 15 posts - 22,051 through 22,065 (of 49,552 total)
Post the plan?
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
November 21, 2011 at 2:54 pm
What's the front end for this data? What are you using to put data in and later display/interpret/create pretty pictures with? 😉
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
November 21, 2011 at 2:19 pm
In short, it moves the last page in the data file as early as possible, repeat until no more pages can be moved.
When to use it - almost never. Only...
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
November 21, 2011 at 2:16 pm
GSquared (11/21/2011)
It must be DBA season somewhere.
Open season on DBAs??? *fetches bow*
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
November 21, 2011 at 2:11 pm
DBCC UPDATEUSAGE
Don't shrink tempDB without completely and totally quiescing the server. It's documented to potentially cause corruptions in TempDB.
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
November 21, 2011 at 2:09 pm
I don't drink beer and I'd be very hard-pressed to do this efficiently without an order by or a derived table.
If you must, first figure out how to get 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
November 21, 2011 at 11:29 am
Do note that even that can and will fail. It can also result in a DB that's structurally inconsistent (not just transactionally), one that's got metadata corruption, allocation corruption or...
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
November 21, 2011 at 11:19 am
Also I think you really need to read Jonathan's book (I posted the link)
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
November 21, 2011 at 11:03 am
Ninja's_RGR'us (11/21/2011)
So you can't post the full error message because you can't get it or because you cannot post it (confidentiality)?
Because CheckDB fails with that internal operation error and doesn't...
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
November 21, 2011 at 10:58 am
bomborde (11/21/2011)
a select within a from is forbidden (since it will cause a view)
Huh? It won't cause a view (that requires a CREATE VIEW statement) and several of the ways...
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
November 21, 2011 at 10:58 am
Yuri55 (11/21/2011)
DBCC CHECKDB failed again with error: "Msg 8967, Level 16, State 216, Line 1An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services."
That's a pretty...
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
November 21, 2011 at 10:54 am
bomborde (11/21/2011)
for (i=0, i<n_tuples, i++)
...
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
November 21, 2011 at 10:06 am
bomborde (11/21/2011)
An order will be inefficient because it will order the whole table.
Do you know that or are you guessing? The entire table has to be retrieved and hashed anyway.
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
November 21, 2011 at 9:51 am
Lexa (11/21/2011)
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
November 21, 2011 at 9:19 am
You must have a admin login somewhere, like a windows authentication one...
Members of local admin might be automatically sysadmin, depends on the patch level and the OS.
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
November 21, 2011 at 9:17 am
Viewing 15 posts - 22,051 through 22,065 (of 49,552 total)