cs_troyk (9/14/2009)

---

John Rowan (9/10/2009)

---

It also gives the database users an idea of which candidate key may have the clustered index on it. I know that Primery Keys do not...

This discussion seems a bit pointless.

Although SQL Server could be implemented without having PRIMARY KEY, it’s not going to happen without some overwhelming advantage to getting rid of it. ...

michael.welcome (9/3/2009)

---

Update:

The project was a huge failure as I expected.

It was so convoluted that the required functionality was never able to be implimented. Most screens never worked as expected...

You should have suggested simplifying the design further by storing all the data in a single row and column of a single table. Obviously, XML would be ideal for...

nick (9/8/2009)

---

Thanks for the example, but I think you have missed the point that my date isnt one standard datetime field, its actually made up

of two columns, date and time....

How would I do with these answers?

What would you describe as your strengths?

I can answer really stupid questions without letting my contempt for the person asking the question show.

How do...

This shows how to convert the actual datetime to a business date.

select

a.MyDate,

BusinessDate = dateadd(dd,datediff(dd,0,dateadd(hh,-5,a.MyDate)),0)

from

...

Sounds like you were interviewed by some HR weenie.

I never let HR get any more involved in the hiring process for DBAs than contacting recruiters and placing advertisements. I...

Here is another series of tests showing the difference in performance of inline code vs. scalar UDFs.

Demo Performance Penalty of User Defined Functions

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78601

The functions in the following links have the...

Do you mean that having Primary Keys makes it easier, or not having them makes...

Can you explain the reasons to NOT use a PRIMARY KEY?

Exactly how will not using them improve anything?

II have been asked on occasion over the years to “fix” data.

If it’s a case where the change is a correction to the data and not a falsification, I request...

Conversion of 0 or other numbers directly to datetime is documented in SQL Server Books Online.

select

DT,

...

The performance of SAN depends on so many things that you really need to test it to make sure you have the expected performance. The 9 MB/Sec you mentioned...

Tables and indexes are assigned to filegroups, not files, so the normal assumption will be that the data is spread across all files in the filegroup.

If you run DBCC SHRINKFILE...