Y.B. (11/15/2016)

---

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try an Irish Cheddar which was excellent. I like...

Luis Cazares (11/14/2016)

---

Eirikur Eiriksson (11/14/2016)

---

Can you post the actual execution plan, would make this a lot easier.

😎

If the plan contains sensitive data then you can use SQL Sentry Plan Explorer...

A few pointers in here too:

DECLARE @MergedRecord INT = 0

IF EXISTS ( -- this subquery isn't correlated - it returns a CONSTANT

SELECT 1

FROM ETLCorrelation

WHERE DestinationTable = 'ConfigOptionTypeProperty'

AND...

GilaMonster (11/7/2016)

---

Got my blog working again, finally. Hosting provider can't figure out how the files got wiped, restored a 3 month old backup, got my name incorrect in their last...

What's already been said, but also:

Try forcing a join or two. You know that the join introducing Patientvisitprocs should be a hash join because of the volumes, and PatientVisit should...

Indexed views - typically these are used as a performance-enhancing trick. Are you experiencing performance issues with these...

sindhupavani123 (11/4/2016)

---

Thank you all for the help.

What should i do if i want two columns with below output?

Client fields value ...

This also matches the somewhat ambiguous and vague requirements:

;WITH SAMPLE_DATA(Client,fields,value) AS

( SELECT X.Client,X.fields,X.value

FROM ( VALUES

(111,'Decision','accept')

...

sindhupavani123 (11/4/2016)

---

I have the following data with client account decision and status

Clientfields value

111Decisionaccept

111Statusdeposited

112decisionaccept

113Decisionaccept

114Decisionaccept

114Statuscontract

115DecisionConditional Accept

115Statusdeposited

116DecisionConditional Accept

117DecisionConditional Accept

118Statuscontract

118DecisionConditional Accept

I would like to get

records...

keith.gilbert-1064677 (10/6/2016)

---

The product I work on has a set of objects per business entity, Some customers have 200+ business entities. When a customer moves from one version of our...

From Glenn Berry's diagnostic queries series:

-- Find single-use, ad-hoc and prepared queries that are bloating the plan cache (Query 44) (Ad hoc Queries)

SELECT TOP(50) [text] AS [QueryText], cp.cacheobjtype, cp.objtype,...

Or this perhaps? The requirement is rather vague.

DECLARE @Sample TABLE (GroupCode char(1), BinNumber int, ValueCode varchar(20), DetailCode varchar(20))

INSERT INTO @Sample (GroupCode, BinNumber, ValueCode, DetailCode) VALUES

('A',1,'ValueA','Details1'), ('A',2,'ValueA','Details2'),

('B',1,'ValueB','Details1'), ('B',2,'ValueB','Details2'), ('B',3,'ValueB','Details3'),

('C',1,'ValueC','Details1'), ('C',2,'ValueC','Details2'),...

Minnu (11/4/2016)

---

Hi Team,

Want to create a view using below query, and also want to apply indexes on that view.

SELECT NT.ID, U.acc_name

FROM dbo.NR_VT NT WITH (NOLOCK),

...

Jeff Moden (11/1/2016)

---

ChrisM@Work (11/1/2016)

---

So we decided to try cache priming - getting the required data into cache with a low-cost read before processing it. A single loop of the code...

Lynn Pettis (11/1/2016)

---

ChrisM@Work (11/1/2016)

---

Jeff, the method Eirikur's describing works really well. We implemented such a method here for cleaning up a substantial table earlier in the year. The existing method...