The Heap™ – Consultancy ©®

« first day (1861 days earlier) ← previous day next day → last day (3013 days later) »

ypercubeᵀᴹ

7:20 AM

@Phil Oh, I answered one q. Didn't realize it was this guy.

Tom V

7:53 AM

morning

Phil

Quite enjoyed watching the Super Bowel last night.

Daniel Hutmacher

8:42 AM

-1

Q: Unable to create UNIQUE Filtered index with IGNORE_DUP_KEY = ON

I have a table for which I want to have a unique index with IGNORE_DUP_KEY = ON, however I only want this index (and ignoring the duplicates) to apply only to a subset of the table - only rows with FLAG = 1. CREATE TABLE [dbo].[FOO] ([ID] NOT NULL, [Value] [int] NULL, [FLAG] [bit] NULL) When t...

Genius.

1 hour later…

dezso

9:51 AM

@AndriyM isn't there in SQL Server something like

CREATE UNIQUE INDEX ON bla WHERE flag <> 1;

(and then maybe create a non-unique index on flag = 1)

or I misunderstood the question?

Andriy M

@dezso Yes, this is called a filtered index. The OP's problem, however, is to use IGNORE_DUP_KEY with a filtered index, which is explicitly not allowed.

dezso

but a unique index with IGNORE_DUP_KEY is a non-unique index?

Martin Smith

An interesting write up of a memory grant problem (for SQL Server folks) blogs.msdn.microsoft.com/bharry/2016/02/05/…

Daniel Hutmacher

Xacly. :)

Martin Smith

@dezso No - it silently drops duplicates/

Andriy M

9:54 AM

@dezso It's a unique index that silently drops duplicates.

dezso

I see

that's strange :)

ypercubeᵀᴹ

@dezso it's a unique index. The IGNORE_DUP_KEY allows SQL Server to behave like MySQL

ConcernedOfTunbridgeWells

Morning all

Andriy M

morning

Daniel Hutmacher

Morning!

Martin Smith

9:58 AM

They have their uses. Can be more efficient than removing duplicates in the source query when you don't care which duplicate is retained or are inserting in batches where the order of the batches is also the order of priority anyway.

ConcernedOfTunbridgeWells

@MartinSmith long time no see.

Andriy M

@ypercubeᵀᴹ To lure MySQL crowd, perhaps :)

Martin Smith

@ConcernedOfTunbridgeWells Morning! Yes it's been a while since I visited the heap.

2 hours later…

Phil

12:35 PM

Windows 10 & talking to Microsoft under the hood: voat.co/v/technology/comments/835741

James Anderson

1:16 PM

@MartinSmith This one shows the query that caused it all blogs.msdn.microsoft.com/bharry/2016/02/06/…

That's a lot of query hints

ypercubeᵀᴹ

@JamesAnderson and a TOP without ORDER BY ...

James Anderson

@ypercubeᵀᴹ Very nice

Mark Sinkinson

1:42 PM

@MartinSmith That caused us loads of issues on Thursday

Max Vernon

2:05 PM

@TomV lol, I have Bitly link to that video.

@Marian nice one - that seems like a very cool instrument. Thanks for the link!

Phil

This pub is amazing!

Tom V

2:23 PM

Lol, a coworker who sits across the table his relationship ended this weekend, only 2 days later he's tindering around

"hey I know this girl", I ask if the girl will see his photo too

he realizes she will and she's his exes best friend

Way to confirm stereotypes about men :D

Daniel Hutmacher

@TomV Hahaha! Yes, he must be absolutely heartbroken.

James Anderson

@Phil Nice! Where is that?

Marian

2:43 PM

@Phil indeed, looks amazing

@MaxVernon no problem, thought it would help

Royi Namir

3:01 PM

We have a problem in our company. Azure. SQl server 2008 . sql is working very slow.

even if we're on RDP. and we open ssms , it is very slow.

8 cores , 24GB RAM.

( new server)

JNK

@JamesAnderson Googling the message in the stained glass tells me it's Philharmonic Dining Rooms in liverpool

books.google.com/…

Phil

@JNK Yup :)

dezso

> We have a problem in our company. Azure.

sorry

James Anderson

3:22 PM

@JNK Good find.

Zane

Our our Denver friends in here or mayhaps they are too hungover to head into the officce today.

Zane

4:17 PM

Think I've got my answer then.

1 hour later…

swasheck

5:23 PM

@Zane not hung over

dezso

@swasheck just very tired?

Zane

@swasheck lol why not?

swasheck

@dezso prepping for my sql sat preso so i'm busy

@Zane we had a large group of friends over on saturday night during which i drank way too much and stayed up way too late

so drinking didnt sound all that enjoyable last night

this means business, by the way

Rakomelo

Rakomelo (Greek: ρακόμελο (or racomelo) from raki (ρακή) + meli (μέλι), meaning honey) is a Greek mixed alcoholic drink. It is a digestive spirit, high in powerful antioxidants such as flavonoids and it is traditionally used by many Greeks as a home remedy for a sore throat or cough. == Types == It is made by combining raki or Tsipouro with honey and several spices, such as cinnamon, cardamom, or other regional herbs. It is produced in Crete and other islands of the Aegean Sea and on the Greek mainland, chiefly consumed during the winter as a warm drink. A similar drink is baked raki, which is...

2 hours later…

Tom V

7:23 PM

@swasheck I once was really sick from that

I didn't know what it was, got offered a big long drink glass of that, homebrew by a restaurant owner

dezso

@TomV I am going to try it - have met all the indications

Tom V

the size of the glass suggested you could take a good portion in one go

you can't

dezso

well, there are places where you drink vodka by 100 g units

Zane

8:07 PM

@swasheck makes sense. Great game though.

Daniel Hutmacher

@AaronBertrand, if you want to pick up the "special date" discussion, this is probably a better place to do it than in the comments. However, I'm pretty sure we're on the same page. :)

swasheck

8:36 PM

@Zane i enjoyed it

2 hours later…

Zane

10:11 PM

Same

« first day (1861 days earlier) ← previous day next day → last day (3013 days later) »

all rooms