Viewing 15 posts - 31,696 through 31,710 (of 49,552 total)
Paul White NZ (7/22/2010)
GilaMonster (7/22/2010)
...And if we want to reference BoL, from the page on sys.indexes:Description of index type:
* HEAP
...
Heap? As an index type? My brain...
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
July 22, 2010 at 11:58 am
Jack Corbett (7/22/2010)
I got the answer right because of Grant's recent SQL University blog post[/url] which also lists 8 and references BOL.
I must admit, I don't agree with that. 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
July 22, 2010 at 11:15 am
Only limit on the size of an index is the available storage size, just like with tables.
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
July 22, 2010 at 11:04 am
Please post your question in a new thread. Thank you.
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
July 22, 2010 at 11:03 am
No limit on concurrent connections, though your DB is too large for 2008 Express. It has a DB size limit of 4 GB. R2 ups that to 10GB, but remember...
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
July 22, 2010 at 11:03 am
Query sys.dm_exec_cached_plan CROSS APPLY sys.dm_exec_query_plan. The exec plan is in the second, in xml format.
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
July 22, 2010 at 7:25 am
Grant Fritchey (7/22/2010)
Uhh... words fail me, but I'd be willing to discuss an hourly rate to untangle the mess.
Agreed. That looks like a good couple days of work to rewrite....
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
July 22, 2010 at 6:18 am
Could you clearly state your question in your post please?
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
July 22, 2010 at 6:17 am
Henrico Bekker (7/22/2010)
Do not use row and table locks.
How would not using locks prevent dirty reads? You suggesting page locks 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
July 22, 2010 at 6:15 am
nuengharit (7/22/2010)
My meta-data size (.mdf) is 93.7 GB and log file (.ldf) is 30 GB.
That sounds fairly reasonable.
When i imported many images in sql per week. I have log file...
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
July 22, 2010 at 1:03 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic956937-1291-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
July 22, 2010 at 12:55 am
Frankly you should remove both the truncate and the shrink step. There's no need for either.
If the rebuild is causing excessive log growth, switch to bulk-logged recovery before the rebuild...
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
July 22, 2010 at 12:53 am
sysobjects exists in 2008, as does syscolumns and all the other familiar SQL 2000 objects. They're views, not tables, deprecated, included only for backward compatibility and will be removed in...
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
July 21, 2010 at 2:19 pm
raamaakrishna (7/21/2010)
Any help in getting the data recovered is highly appreciated....
At this point you're only real option is to hope that the undelete software manages to recover the files intact....
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
July 21, 2010 at 12:15 pm
Try books Online for 2005 and 2008 - the What's changed section.
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
July 21, 2010 at 11:47 am
Viewing 15 posts - 31,696 through 31,710 (of 49,552 total)