Viewing 15 posts - 18,301 through 18,315 (of 49,552 total)
SKYBVI (6/4/2012)
1) Why clustered index are only 1 and non clustered indexes are many?
Also, if for a table we...
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
June 4, 2012 at 5:04 am
There is no single command when if run optimises the database performance.
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
June 4, 2012 at 5:02 am
They're not pure integers, and they don't exactly increment.
An LSN is of the form Virtual log file:Log block:Log record, each of which is a binary number (can't recall offhand how...
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
June 4, 2012 at 3:15 am
Not following.
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
June 4, 2012 at 3:07 am
You did read the blog post I hope. It has more than hints for indexing this type of query.
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
June 4, 2012 at 3:06 am
Thomas Stringer (6/3/2012)
GilaMonster (6/3/2012)
Thomas Stringer (6/3/2012)
Wouldn't performance would be degraded if the transaction log is often growing or growing with large growth?
If the log is actively growing, data modifications...
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
June 3, 2012 at 3:22 pm
Thomas Stringer (6/3/2012)
Wouldn't performance would be degraded if the transaction log is often growing or growing with large growth?
If the log is actively growing, data modifications have to wait,...
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
June 3, 2012 at 3:08 pm
Well, what do you want to happen if a value is null?
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
June 3, 2012 at 2:42 pm
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
June 3, 2012 at 12:49 pm
Please read through this - Managing Transaction Logs[/url] and this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Performance is not going to be related to the size of the log.
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
June 3, 2012 at 11:46 am
Perry Whittle (6/3/2012)
What if someone updates more than one column and sets the bit flag, have you allowed for this? 😉
That might be perfectly valid. If it is a table...
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
June 3, 2012 at 11:33 am
Jeff Moden (6/3/2012)
Abhilash T (6/3/2012)
yes Right,Bu I couldn't change it. Bcz its live and lot of developments done with this.
I'm not sure that it's even worth trying to put an...
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
June 3, 2012 at 11:30 am
Don't understand the question.
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
June 3, 2012 at 9:14 am
If the cert is only protected by a password that you don't have, I would recommend ASAP decrypting the DB, creating a cert you do have the password for and...
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
June 3, 2012 at 4:48 am
That's very different from what you initially posted.
For that collection of ORs, see http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/
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
June 3, 2012 at 2:40 am
Viewing 15 posts - 18,301 through 18,315 (of 49,552 total)