ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,456 through 7,470 (of 10,143 total)

RE: How to Find Duplicate Images

Cast your IMAGE column to VARBINARY(MAX), which is compatible with DISTINCT and ROW_NUMBER().
See also http://msdn.microsoft.com/en-us/library/ms187993.aspx
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 7, 2010 at 4:02 am

#1217214
RE: Inside the Optimizer: Constructing a Plan - Part 1

Feature-packed and very readable article as always Paul.
It's a little like watching your favourite tv program - just as you're really getting into it, you reach the end and the...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 7, 2010 at 2:56 am

#1217193
RE: Strange--About SELECT @s=@s+name FROM ***

ColdCoffee (9/6/2010)
Are we in for a Connect Item ?
Nope, it's an unsupported use of variable assignment which yields unpredictable results and has already been covered on the forum here.
The examples...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 9:11 am

#1216963
RE: Strange--About SELECT @s=@s+name FROM ***

It's looking promising. I'd like to hear a few opinions from others first.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 7:36 am

#1216928
RE: Strange--About SELECT @s=@s+name FROM ***

There's more:
DECLARE @s1 varchar(10), @s2 varchar(10)
-- '10__Jack'
SET @s1 = '10__'
SELECT @s1 = @s1 + Name--, @s2 = 'x'
FROM (SELECT ID = 1, Name = CAST('Sam' AS VARCHAR(10)) UNION ALL...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 7:18 am

#1216924
RE: Strange--About SELECT @s=@s+name FROM ***

ColdCoffee (9/6/2010)
Oh Yeah, CM, i got it.. But why would Chunk 1 truncate the result first place ?
It doesn't look right to me either. Check these out:
DECLARE @s1 varchar(10), @Name1...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 6:29 am

#1216901
RE: Strange--About SELECT @s=@s+name FROM ***

ColdCoffee (9/6/2010)
Chris Morris-439714 (9/6/2010)
Try this, CC:
--SQL 3(use 2 variable together,the same results)
SELECT @s1 = '10_45', @s2 = '20_45'
SELECT @s1 = @s1 + NAME--, @s2 = @s2 + NAME...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 6:13 am

#1216896
RE: Strange--About SELECT @s=@s+name FROM ***

Try this, CC:
--SQL 3(use 2 variable together,the same results)
SELECT @s1 = '10_45', @s2 = '20_45'
SELECT @s1 = @s1 + NAME--, @s2 = @s2 + NAME
FROM ( SELECT...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 5:58 am

#1216893
RE: Strange--About SELECT @s=@s+name FROM ***

ColdCoffee (9/6/2010)
Chris Morris-439714 (9/6/2010)
What exactly do you find strange?
Chris, even in the first try i dint find anything strange.. Execute them, u will find it strange..
Must be monday morning effect...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 5:32 am

#1216877
RE: Strange--About SELECT @s=@s+name FROM ***

What exactly do you find strange?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 5:08 am

#1216862
RE: Join condition

-- create a sample table, correcting typos in column names and values
DROP TABLE #Rose
CREATE TABLE #Rose (Branchname VARCHAR(20), [status] CHAR(1), amount INT)
INSERT INTO #Rose (Branchname, [status], amount)
SELECT 'London', 'A', 100...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 6, 2010 at 4:30 am

#1216837
RE: getting duplicate records for a primary key column

ekknaveen (9/3/2010)
Lowell, Same problem I am facing when trying to insert 1 month data I am getting duplicate records. Can you tell me how to overcome this?
Naveen
Read about sequential tables...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 3, 2010 at 5:03 am

#1216091
RE: getting duplicate records for a primary key column

You have forgotten to describe the problem.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 3, 2010 at 3:31 am

#1216068
RE: Need help in complex search query optimization

Here's some more helpful advice to go with Dave B's.
The part you are commenting out is a query which can be run in isolation from the rest of the query....
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 3, 2010 at 2:55 am

#1216059
RE: filtering with a alias

Cristian Maidana-360609 (9/2/2010)
Hi, thanks for your answer.
bellow the original Query, when i implemented your suggestion, i have the "Msg 102, Level 15, State 1, Line 12
Incorrect syntax near ')'."...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

September 2, 2010 at 9:46 am

#1215715

Viewing 15 posts - 7,456 through 7,470 (of 10,143 total)