ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,321 through 7,335 (of 10,143 total)

RE: Need help on TSQL

Here's a Q&D alternative from a TSQL grunt:
SELECT
Value,
Item
FROM (
SELECT
Value,
Item,
[Instances] = COUNT(*) OVER (PARTITION BY Value, Item)
FROM #t1
) d
WHERE Instances = 1
I...
^{“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 23, 2010 at 7:10 am

#1226297
RE: Today's Random Word!

Daniel Bowlin (9/23/2010)
un-freakin'-believable. I think this could go on forever. 😛
Un-freakin'-stoppable. It will!
^{“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 23, 2010 at 6:57 am

#1226285
RE: Length greater than Nvarchar(max)--Need help

wisdom.vivek (9/23/2010)
Better to use 'Text' DataType whenever we need to store large texts in our database.
Please explain why, in a SQL Server 2008 forum section?
^{“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 23, 2010 at 6:03 am

#1226238
RE: Length greater than Nvarchar(max)--Need help

antonyp 46888 (9/23/2010)
Hi.
The datatype for that column Nvarchar(Max)
Thanks
It's not at all clear what you are trying to do.
Are you attempting to insert a string into a Nvarchar(Max) column?
How are you...
^{“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 23, 2010 at 5:17 am

#1226222
RE: Length greater than Nvarchar(max)--Need help

What is the data type of this column which is causing problems?
^{“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 23, 2010 at 5:11 am

#1226217
RE: Invalid length parameter passed to the SUBSTRING function.

Looks like Kingston's got the nail on the head here.
As a matter of interest, what is the aim of this operation?
The first action grabs everything in a string to 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 23, 2010 at 4:32 am

#1226200
RE: Trying to optimize performance of query having Hash Matches & Agreegate

Can you please post the view definitions:
vMBlockstoFinal1, vMBlockstoFinal2, vMBlockstoFinal3, vMBlockstoFinal4
Thanks
^{“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 23, 2010 at 4:18 am

#1226196
RE: Slow performance in a cursor when using a sub select as part of the where clause

Two suggestions
Run this part on its own: (select clientid from table where ...)
Post the whole sproc.
^{“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 23, 2010 at 4:13 am

#1226193
RE: Update table Set with calculations and varibles

Ken@Work (9/22/2010)
I don't believe Case will allow me to do what I need.
As I said there will be many (100 plus) variables which some may or may not be used...
^{“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 22, 2010 at 8:01 am

#1225611
RE: Multiple replace on 1 column in select statement.

Mike Menser (9/22/2010)
I would think it would be more taxing at the server to write a loop, or create a temp table and insert all the values and then do...
^{“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 22, 2010 at 7:46 am

#1225593
RE: Multiple replace on 1 column in select statement.

Mike Menser (9/22/2010)
Can someone please explain the drawback of having a nested replace?
It can be awkward to get all those pesky commas and brackets in the right place? Small price...
^{“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 22, 2010 at 7:20 am

#1225560
RE: Multiple replace on 1 column in select statement.

vevoda.ulath (9/22/2010)
...
Well, my intention is to write query for select data from #myTable using replacements from #replacements table, i.e. desired output is
XXXX something else YYYY
YYYY YYYY aaXXXX
Hope it's clear, thx...
^{“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 22, 2010 at 6:18 am

#1225501
RE: Multiple replace on 1 column in select statement.

vevoda.ulath (9/22/2010)
Yeah, not nice solution. Anyway, I'm stuck too to do such.
Something looking pretty useful was posted on other forum:
CREATE TABLE X_REPLACEMENTS (
string NVARCHAR(100),
replacement NVARCHAR(100));
INSERT INTO X_REPLACEMENTS VALUES ('abc','123');
INSERT...
^{“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 22, 2010 at 4:50 am

#1225450
RE: Rows to columns

Bob's made some excellent points there. In case you return to ask a few more questions - please do if you get stuck - here's a bit of code which...
^{“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 22, 2010 at 2:43 am

#1225382
RE: Are the posted questions getting worse?

Alvin Ramard (9/21/2010)
Steve Jones - Editor (9/21/2010)
Keep up the bad jokes and we'll likely get 30 a day 🙂
A query walks into a bar, sees two tables and says: "May...
^{“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 22, 2010 at 2:19 am

#1225375

Viewing 15 posts - 7,321 through 7,335 (of 10,143 total)