ggraber already answered your question. The best thing I could suggest at this time is for you to test it yourself. All you need to do is create...

rshafer (12/3/2008)

---

I appreciate everyone's responses regarding the date_time field. After talking with one of my fellow DBA's I used the BETWEEN command to select the dates. Here is...

Doug (12/2/2008)

---

The following two statements are taking 1:13 hours to run. How can I speed it up?

UPDATE dbo.CLAIMS SET admission_date =...

skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...

Okay, you said the restore worked the first time, but failed after that? If so, I know why. Here is the SQL for the restore that should work.

RESTORE...

Just be careful with DTA, it might not give you what you are looking for either. During a performance issue on our Finance system, it never determined that an...

Are you looking at an upgrade in the near future?

Generic answer, but it fits, "It Depends". We use schemas in our stage databse to organize the destion tables for our imports from our LOB systems. This allows...

Jeff Moden (12/2/2008)

---

jeffkretz (12/2/2008)

---

Gaby Abed (12/2/2008)[hr

Agreed...I'm working on my MCTS for SQL 2005 but I plan to emphasize my experience first on the resumes and keep the certification at the...

Okay. I remember having some problems trying to use the column alais at my last employer and ended up using the underlying column name to get it to work.

Here is a link to an article that talks about the Tally Table: http://www.sqlservercentral.com/articles/TSQL/62867/

If I remember correctly (and I just don't feel like testing it), you couldn't use a column alias in the order by in SQL Server 2000.

Is the backup failing or the restore? If the restore, can we see your restore script?

Sudheer (12/2/2008)

---

I have recently migrated from 2000 to 2005 when i run a SP in 2005 ..I am getting this error ......I dont have any clue.Help me in solving this...

Gail, I took your simple query (changed the table to Contact in AdventureWorks) and ran the following:

select title, FirstName as name, LastName as name from Person.Contact p

order by p.FirstName ...