If the table structures to be returned are the same for all conditions, you can use UNION ALL with the appropriate WHERE conditions so that only one query ever returns...

What is the data type of "[SatisfiedPercentage]"? Because it's also part of the same CASE statement.

You might want to consider adding a flitered index on deceased date including the PatientNumber and DivisionCode. Then you can do an easy self-join, which I think should be...

Andre 425568 (5/23/2016)

---

We found that fixing this brings fragmentation down by anything from 0-60 % after doing table rebuilds, after rebuilds we staill have fragmentation on tables and indexes. We...

It looks like some columns are missing from the SELECT above, so I can't try to do the full query, but here's a general approach for using a lookup table...

IF OBJECT_ID('tempdb.dbo.#DBDATATYPES') IS NOT NULL

DROP TABLE #DBDATATYPES

CREATE TABLE #DBDATATYPES

(

DbName nvarchar(128)

,TableName nvarchar (128)

,ColumnName nvarchar (128)

,Datatype nvarchar (128)

)

INSERT INTO #DBDATATYPES

EXEC sys.sp_MSforeachdb '

IF ''?'' IN (''master'', ''msdb'')

...

SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, START_DATETIME), 0) AS START_MONTH,

SUM(SALES) AS TOTAL_SALES

FROM MY_TABLE

WHERE START_DATETIME >= '20150101' AND START_DATETIME < '20150511'

GROUP BY DATEADD(MONTH, DATEDIFF(MONTH, 0, START_DATETIME), 0)

ORDER BY...

Matthew Saggers-700210 (5/12/2016)

---

Lowell, yes this is the way to go. I found when the compute is quite complex like

A int

B int

c int

D as A+B

E as ((A+B) / c) /...

orjan.franzen (5/6/2016)

---

Having to drop an unique index to increase performance can be done easily with a generated script wether it's a primary key with clustered index or a unique clustered...

orjan.franzen (5/6/2016)

The usage of unique indexes instead of declarative primary key constraints is just an old way of implementing entity integrity and should be avoided/forbidden if it's not for backwards...

No, it's not....

Select mcr.*

FROM dbo.G_MASTER_CODING_RESULTS AS mcr WITH (NOLOCK)

left join (

SELECT

MCRNUS.MASTER_CODING_RESULTS_ID

FROM G_MASTER_CODING_RESULTS AS MCRNUS With (NOLOCK)

WHERE...

pietlinden (5/4/2016)

---

You could... but I'd read this first:

http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/

I would have sworn that EXISTS stops as soon as a True/False changes, while an IN reads the whole table. So I would...

I coded the backups to go to c:, which is local drive for that node only,...

Lynn Pettis (5/3/2016)

---

ScottPletcher (5/3/2016)

---

You can backup the dbs using the commands below from within SSMS or other appropriate SQL utility. Since someone has gone to the trouble to cluster...