Testing on Sql Server 2014 Dev,

Trace flag 9481 forces CardinalityEstimationModelVerion 70

and 2312 forces 120.

The correct answer for the question should be traceflag 2313.

😎

Quick thought, if the view is returning in 20-30ms, that looks like once per row in the table

😎

I'm getting slightly confused, ran queries with SHOWPLAN_XML on...

What do you find in the INFORMATION_SCHEMA for the constraints? Look for the table and column names in question.

😎

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

SELECT * FROM INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS

SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

SELECT * FROM...

A trigger with insert and update

😎

CREATE TRIGGER [dbo].[TRG_MY_CONSTRAINT]

ON [dbo].[TestConstraint]

INSTEAD OF INSERT, UPDATE

AS

BEGIN

SET NOCOUNT ON;

IF EXISTS

...

Sorry about the misunderstanding, the first post was pre industrial strength tanker sized load of espresso:-P

One solution is to use a trigger

😎

USE tempdb;

GO

CREATE TABLE dbo.TestConstraint

(

id INT...

Quick test would be checking with the the datalength function, if it corresponds to the file size, it is in the table.

😎

Good question, thanks!

I got it wrong:ermm: or did I:w00t:

Note, on Microsoft Support there is an article; Enable plan-affecting SQL Server query optimizer behavior that can be controlled by different trace...

First the DDL

USE tempdb;

GO

CREATE TABLE dbo.TestConstraint

(

id INT NOT NULL

,ProductID int NOT NULL

,Datecreated DATETIME NULL

,DateExpired DATETIME NULL

);

GO

ALTER...

This query uses UNPIVOT in a CTE. A ROW_NUMBER function assigns a number for each header/value combination, which is then used to set the output column in the latter part...

mickyT (5/14/2014)

---

Luis Cazares (5/14/2014)

---

Until you find that Gordon Abraham and Abraham Gordon (or any other combination of...

I'll do it as well, don't hold your breath:Whistling:...

Paul White (5/14/2014)

---

Is everyone running Jeff's original/updated test rig from the article to get these results?

If so, you might not be testing what you think you are. There is a...

For fun:-P, it always looks simple until one starts to meddle with it

😎

with Names as

(

select 'Mike Davis' as FullName union all

...

emilacosta (5/14/2014)

---

Hi,

Thank you for your answer. 🙂

My main question is how to get the path of the image file from the table where it is stored and load the image...