Viewing 15 posts - 16,096 through 16,110 (of 49,552 total)
Markus (10/16/2012)
If, any of those are in there can I restore this into SQL2008R2 Standard Edition?
No, the restore will fail.
The DMV to check is sys.dm_db_persistent_sku_features (or something like 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
October 16, 2012 at 5:51 am
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ Shows how to save the plan on SQL 2000.
p.s. Please post SQL 2000 questions in the SQL 2000 forums in future. In the SQL 2008 forums we'll assume you're...
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 16, 2012 at 5:18 am
Definitely looks like parameter sniffing (or more correctly, the lack thereof)
http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
Can you post execution plans 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
October 16, 2012 at 5:03 am
Here is important point in regards to DBCC SHRINKFILE not to be misinterpreted: DBCC SHRINKFILE (<Transaction_LogFile_LogicalName>, TRUNCATEONLY) does truncate a transaction log file, i.e. breaks the LSN - Log Sequence...
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 16, 2012 at 4:33 am
Database mirroring doesn't impact performance (implemented correctly).
As for whatever questions were deleted, those look like homework or test questions. How about trying them yourself, you don't learn anything if...
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 16, 2012 at 4:19 am
The index is covering, so one seek operation to the start of the range and a partial scan is all that's necessary.
It's not traversing the index 9.5 million times. If...
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 16, 2012 at 4:16 am
Same story and same reason.
How is SQL to know that the 90% free space in the log is necessary or not? Let's say the log reaches 20GB used every night...
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 16, 2012 at 2:34 am
bugg (10/15/2012)
The company said i would be on call 24/7
On call 24/7 on your own? That pretty much means no vacations, never out of touch, laptop with you anywhere,...
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 15, 2012 at 4:44 pm
Exactly. Corruption is 99% IO subsystem errors, and a borked IO subsystem isn't polite enough to log the mangling it's doing of the data file. Also the reason that 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
October 15, 2012 at 4:07 pm
ahenderson (10/15/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
October 15, 2012 at 3:08 pm
sunny.tjk (10/15/2012)
GilaMonster (10/15/2012)
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
Gail,
I still have a question :-).
If I create a single index on Col A, Col B and Col C , but will this index be useful if I've...
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 15, 2012 at 3:02 pm
The backup file (the .bak) contains only the pages (actually extents) that are allocated to objects. There's no point in backing up empty space.
The restored database must however be exactly...
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 15, 2012 at 3:00 pm
Update table
set column1 = column1 + column2
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 15, 2012 at 2:22 pm
It will work, providing the database contains no persistent enterprise-only features (partitioning, compression, TDE). If the DB uses any of those, the restore will fail *at the end*
Backup compression isn't...
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 15, 2012 at 2:07 pm
*resisting the urge to post a link to google results*
http://www.sqlsentry.net/plan-explorer/sql-server-query-view.asp
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 15, 2012 at 2:05 pm
Viewing 15 posts - 16,096 through 16,110 (of 49,552 total)