Viewing 15 posts - 17,821 through 17,835 (of 49,552 total)
You can look at the DMVs, the problem with the sys.dm_exec_query_stats and sys.dm_exec_procedure_stats DMVs is that they do not show data since SQL was last started, they show data 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
July 4, 2012 at 8:41 am
chaithu559 (7/4/2012)
so there's no term called Microsoft join ?
No, and the join type you're asking about is the style that's heavily used in Oracle and, I believe, Sybase, not so...
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 4, 2012 at 4:46 am
No. When log shipping to a higher version (which is not recommended and has very few uses other than a upgrade scenario), the secondary has to be restored WITH NORECOVERY.
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 4, 2012 at 3:01 am
What you've shown there is the very old-style ANSI join. It's not recommended because it's harder to read and easier to make a mistake and cross join your 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 4, 2012 at 2:38 am
Maybe. Will it be a big difference and will the reduction in fragmentation affect query performance? Depends on other factors (frequency of inserts, type of queries, etc)
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 4, 2012 at 2:15 am
Please read through this - Managing Transaction Logs[/url] and maybe this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 4, 2012 at 1:55 am
No such thing as a 'Microsoft join'. What are you referring to?
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 4, 2012 at 1:55 am
e-ghetto (7/3/2012)
GilaMonster (7/3/2012)
Any time at all that you query the index's order is irrelevant. Join or no join.Hmm, when is the index's order relevant?
For seeking, for range scans, 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
July 4, 2012 at 1:51 am
Charles Kincaid (7/3/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
July 3, 2012 at 5:03 pm
For anyone not on/not paying attention to twitter.....
It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.
https://twitter.com/SQLintheWild/statuses/220252281847808001
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 3, 2012 at 3:19 pm
opc.three (7/3/2012)
If it's a heap you may need to rebuild the table, not sure how ghost records work with heaps.
They don't. Ghost records only appear in indexes.
http://www.sqlskills.com/blogs/paul/post/ghost-cleanup-redux.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 3, 2012 at 3:11 pm
Wooooohooooooo!!!!!!!!!!!!!!!!!!!!!!!!
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 3, 2012 at 1:51 pm
coronaride (7/3/2012)
Ok, and the bulk of the time required for creating the constraint is creating the enforcing index?
Yes. All there is to a constraint is an index and some...
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 3, 2012 at 1:14 pm
Because SQL can read the existing index to create the new one whereas without that inde it would have had to read the entire table.
Compare the time that creating 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
July 3, 2012 at 12:02 pm
None of the system tables can be directly queried in SQL 2005 and above. Unless there's some reason to be concerned, just ignore it.
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 3, 2012 at 11:53 am
Viewing 15 posts - 17,821 through 17,835 (of 49,552 total)