You're going to have to investigate why that procedure is compiling frequently. There's nothing in the code that would cause compiles or recompiles, so start by tracking down which is...

That's pretty low. Is this wait causing a problem?

The applications(8 apps)...

The procedure is being compiled by the query optimiser to generate plans.

Is this a common wait? Are the wait times long? What is the session that's waiting trying to...

I suspect you downloaded the incorrect DB.

AdventureWorks2014 doesn't have any DIM named tables in it, as it's an OLTP demo database. The AdventureWorksDW database is the sample data warehouse and...

Most of those recommendations date back to SQL 2000, where recompilation was at the batch (procedure) level. Since SQL 2005 we've had statement-level recompile, which makes interleaving DDL & DML...

Eirikur Eiriksson (11/14/2016)

---

I used to have the same problem in Iceland, blazing fast local but anything else would be crawling, here in London I'm getting around 985Mbs on the download...

Eirikur Eiriksson (11/14/2016)

---

GilaMonster (11/14/2016)

---

Steve Jones - SSC Editor (11/14/2016)

---

I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are setup...

Steve Jones - SSC Editor (11/14/2016)

---

I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are setup is you'll get...

Distinct applies to the entire row, not individual columns.

If there are multiple values of Col1 and Col5 for a single (repeated) value in Col2, what do you want inserted?

Depending on how long this has been in the DB, you have two options:

1) Restore a clean backup and all transaction log backups since that, to get the DB back...

Jeff Moden (11/13/2016)

---

Ask Steve to give you the privs...

How???

I'm sick of just reporting them and having the spam hang around for hours afterwards

I'm going to guess it's a bug in the portion of SSIS that executes maintenance plans (since, on second look, it looks like it might be a .net error)

Patch the...

Dynamic SQL.

The times in XE are datetime2 and durations are bigints, so the properties of the datetime datatype are irrelevant. I wouldn't say it's accurate to the microsecond though, there's going...