Also check at sqlpass.org both for local training and free online training.

Depending on your location, I'd suggest finding the nearest user group and the nearest SQL Saturday event. Those two places will enable you to begin to network with other locals....

From the sounds of things, you're not so much looking at data warehousing as you are the performance of the queries being used against the data warehouse. If so, I'd...

SQLRNNR (1/22/2014)

No, schedule regular backups and...

Congrats! That's great!

Now, run a backup.

You can look at sys.dm_exec_query_stats to get an idea of CPU use on queries. But, that DMV is dependent on what is currently in cache. So queries that have aged...

Your first stop must be the execution plan. You can guess at causes to performance issues, but without the execution plan, they're just guesses. And I totally agree, joining view...

While I don't argue with everyone's caveats, let's focus just a bit. If we're talking about a simple query:

SELECT a.*

FROM MyTable AS a

WHERE a.GuidColumn = 'Appropriate value';

And that column is...

I'm pretty sure the express limit is the data file only, independent of the log. Documentation that I could find isn't completely clear though. Several places it says "10gb of...

Been running it that way for quite a bit with no issues. My workloads aren't terribly heavy though.

That is the number used to compare to the cost threshold for parallelism. That fact doesn't change where the numbers come from. The optimizer assigns them based on internal processes,...

I'd suggest following the recommendations in the error message and run DBCC CHECKDB. Depending on where the statistics are, and if there are any other underlying problems, you may be...

Yep. It's cumulative, so a plan with zero value ads zero to the number. Understand though, just because an operator says it has zero cost doesn't mean it actually did...

Those values accumulate as you go through the plan, each one reflecting the ones before it in the plan in the physical processing order (right to left).

But, question, why no primary key? The vast majority of tables absolutely should have a primary key. Just as the vast majority of tables should have a clustered index (and...