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...

I've got a number of examples on how to "get latest" rows in this article on versioned data.[/url]

Since you are completely on your own on this, again, I suggest getting a copy of my book. Links are down in my signature.

After you get backups in place... that...

praneethydba (1/21/2014)

---

HI,

Still in Recovery. I am Panic.

My company is running this database from past 8 years and no indexing, no Primary/clustered index, No jobs etc.

So I want to streamline all...

Ed Wagner (1/21/2014)

---

Grant Fritchey (1/21/2014)

---

Hey Ed, make sure you use FORMAT in addition to the INIT statement. INIT doesn't rewrite the header, so if you ever do modify the backup...

Hey Ed, make sure you use FORMAT in addition to the INIT statement. INIT doesn't rewrite the header, so if you ever do modify the backup being done in some...