Have a look at these articles:

http://www.2000trainers.com/section.aspx?sectionID=2&tab=articles

There's also a SQL Server Newbies forum on this site that has some good links and references.

Sounds like you need to do some research on data warehousing and ETL.

The absolute basics:

Design the new DB (data warehouse)

Set it up

Create a DTS package (or two or three...) to...

Sounds like the logon the Agent is running under doesn't know about / have access to that drive.  Have you tried using the UNC path?  Is the server/agent on a...

Another issue of interpretation.  The question asks about receipt of messages, the command that is the "correct" answer disables Service Broker entirely.

Please refrain from cross-posting.  A single post is sufficient.

If you're using 2005, you should be able to use PIVOT.

Here's an intro: http://msdn2.microsoft.com/en-us/library/ms177410.aspx

Ironically enough, I was planning on asking a similar question today.  Your link gave me the information for which I was looking.  Thanks, Michelle.

*curtsies*

Thanks, Tim.

This is how it was explained to me:

"the optimizer “looks” at the filter values in the WHERE clause and compares that against statistic information stored in the tables and indexes. ...

Is the variable @CampaignID a local variable or a passed-in parameter?

I'm guessing it's local.  If that's the case, that's your problem as the optimizer can't effectively use local variables...

The general wisdom is that clustered indexes are best when one does a range query, so the datetimecol may indeed be a good candidate for a clustered index.  But, yes,...

Thanks.

Coincidentally enough, I have been mulling over the idea of starting to publish and/or teach.  I just have to figure out what subject I want to tackle.  There's a few...

Have you tried a manual refresh?  EM is notorious for that (at least IME).

I wanna be the next Joe Celko

No, seriously, I want to be an expert in database design and theory.  I want to be a...

On the other hand, I could tell you about all the job opportunities I've lost out on due to offshoring and H1-B's.  (Not to mention decisions to hire a junior...