Viewing 15 posts - 18,061 through 18,075 (of 49,552 total)
From some quick testing, yes, it is the equivalent to repair_allow_data_loss, as it fixes errors that only repair_allow_data_loss can fix. Hence yes, you could very well have lost data running...
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, 2012 at 4:35 am
Strange.
Would love to debug further, but that's kinda hard without a broken query.
The reason I asked about the quotes is because the of implicit conversion. If the query were...
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, 2012 at 3:16 am
SQLCrazyCertified (6/14/2012)
Please correct me if I have mentioned anything incorrectly.
Why do you specifically call out AWE on 32 bit SQL on 64 bit OS, but make no mention of 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
June 15, 2012 at 3:01 am
The only columns that query will access are the City and Zip columns, so they're the only columns that can trigger the data type error. While some data types can...
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 14, 2012 at 1:52 pm
To clarify... The 'oops' was because I stuffed up there. I usually warn about the risks of restarting with a transaction rolling back, but seen so many cases recently where...
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 14, 2012 at 1:42 pm
Vertigo44 (6/14/2012)
Yes but mine did not say 0% remaining. Mine said 0% COMPLETE after sitting for about 45 minutes.
You said that it did: "Estimated time remaining: 0 seconds." Was...
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 14, 2012 at 1:11 pm
Sure, not all types of fragmentation are equally problematic, but the terms 'internal fragmentation' and 'external fragmentation' are ambiguous enough that if I say 'Internal fragmentation is a major concern',...
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 14, 2012 at 10:28 am
Note that evaluation edition expires after 180 days. If you're going to develop something for the business, but an appropriate SQL license.
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 14, 2012 at 10:17 am
Ooops... http://www.sqlservercentral.com/Forums/Topic1315877-146-1.aspx
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 14, 2012 at 10:15 am
Nope.
You may want to check that there's no IO subsystem problems.
You sure the rollback clearly said 0 seconds remaining in the kill? If it was going to cause a long...
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 14, 2012 at 10:09 am
I would simply recommend staying away from the terms 'internal fragmentation' and 'external fragmentation' entirely as there is no clear definition.
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 14, 2012 at 10:05 am
If it's stuck waiting for something outside of SQL (which that looks like), you may have to restart SQL.
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 14, 2012 at 8:37 am
Just to be pedantic...
A 32 bit OS cannot run a 64-bit SQL Server.
A 64-bit OS can run 32-bit code, but not the other way around.
For memory details, books Online...
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 14, 2012 at 8:19 am
The bulk insert has to roll back. If it did a lot of work, it may take a lot of time to roll back.
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 14, 2012 at 8:17 am
Ric Sierra (6/14/2012)
I'm not agree.With the TSQL evidence given (just " a part of " the command) the default behaviur is to assume a Clustered index.
The whole point of 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
June 14, 2012 at 8:13 am
Viewing 15 posts - 18,061 through 18,075 (of 49,552 total)