Viewing 15 posts - 17,896 through 17,910 (of 49,552 total)
SQLKnowItAll (6/26/2012)
you now have a 330gb file with essentially 30gb free.
Which is probably a good thing, much better than a 300 GB file with 30 MB free.
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 26, 2012 at 1:55 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Without that, we're guessing. The LEFT in the join looks like a potential problem, but it could be 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 26, 2012 at 1:50 pm
sql.AB (6/26/2012)
(Then limit the max growth setting of one and then once it is filled it will start writing to the next one over.)
SQL writes to all files in 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
June 26, 2012 at 9:11 am
The problem is that the order is non-determined, not random. So you can run a test 10000 times and the data will come back ordered the way you think...
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 25, 2012 at 11:34 pm
Just one point... Column statistics do indeed appear in sys.stats, all statistics are in that view both column and index. Index stats get updated when the index is rebuilt, column...
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 25, 2012 at 4:28 pm
The +2 is the size of the column offset pointer, it's not reflected in the value returned from datalength.
A varchar(10) that stores 8 characters takes 10 bytes of storage total...
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 25, 2012 at 2:36 pm
Matt Miller (#4) (6/25/2012)
Because the CHAR data type is defined as a fixed length type. What's the "length" of NULL?
One byte in the case of a char(1)
Char(1)...
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 25, 2012 at 10:44 am
SanDroid (6/25/2012)
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 25, 2012 at 7:32 am
Ask the auditors what level of monitoring they require.
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 25, 2012 at 6:48 am
SanDroid (6/25/2012)
Do you have any information for those using SQL 2005 what the difference is in the CheckDB they see running when auto_close is on?
CheckDB only runs when someone manually...
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 25, 2012 at 6:44 am
Chris-475469 (6/25/2012)
Not sure I know enough about the first option you suggested
Neither do I. It's something that maybe 10 people in the world can do and most work for...
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 25, 2012 at 6:36 am
SanDroid (6/25/2012)
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 25, 2012 at 6:33 am
Chris-475469 (6/25/2012)
This isn't a massive issue but I was interested to see if there was any clever way of fixing it apart from restoring as you suggested.
Hex editing the data...
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 25, 2012 at 6:15 am
No, that's not incorrect data in a column, that's a corrupt page.
If it was an out of range data type in a column, the error would read "Column "<column name>"...
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 25, 2012 at 5:01 am
paul.knibbs (6/25/2012)
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 25, 2012 at 4:59 am
Viewing 15 posts - 17,896 through 17,910 (of 49,552 total)