Viewing 15 posts - 40,546 through 40,560 (of 49,571 total)
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...
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...
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...
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...
March 5, 2009 at 1:01 pm
rmechaber (3/5/2009)
March 5, 2009 at 12:05 pm
Derek Dongray (3/5/2009)
Also I'd be interested to see the source of the User-defined function FFG_FX_JUST_DATE since, although it doesn't add the the estimated cost
Scalar functions never do. It's one of...
March 5, 2009 at 11:47 am
rmechaber (3/5/2009)
Would you recommend as a best practice that I include a Shrinkfile for the log in my daily Agent backup job?
Absolutely not. Worst thing you could do (short of...
March 5, 2009 at 11:45 am
Transactional replication?
Done any index rebuilds recently?
rmechaber (3/5/2009)
I thought that Simple recovery mode wiped the transaction log on a full backup
No. In Simple the log is truncated whenever a checkpoint occurs....
March 5, 2009 at 10:32 am
Steve Jones - Editor (3/5/2009)
I suggested he post the thread in the MVP groups and see who was acting unprofessional.
Ooohhhh... I sooooo wanna see the results if he does!
😀
March 5, 2009 at 10:26 am
Lynn Pettis (3/5/2009)
went off a bit on him for his comments. I then...
March 5, 2009 at 10:11 am
sam.marsden (3/5/2009)
March 5, 2009 at 10:08 am
Chris Morris (3/5/2009)
Hey Grant, your chum's back in town. I'm in the bleachers with a couple of beers.
I'll join you. Got any coffee?
March 5, 2009 at 10:07 am
sql-oholic (3/5/2009)
I was hoping to get some tips & tricks .. best practices when using temp tables in sproc
Without seeing code the best I can offer is very general advice.
Make...
March 5, 2009 at 10:07 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic669345-360-1.aspx
March 5, 2009 at 10:05 am
This assumes you have created a table called MailQueue that has, at minimum columns ToAddress, MailSubject and MessageBody.
This is to give you an idea, it will obviously need modifying
CREATE TRIGGER...
March 5, 2009 at 9:37 am
Viewing 15 posts - 40,546 through 40,560 (of 49,571 total)