Viewing 15 posts - 43,501 through 43,515 (of 49,552 total)
DBA (10/27/2008)
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
October 27, 2008 at 3:37 pm
Yup. It's documented in Books Online under < drum roll > Alter Table .:D
REBUILD
Use the REBUILD WITH syntax to rebuild an entire table including all the partitions in a partitioned...
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
October 27, 2008 at 3:09 pm
Please don't put questions into the thread title. It gets cut off.
What's the question?
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
October 27, 2008 at 3:05 pm
Leo (10/27/2008)
How do I check of bad stats? Do you have any command line to check the table?
It's not a command. It's a case of noticing queries that run well...
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
October 27, 2008 at 3:03 pm
Chris (10/27/2008)
select isnumeric('3edf2') when i tried this it showing as 0 ...wats the reason for this
3edf2 cannot be cast to any of the numeric data types. It is not 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
October 27, 2008 at 2:44 pm
Good point.
The other reason to run checkDB is that on SQL 2000 checkDB did not include checkcatalog, which is why we so often see checkDB errors about inconsistent metadata...
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
October 27, 2008 at 2:39 pm
oscar (10/27/2008)
Is it a simple step by step process? or a mini/delicate project?
Look up Database Mirroring in Books Online. It's not too complex, but it's not a 2-click process....
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
October 27, 2008 at 2:14 pm
I got an answer from one of the storage engine team. He said that at some point in time, there must have been rows on all of those pages, even...
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
October 27, 2008 at 2:02 pm
A view doesn't store data. It's just a saved select statement. When you query a view, part of the parsing and binding that occurs replaces the view's name with 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
October 27, 2008 at 1:32 pm
george sibbald (10/27/2008)
Dan mentioned experts-exchange, no tech site annoys me like that one
I used to post there occasionally, before they became a paying site. At the time people gained points...
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
October 27, 2008 at 1:15 pm
Roy Ernest (10/27/2008)
Now the question is why does not get cleaned up?
If/when I find out, I'll be sure to let you know.
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
October 27, 2008 at 1:05 pm
Interesting. Despite having no rows, there are over 5000 pages that belong to the table. I would hazard a guess that they all have ghost records on them (marked as...
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
October 27, 2008 at 12:53 pm
stephen.wolfe (10/27/2008)
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
October 27, 2008 at 12:21 pm
Can you perhaps query sys.dm_db_index_physical_stats for that table and post the results?
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
October 27, 2008 at 12:18 pm
At least find out from the vendor where that locked rows report is coming from.
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
October 27, 2008 at 12:17 pm
Viewing 15 posts - 43,501 through 43,515 (of 49,552 total)