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

Just use sp_msforeachdb. That's what it's for. But, if you really, really don't want to use it, set up a cursor to cycle through the databases (that's all that query...

Or use INIT and FORMAT with the backup command to make it always be a single file instead of a series of files stacked together.