Viewing 15 posts - 21,571 through 21,585 (of 49,552 total)
Just as a p.s. sysobjects and syscomments are both deprecated, included only for backward compat and will be removed from a future version. Use sys.objects and sys.sql_modules instead.
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
December 23, 2011 at 2:13 am
I've paid for every certification bar one out of my own pocket, I'm paying for M.Sc out of my own pocket and I'll be perusing future (very expensive) certifications 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
December 23, 2011 at 2:02 am
Honestly, with this kind of data I'd either go for the supertype/subtype or just completely separate tables. There's no real justification (other than generalisation) to go with one table design,...
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
December 23, 2011 at 1:56 am
Make sure that you are not using the database (as in, your connection that you ran the ALTER DATABASE 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
December 22, 2011 at 1:54 pm
p.s. And do the same thing with Model. It's an absolute pain if that one gets damaged, I haven't yet found a way to restore that without first rebuilding all...
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
December 22, 2011 at 1:50 pm
Apologies, got tied up with a misbehaving SAN.
The row count's off by a couple of orders of magnitude, so SQL thinks far more rows than there are, this will lead...
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
December 22, 2011 at 11:35 am
My guess would be index rebuilds. They're usually the culprits for large log growth/large log backups, especially in the scenario you gave where the log backup is over half 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
December 22, 2011 at 11:14 am
Steve Jones - SSC Editor (12/22/2011)
okbangas (12/22/2011)
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
December 22, 2011 at 11:11 am
Revenant (12/22/2011)
GilaMonster (12/22/2011)
I think the correct answer (like the max number of indexes per table) is 'Too Many'How many is 'too many'? 🙂
One more than 'just right'. 😀
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
December 22, 2011 at 11:00 am
Sure, got an hour or so? 😉
There are lots of possible causes. Most likely would be a 'tipping' point in the data volume.
Are you certain that there has been no...
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
December 22, 2011 at 10:01 am
islas.tonatiuh (12/22/2011)
One more question Sir, what's the interpretation for the operation and context columns retrieved from the query?I ran it but how can i use those results, because i saw:
e.g.
dbo.TransactionLog.PK_TransactionLogLOP_MODIFY_ROWLCX_TEXT_MIX
dbo.TransactionLog.PK_TransactionLogLOP_MODIFY_ROWLCX_TEXT_TREE
dbo.TransactionLog.PK_TransactionLogLOP_SET_BITSLCX_GAM
dbo.TransactionLog.PK_TransactionLogLOP_SET_BITSLCX_IAM
sys.sysallocunits.clustLOP_COUNT_DELTALCX_CLUSTERED
Personally,...
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
December 22, 2011 at 9:58 am
I think the correct answer (like the max number of indexes per table) is 'Too Many'
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
December 22, 2011 at 8:41 am
The FullText predicates are CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE. Anything else (like LIKE) will use the normal indexes 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
December 22, 2011 at 8:40 am
Probably this: http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
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
December 22, 2011 at 8:36 am
Post execution plan please (of the one without the hints). Actual plan if at all possible, estimated only if you cannot run the query to completion at all.
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
December 22, 2011 at 8:34 am
Viewing 15 posts - 21,571 through 21,585 (of 49,552 total)