I would hope that someone qualified to be "IT Director" would have a good idea what a DBA does and be aware of the reasons to hire or not hire...

Use the CREATE TABLE statement to put the table on the desired filegroup.

Try using these functions. They're already debugged. 😎

Start of Week Function:

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

End of Week Function:

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

Does this job have a work location?

Make sure your resume is well written with no misspellings, nonexistent words, obscure acronyms, or chat-speak.

I consider English communication skills a must have for a DBA or developer, and I...

I would be helpful if you explained what you are trying to do.

Depends on how you use NULL. It could mean does not exist, does not apply,...

Select

*

from

MyTable

where

@MyDate > StartDate and @MyDate < EndDate

Just to flog this topic a little more.

When you are using text stings for dates, you should use the format 'YYYYMMDD HH:MM:SS.MIL'

Example: '20080116 18:01:25.997' (or '20080116' for date only)

This is...

Rajan (1/16/2008)

---

I would say backup/restore if there is a huge amount of free space in the database. If the datafiles dont have much free space, go for detach/attach.You need to...

It would be helpful if you showed us the code you are using to insert into the tables, and the DDL statements for the tables.

This is the simplest way.

use master

alter database MyDatabase set offline with rollback immediate

drop database MyDatabase

I would only split the tables under certain conditions, like one of the following:

1. If there was a row in tblDistributorStats for only some of the rows in tblDistributor.

2. If...

ALZDBA (1/16/2008)

---

well maybe, just maybe, ... since you're on SQL2005 ....

you may want to add a computed_column of the datetime datatype and put an index on it.

check BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8d17ac9c-f3af-4bbb-9cc1-5cf647e994c4.htm

create table...

If you have to defrag a heap (with downtime allowed), and you don't want to add a clustered index, you can:

1. Rename the table to prevent access to it.

2. Create...