Mail sent. I'll post his answer here.

I would carefully watch the app that is updating that table.

Hey, that will be my 3,000 post. Congrats to me

ROTFL

hm... I always thought that defining a primarykey implies uniqueness

What are the results of dbcc checkdb?

q.e.d.

All I can offer right now, is to contact Erland (as the author of my reference article) and ask him. I know he's working on an update of the article...

set nocount on

set statistics time on

select dateadd(d,datediff(d,0,msgdatereceived),0) from mails_header

SELECT CAST(FLOOR(CAST(msgdatereceived as float)) AS smalldatetime) from mails_header

select convert(varchar(10),msgdatereceived,120) from mails_header

set statistics time off

set nocount off

SQL Server Execution Times:

   CPU time =...

Would you like a yes or a no as the answer?

I know, I know. Every little bit counts, but I would say if...

Yes, it should almost always be faster!

But I am having a deja vu right now

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=102103

BTW, Why do you want to pursue an MCDBA?  I'm assuming you're intending to finish high school before pursuing a career.  Certifications require upgrading with new releases of software, to remain...

I don't know Oracle, but I would take a look at BOL for DECLARE CURSOR

How do you get trailing 0s in a numeric column?

A look at the table in EM should not show such thing, a linked table in Access neither. Don't get confused...

It shouldn't make a difference. AFAIK relations are for data integrity and don't have an effect on JOINs.

Any reasons for float?

declare @flt decimal(19,3)

select @flt = 500000000000.845

select convert(varchar, @flt)

------------------------------

500000000000.845

(1 row(s) affected)

Can you post your whole statement?

First of all I would make sure if you really need unicode columns.

Maybe a little example will illustrate the difference

declare @a varchar(20)

declare @b-2...