marc.corbeel (10/6/2016)

---

I have this problem I cannot solve. In a stored procedure I need to make a select query. A parameter passed to the SP tells to select only the...

Nice write-up Drew, well done!

😎

One thing I missed seeing in the article was the mentioning of a POC index which is absolutely essential when working with the window functions, especially...

george sibbald (10/5/2016)

---

Lynn Pettis (10/5/2016)

---

george sibbald (10/5/2016)

---

well that's me done. I retire today so this will be my last post.

I made it into the top 30 posters at one point...

This one is purely for entertainment, it's not very efficient with 4 table scans and an expensive sort in the execution plan. It does on the other hand demonstrate some...

Any upgrades available for the Crystal Ball?

😎

ramyours2003 (10/4/2016)

---

HI

I need recommendations for better performance of sql .we have 32bit SQL servers and want to make sure we have them configured optimally for performance....

drew.allen (10/3/2016)

---

You can also improve your function by adding the WITH SCHEMABINDING option. Even though you're not using any physical tables, SQL checks whether the underlying tables have changed...

DesNorton (10/3/2016)

---

Thanks for this Eirikur. It's always good to find ways of improving performance.

What I would like to understand, is

1 - what makes Method#2 perform better than Method#1, and...

Luis Cazares (10/3/2016)

---

Jeff Moden (10/2/2016)

---

Just curious.... what are you doing that needs so...

NineIron (10/3/2016)

---

I have a table with Lab values in it. The lab lest results can either be a number or a comment such as "Unable to perform". Is there a...

You...

Quick example, should be enough to get you started.

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.stat') IS NOT NULL DROP TABLE dbo.stat;

create table dbo.stat

(

gameID int

...

You are very welcome.

😎

Note that there must be entries in the set that cover the full range, otherwise the query will not return anything when querying for missing ranges.

Can you please post the DDL (create table) script for the relevant tables, sample data as insert statements and the expected results?

😎

Further, can you also post the full output...

Don't be scared of him,...