Viewing 15 posts - 28,546 through 28,560 (of 49,552 total)
Correct but not complete.
An index rebuild updates the stats on that index with a fullscan. Makes sense, because SQL's reading the entire index to rebuild it. It does not update...
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
January 10, 2011 at 10:44 am
There are ways to read the log, however it's not intended to be human-readable, it's not there for you to play around with.
The transaction log is primarily for database...
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
January 10, 2011 at 10:40 am
Database backups or log backups?
Are the databases growing?
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
January 10, 2011 at 10:38 am
Am looking for proof-reader for article on reasons for transaction log space not being reused. Any takers?
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
January 10, 2011 at 8:08 am
Some of the offers have been 'free second shot + discount on next exam if you pass first time', so check the details of exactly what you got.
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
January 10, 2011 at 8:03 am
nekonecny (1/10/2011)
I prefer:IF EXISTS(SELECT TOP 1 1 FROM ...
Why?
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
January 10, 2011 at 8:02 am
As I said, they're exactly the same. During the parsing of the query any reference to columns is stripped out of the exists.
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
January 10, 2011 at 8:01 am
They're exactly the same. The columns are ignored in an EXISTS.
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
January 10, 2011 at 7:31 am
As far as I'm aware the retake voucher is only for a retake of the exam in case you fail it first time around.
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
January 10, 2011 at 7:31 am
ravisamigo (1/10/2011)
Can someone provide the dumps for SQLServer 2008 - Administration Certification ? pleaseRegards,
Ravichandra.
Dumps are cheating. They are actual questions taken from the exam (questions that you will get...
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
January 10, 2011 at 7:30 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1045258-324-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
January 10, 2011 at 6:38 am
Solutions for what? Explain the situation, explain what happened, explain what you've done so far 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
January 10, 2011 at 6:35 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1045215-5-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
January 10, 2011 at 5:41 am
STATS_DATE()
It's a function, use it in conjunction with sys.indexes or sys.statistics.
Or, if you just want the details for one stats set, DBCC SHOW_STATISTICS will also show last update.
Bear 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
January 9, 2011 at 10:52 pm
Craig Farrell (1/9/2011)
If the USA isn't the center of the world, why does it seem like a lot of people keep gravitating to it?
Very bad joke (with bad physics) 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
January 9, 2011 at 10:45 pm
Viewing 15 posts - 28,546 through 28,560 (of 49,552 total)