DavidDroog (8/5/2015)

---

Hi ChrisM

Replies below

1.Clients with “disciplines” filtered by geography using the geography parameter. This query should reference client, client address and geography tables plus those required to identify "disciplines". If...

DavidDroog (8/5/2015)

---

Hi Guys

Here is a zipped up bak (SQL Server 2008 R2) file filed with sample data and the proc. It is 17 meg so too large to post here...

s.chandrahasan (8/5/2015)

---

Hi , Thanks for you update.

I am looking for like a function to insert data like below instead of creating insert statement in your query.

select Name,Value1,Value2,Value3 from ...

ScottPletcher (8/3/2015)

---

ben.brugman (8/3/2015)

---

This weekend I have been away from the keyboard. And as often the best idea's occure when away from the keyboard. E.g. on my bike (pushbike) or under...

So escalate it to your boss. This isn't an issue for a junior. Whilst he's dealing with that, get yourself some decent indexing...

Are you the DBA, by any chance?

Why are you unable to push this issue back to the...

coolchaitu (8/3/2015)

---

Chris Sir,thanks a lot. I have pasted a latest post. Could you please see that screenshot and advise.

The SPIDs are changing frequently and they are multi-threaded. Wait type...

The...

How can you be certain that the extra time taken for the first run of this stored procedure is the time taken to compile and not the time taken to...

That index doesn't contain SMSId. You could change an existing index for this query:

CREATE NONCLUSTERED INDEX [IX_tblSMS_Sent_SMSId] ON dbo.tblSMS_SentTest

([SMSId] ASC) INCLUDE (SentDate)

WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB =...

The two plans are for different queries. I've looked at the second one because it causes an optimiser timeout - that is, it's too convoluted for SQL Server to guarantee...

SELECT

p.Username,

COUNT(mr.RecipientId) AS [TotalMessages],

x.NewMessage

FROM [User].[User_Profile] p

JOIN [MailBox].[Message] m ON p.Id = m.SenderId

JOIN [MailBox].[MessageRecipient] mr ON m.Id = mr.MessageId

CROSS APPLY (

SELECT [NewMessage] = CASE

WHEN mr.ReadDate IS...

Is Skynet Coming?

Yup.

Massive well done - but how on Earth do you top that? If you choose to do a PhD, you won't have time for us... :crying: