Yes, this is also a FAQ! But unless I am mistaken, you need to take care for permissions when you DROP and CREATE. I don't think you need to do...

Hm, so the guys who just left university, know everything in theory and usually can't get a simple thing straight? What is the entry payment for such a position? On...

Just found another link:

http://support.microsoft.com/support/kb/articles/q186/1/33.asp&NoWebContent=1

Wrong link. Sorry:

http://support.microsoft.com/default.aspx?scid=kb;en-us;186133

If I understand your requirements right, Steve's solution surely works. However, I think on larger tables the use of a temp table might yield better performance.

Actually in the end...

Hey, no need to worry! SQL Server 2005 will adress this, I think.

If a stored procedure is changed via ALTER and not via DROP and CREATE you can not rely on the crdate in sysobjects. In that case i think you have...

No chance! A DATETIME always contains a DATE *and* a TIME part. See, if this helps:

http://www.karaszi.com/sqlserver/info_datetime.asp

I think MS is offering such a tool on their website. Apart from this I know there is a tool called myLittleAdmin. Don't know what they can do, but maybe...

I think these are all fair questions but not necessarily for Jr. DBAs.  Some comments: 

• In regards to question #3, Jr. level DBAs that only have knowledge of SQL...

Aah, see, it's getting heated again

Anyway...

Next, the space arguments fails because in a properly designed RDBMS, you will enforce a natural key; the...

Well, actually no workbook, but one of the best resources are the Google Groups Archives. Several MVP's have the nice habit to demonstrate good and efficient techniques using the sample...

Just out of curiosity. Which standings are you talking about?

Oh, and I forgot:

SELECT COUNT(*) FROM SomeTable Group By CAST(SomeTable.SomeDate AS INT)

Consider this:

CREATE TABLE #fool_me

(

 dt DATETIME

)

INSERT INTO #fool_me VALUES ('20050118 12:00:01.997')

INSERT INTO #fool_me VALUES ('20050119 00:00:59.997')

INSERT INTO #fool_me VALUES ('20050119...

date is really a float where the decimal part is the time.  To convert a date to date only, do this:

This is incorrect! The internal storage format for a...

This is not a joke question, right?

This is obviously for a developing DBA, not the administrating one. So, no, I don't...