Have you considered boot from SAN? Windows 200 and 2003 support it, so it is really just a matter of finding a SAN vendor that supports it at the...

You cannot use an Exchange server email alias.

Reporting services uses only SMTP format email addresses, so it must be in the form name@company.com

If you reindex the tables in the database with a maintenance plan job, the database data file has to be large enough to hold all the data, plus enough extra...

How would you like to see the output, considering that all rows in...

If you have a need for it, the function on this link generates a very complete (around 60 columns) result set for loading a Date Dimension table.

Date Table Function F_TABLE_DATE

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

Other...

I am reposting various methods for start of time periods that I originally posted on the links below.

Start of Time Period Functions

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

Function F_START_OF_WEEK to find the first day of the...

Jeffrey Williams (3/23/2009)

---

Steve,

I was hoping you might try and get past the marketing hype and actually take a look at the product itself. One of the nice features in...

steve dassin (3/22/2009)

---

Michael Valentine Jones (3/16/2009)

---

I read through a good bit of your blog the other day, and I have to say that the one question

it didn't seem to answer...

Why did you post a duplicate thread? That just makes people mad.

Duplicate

http://www.sqlservercentral.com/Forums/Topic681945-338-1.aspx

And I see now that you deleted the original post after people had commented, making it hard to...

Why not at least produce the year and month in a sortable form?

select YearMonth = convert(varchar(7),getdate(),121)

Results:

[font="Courier New"]YearMonth

---------

2009-03[/font]

I have links to a lot of info about working with Date/Time...

I have been having problems with "Posts since my last visit".

There have been a few times in the last few weeks where posts that I made never showed up on...

Do you not have a column named Date like you showed in your original query? If not, you will have to fill in the correct column name.

You have unbalanced...

Barkingdog (3/23/2009)

...3. Each database has a single "service" (non-user) account that accesses it. Instead of making it dbo (as was done in the past) I want to give that...

else datediff (day,enterdate,leavedate) end as 'totaldays'

or just do:

select datediff (day,enterdate,coalesce(leavedate,[date])) as 'totaldays'

No.