ChrisM@Work

Forum Replies Created

Viewing 15 posts - 3,316 through 3,330 (of 10,143 total)

RE: reg sql query

p.avinash689 (5/28/2014)
I tried the above format but i didnt get what i want to be.
This isn't helpful. As you can see, BWFC now has to ask you a bunch...
^{“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

May 28, 2014 at 4:48 am

#1716956
RE: COALESCE to replace multiple CASE statements

nimalatissa (5/27/2014)
I'm very confused. These tables are normalized to 3rd normal form. There shouldn't be anything to do with that. the column in this table have comma separated values...
^{“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

May 28, 2014 at 4:06 am

#1716950
RE: Check multiple columns with one value

NULLIF - good catch.
The new query is much more compact and readable than the original, how does it compare in terms of performance?
^{“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

May 21, 2014 at 8:41 am

#1715393
RE: Check multiple columns with one value

UPDATE h SET
Phone1 = CASE WHEN d1.Phone IS NOT NULL THEN NULL ELSE Phone1 END,
Phone2 = CASE WHEN d2.Phone IS NOT NULL THEN NULL ELSE Phone2 END,
Phone3 = CASE...
^{“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

May 21, 2014 at 7:15 am

#1715336
RE: Ugly Index Spool

-- Read (and aggregate) table variable @Result only once.
-- Note that a row will match more than one filter.
-- Note use of NULL in case expression for averages -
--...
^{“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

May 21, 2014 at 3:10 am

#1715252
RE: Ugly Index Spool

sql-lover (5/20/2014)
ChrisM@home (5/20/2014)
On phone so long shot - try LEFT REMOTE JOIN ticket.
Got this error:
Msg 1072, Level 15, State 1, Line 22
A REMOTE hint can only be specified with an...
^{“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

May 21, 2014 at 1:54 am

#1715237
RE: urgent_Backup_needed

vasugunda (5/20/2014)
Hello everyone
I am a new starter to sql and msbi
Are there anyone who can give me back up when Iam in job
its a bit urgent
and...
^{“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

May 20, 2014 at 8:59 am

#1714994
RE: Create a View where one column is selected from the Previous Row

aberndt (5/20/2014)
I'm not sure if that would pertain or not. What I am trying to do is pull information from a table (Operation) that contains multiple operations per Work...
^{“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

May 20, 2014 at 6:46 am

#1714901
RE: question about conut in sql

bbf.kurd (5/20/2014)
thanks GilaMonster, its correct
select COUNT(*) as [type], [group]
from tblname
where group in ('a','b')
Group by [group]
but haw use
where group in ('%a%','%b%')
i can use it
WHERE [group] LIKE '%a%' OR [group]...
^{“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

May 20, 2014 at 5:50 am

#1714875
RE: Drop Identity column from temp table

Instead of attempting to integrate this control/logging table into an already complex script, try this: write a query which joins the cloning table and the control table, outputting only 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

May 20, 2014 at 3:05 am

#1714827
RE: Find all rows WHERE DATETIME withing DATE

Rob Farley has an interesting article here which discusses SARGability of functions on search predicates. One of the functions which doesn't destroy SARGability is CAST(column AS DATE), so your 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

May 20, 2014 at 2:23 am

#1714820
RE: Ugly Index Spool

Why are you using subqueries in the output list instead of joins? You're reading the ticket table three times and the report table twice, instead of once each as 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

May 20, 2014 at 2:11 am

#1714817
RE: Mysterious performance issue when joining a view

Jake Shelton (5/19/2014)
Again, let me get this straight...
ChrisM@Work (5/19/2014)
Investigate all of the tables referenced in this query and list those tables which contain columns [chassis] and [model], making a note...
^{“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

May 19, 2014 at 6:47 am

#1714595
RE: Mysterious performance issue when joining a view

Investigate all of the tables referenced in this query and list those tables which contain columns [chassis] and [model], making a note of the datatype. You want to make 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

May 19, 2014 at 3:56 am

#1714551
RE: Mysterious performance issue when joining a view

Jake Shelton (5/19/2014)
Grant Fritchey (5/17/2014)
SQLRNNR (5/16/2014)
Grant Fritchey (5/16/2014)
To address the scan, you need to either have a filter of some kind to reduce the amount of data, or fix 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

May 19, 2014 at 2:58 am

#1714543

Viewing 15 posts - 3,316 through 3,330 (of 10,143 total)