Disks are disks, even in most virtual environments. Stacking everything into a single location absolutely leads to a bottleneck.

And I am more than willing to have that discussion....

Ed Wagner (5/23/2014)

---

Grant Fritchey (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I...

Write two queries. SQL Server doesn't really support code reuse in a useful way. If you have two different sets of requirements, write two different queries.

Joining view to view like that is a very common code smell that can lead to serious performance issues. In most cases you're much better off querying the data directly...

I'd also suggest going with the schema.

Or, if you have to name the tables, I'd go with naming them MyTableStaging or something like that instead of using old school Hungarian...

That would be a job, if you have one, that is scheduled, by you the DBAs, to rebuild indexes to remove their fragmentation.

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is...

srikantmeister (5/21/2014)

---

if its scan going on your query that means you can further look for indexes to create. plus also update the statistics.

also try tuning adviser recommendation for whatever query...

Maybe there's been a recent data removal. That would shrink the size of the backups.

The same question was posted over on AskSSC. The answer is the same here. There's no filtering of any kind, so you're guaranteed to get scans. If you're running some...

You don't need a plugin to implement extended events in 2008, there's just no GUI. You'll have to write queries to start it, stop it, set it up an consume...

3gb of RAM for SQL Server and your application? That's an extremely small amount of memory to run SQL Server 2008 within. You must be seeing contention on resources.

And NEWSEQUENTIALID doesn't prevent all fragmentation, it just reduces the level of fragmentation to less than what you'll see with NEWID.

TomThomson (5/20/2014)

---

Grant Fritchey (5/20/2014)

---

You need to...