Session ID > 50 is not a good way to determine system processes. Instead use a join to sys.dm_exec_sessions to use is_user_process something like this:

SELECT *

FROM ...

Check the compatibility level of the database you're querying against. If it's an older version, that can prevent Intellisense from working. Other than that, ensure that it's enabled and understand...

You can query sys.dm_exec_requests in combination with sys.dm_exec_sql_text to identify the query and session and then kill it.

I occasionally refer to CUD, Create, Update, Delete, when discussing the parts of ORM tools that I (sometimes) don't have problems with. Nothing in Bingle either. I think you may...

rodjkidd (1/23/2014)

He He - I know - can we turn the internet for a...

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.