Viewing 15 posts - 40,516 through 40,530 (of 49,552 total)
t.walker (3/5/2009)
So why do you respond to people who can't be bothered with the basics!!
Personally, because I'm eternally hopeful that perhaps they will learn and improve themselves. Sure, only a...
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
March 6, 2009 at 2:49 am
Shaun McGuile (3/6/2009)
UK min Holidays is 20 working days
South Africa is minimum 15 working days (3 weeks), generally increasing as a person is promoted (I had 24 at my last...
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
March 6, 2009 at 2:47 am
Jeff Moden (3/5/2009)
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
March 6, 2009 at 2:34 am
matt stockham (3/5/2009)
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
March 5, 2009 at 3:05 pm
Marios Philippopoulos (3/5/2009)
where do the scans reported on the OID-based indexes originate from, if not from join operations...
OID?
If you're talking about a scan on a table involved in a join...
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
March 5, 2009 at 3:02 pm
Perry Whittle (3/5/2009)
i was under the impression that a database backup in simple recovery mode also initiates a checkpoint which will truncate the log file
Might do. Did something I said...
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
March 5, 2009 at 2:52 pm
jcrawf02 (3/5/2009)
GSquared (3/5/2009)
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
March 5, 2009 at 2:51 pm
Marios Philippopoulos (3/5/2009)
Doesn't that involve an index scan?
Not with good indexes. Single row index seeks or a full index scan or seeks on some other criteria followed by a...
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
March 5, 2009 at 2:12 pm
Bruce W Cassidy (3/5/2009)
But I don't see any advantage for using the date over an ID field, so I still tend to use an ID field.
There is 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
March 5, 2009 at 2:08 pm
Bruce W Cassidy (3/5/2009)
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
March 5, 2009 at 1:59 pm
Marios Philippopoulos (3/5/2009)
What is this about a uniquifier, can you pls elaborate?
http://sqlinthewild.co.za/index.php/2009/02/09/all-indexes-are-unique/
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
March 5, 2009 at 1:53 pm
Jan Van der Eecken (3/5/2009)
Now, that's interesting Gail, any official MS evidence to back this up?
No, just lots of experience reading exec plans. Tables accessed within a scalar function doesn'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
March 5, 2009 at 1:52 pm
Bruce W Cassidy (3/5/2009)
(also from my experience) dates aren't good candidates for clustered indexes as they require a "uniquifier".
They can be very good candidates for clusters, especially a datetime...
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
March 5, 2009 at 1:49 pm
Marios Philippopoulos (3/5/2009)
I think usage is an important consideration, especially when the table is large.
Then we'll have to agree to disagree on that. I prefer, especially on larger tables, 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
March 5, 2009 at 1:45 pm
Marios Philippopoulos (3/5/2009)
Based on the above info, should I be making the last index, UC_tblName_col1, clustered?
I would not look at usage to decide on a clustered index. There are other...
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
March 5, 2009 at 1:01 pm
Viewing 15 posts - 40,516 through 40,530 (of 49,552 total)