ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 10,143 total)

RE: t-sql 2012 link 3 tables

wendy elizabeth (10/6/2016)
This is only a one time update. I am sorry I did not mention that earlier. I basically just need to place existing data into the 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

October 6, 2016 at 8:03 am

#1905170
RE: conditional where clause

GilaMonster (10/6/2016)
Eirikur Eiriksson (10/6/2016)
Using a conditional IF statement is by far the simplest way of doing this.
And is prone to the performance-related problems that Chris alluded to.
https://www.simple-talk.com/content/article.aspx?article=2280
We must be talking...
^{“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

October 6, 2016 at 7:57 am

#1905166
RE: Can I remove these RAISERROR 44444?

justinricardo016 (10/6/2016)
This is the site that anyone who is interested in learning more about SQL server 2005 should care enough to visit. I admire the way that members of this...
^{“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

October 6, 2016 at 5:51 am

#1905137
RE: conditional where clause

marc.corbeel (10/6/2016)
Yes but here you include the complete select command in the condition.
Problem is here that my real query is very complex (about 40 lines), and putting it 2 times...
^{“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

October 6, 2016 at 4:47 am

#1905124
RE: Need help to write stored procedure with this scenario

pushkarna.anuj (10/5/2016)
Hello,
Let's say we have two tables A and B. Both tables have From Dates .i.e. A.FromDate and B.FromDate and both can be joined on MemberID. I need to pull...
^{“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

October 6, 2016 at 4:41 am

#1905121
RE: t-sql 2012 link 3 tables

"However I want the lockID value in the locker table to be the same value in the Lock
and the LockCombination tables. Basically I will create rows in the locker...
^{“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

October 6, 2016 at 2:06 am

#1905097
RE: Are the posted questions getting worse?

drew.allen (10/5/2016)
With my first article for SSC accepted for publishing, I've already written a second (unrelated) article. I'd like to have a couple of people review it.
This article is...
^{“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

October 6, 2016 at 1:42 am

#1905092
RE: NEED help please. Join query to a FK. The FK table join is on nullable field

-- Collect the 12 values of ST.PerformanceConfigChoiceID
-- for the rows where FK1.DestinationID is NULL.
-- Probe the ETLCorrelation table for those rows:
SELECT FK1.SourceTable, FK1.BatchID, FK1.SourceID
FROM [ETL].[dbo].[ETLCorrelation] FK1
WHERE FK1.SourceID IN...
^{“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

October 5, 2016 at 7:09 am

#1904892
RE: Deadlock error MERGE

javirsantos (10/5/2016)
The XML file I have gotten into a @xml and #XML and the deadlock is still playing.
The next step would be to post an execution plan here, as a...
^{“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

October 5, 2016 at 4:49 am

#1904844
RE: Assign result of dynamic sql to variable

sanjaydut26 (10/2/2016)
Here is the function...
ALTER FUNCTION [dbo].[ufn_GetHcmDesignFields]
(
@ModuleId bigint, -- HCM_DESIGN_FIELDS moduleid with IsExtendable status 1
@RID bigInt -- table rid
)
RETURNS nvarchar(max)
AS
BEGIN
DECLARE @Return...
^{“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

October 4, 2016 at 8:44 am

#1904677
RE: High lob logical reads on a query with just 2 simple tables

I'm sorry, I don't know the answer to your question - however, Googling revealed this interesting teaser written by Paul White. You may well find pointers (pun intended) to your...
^{“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

October 4, 2016 at 8:16 am

#1904669
RE: Maximum number of CROSS APPLY functions

Jeff Moden (10/3/2016)
The Dixie Flatline (10/3/2016)
While we're on the subject, does anyone know of a reason there could be a performance hit from doing all these cross applies? ...
^{“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

October 4, 2016 at 5:55 am

#1904643
RE: Incorrect syntax

nazirulfitrifauzi (10/4/2016)
SELECT 'KESELURUHAN' AS STATE,
'KESELURUHAN' AS BRANCH,
dbo.uf_get_koddana(h.funding_scheme) AS Dana,
Count(*) AS cnt_all,
Sum(h.approved_limit) AS sum_all,
Sum(isnull(w.wo_amt,0)) AS sum_wo,
Sum(isnull(RECOVERED_AMOUNT,0)) AS sum_wb,
Sum(case when bulantgkbil >= 7 and h.account_status not in (1,9,15) then 1 else 0...
^{“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

October 4, 2016 at 2:14 am

#1904604
RE: One to Many relations

moranamon (9/30/2016)
Yes, but what about other entities?
you can't store FKs from difference entities in the same column in Photos, that's the reason why i created the link table from 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

October 3, 2016 at 3:24 am

#1904352
RE: Are the posted questions getting worse?

BLOB_EATER (10/3/2016)
ChrisM@Work (10/3/2016)
BLOB_EATER (9/30/2016)
Thanks to those that have given me advice! this is a great forum.
So you and Mrs Blobby are talking to each other again? 😀
HAHA. that is actually...
^{“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

October 3, 2016 at 2:02 am

#1904336

Viewing 15 posts - 1,156 through 1,170 (of 10,143 total)