Viewing 15 posts - 25,486 through 25,500 (of 49,552 total)
Ninja's_RGR'us (6/15/2011)
Trey Staker (6/15/2011)
Especially if we keep replying to the "Thread". lolHas anyone ever broken up the points by post to the "Thread"?
Nope but with 27K posts some people might...
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
June 15, 2011 at 11:00 am
As Grant said, the plan is generated and cached before execution starts. It's the plan for the batch, SQL doesn't compile statement by statement.
Run the statements individually, you'll soon see...
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
June 15, 2011 at 10:59 am
It's probably that -0.00 that's the problem. That's not a valid numeric value. Get the pk value for that row from DBCC Page and try an update (don't filter on...
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
June 15, 2011 at 10:43 am
Brandie Tarvin (6/15/2011)
msenel (6/15/2011)
in this case SQL server works just like Oracle, restore Full backup and then TRN log until the point where you dropped the table ( using stopat=timestamp)
Just...
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
June 15, 2011 at 10:37 am
Paul Farnell (6/15/2011)
I won't ever want to rollback to a point in time I just want to be able to work out what process has updated these records.
So no clueless...
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
June 15, 2011 at 10:36 am
The entire batch's query text and plan are found in the DMV. You see one statement and the entire plan because you've got a function in the query to cut...
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
June 15, 2011 at 10:15 am
Tara-1044200 (6/15/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
June 15, 2011 at 6:45 am
GilaMonster (6/14/2011)
Post the latest error log (you can disguise the names of the DBs, they're not important)
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
June 15, 2011 at 6:44 am
Grant Fritchey (6/15/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
June 15, 2011 at 6:25 am
Those aren't errors. They're just informational messages telling you that configuration options have changed.
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
June 15, 2011 at 5:07 am
What error?
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
June 15, 2011 at 4:35 am
Massive waste of space, increase in maintenance time, increase in insert, update, delete. Unless you have queries that do single-column filters on the columns they're unlikely to be used.
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
June 15, 2011 at 4:33 am
Tom.Thomson (6/15/2011)
Unless they just don't know what the acronyms stand for.
That.
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
June 15, 2011 at 2:44 am
Try the RESTART keyword on the RESTORE.
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
June 15, 2011 at 2:42 am
Joy Smith San (6/15/2011)
A mirrored database can be accessed by creatig a snapshot on it.And a snapshot is nothing but a copy of the original DB.
It's not a copy of...
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
June 15, 2011 at 2:40 am
Viewing 15 posts - 25,486 through 25,500 (of 49,552 total)