Does this do what you want?

SELECT year, monthname, MIN(startdate), MAX(enddate)

FROM [dbo].[mhs_month_week]

GROUP BY year, monthname

Test and see, with all the OR conditions that last update will have to be a table scan, but without indexes it'd have to be a table scan anyway

Restore the DB as NORECOVERY, restore the logs as NORECOVERY. It will work, but it's not a DR setup and the secondary database cannot be made readable. It's typically used...

DMVs don't store data, they're views into SQL's internal memory structures mostly, or database structures.

DBCC statements are very varied and there's...

DELETE Table1 FROM Table1 INNER JOIN Table2 ....

Steven W (5/28/2015)

---

My plan is to shut down my major apps that insert a ton of data into the two DBs, perform another full backup, run shrinkfile on DBv1 using...

Why? It'll only show clouds.

No, just that the GUI designer doesn't work up-version. Writing out and running the CREATE TABLE statement works fine

No. Sleeping sessions are doing nothing. Since they're...

WhiteLotus (5/27/2015)

---

I just tested the query by eliminating DISTINCT ..

the result is :

(45108 row(s) affected)

Table 'project_text'. Scan count 1, logical reads 2017, physical reads 0, read-ahead reads 0, lob logical...

In that case, it'll be 6 times worst than hopeless.

When it comes to IO throughput, the number of spindles is critical. You have 2. My laptop has that many in...

I'd reply and point out the flaw in his logic (he's got scientific method and scientific consensus the...

Bad cardinality estimations perhaps. Can you post the problematic plan?

SQL Server doesn't do scale-out (distributed systems) at all well.

What are you trying to do and why?

Looks like I hit a few nerves with Sunday's editorial....