ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 10,143 total)

RE: Are the posted questions getting worse?

Y.B. (11/15/2016)
Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)
That being said I did recently try an Irish Cheddar which was excellent. I like...
^{“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

November 16, 2016 at 7:56 am

#1912800
RE: Help with a query runs forever but returns nothing.

Luis Cazares (11/14/2016)
Eirikur Eiriksson (11/14/2016)
Can you post the actual execution plan, would make this a lot easier.
😎
If the plan contains sensitive data then you can use SQL Sentry Plan Explorer...
^{“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

November 15, 2016 at 9:11 am

#1912575
RE: Help with a query runs forever but returns nothing.

A few pointers in here too:
DECLARE @MergedRecord INT = 0
IF EXISTS ( -- this subquery isn't correlated - it returns a CONSTANT
SELECT 1
FROM ETLCorrelation
WHERE DestinationTable = 'ConfigOptionTypeProperty'
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

November 14, 2016 at 11:05 am

#1912323
RE: Are the posted questions getting worse?

GilaMonster (11/7/2016)
Got my blog working again, finally. Hosting provider can't figure out how the files got wiped, restored a 3 month old backup, got my name incorrect in their last...
^{“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

November 8, 2016 at 2:21 am

#1911129
RE: Execution Plan help. Estimates off by alot !

What's already been said, but also:
Try forcing a join or two. You know that the join introducing Patientvisitprocs should be a hash join because of the volumes, and PatientVisit should...
^{“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

November 7, 2016 at 9:52 am

#1910961
RE: Indexes on Views - with UNION

Minnu (11/4/2016)
Hi,
Want to combine two select queries in to one by excluding UNION.
Indexed views - typically these are used as a performance-enhancing trick. Are you experiencing performance issues with these...
^{“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

November 4, 2016 at 9:30 am

#1910636
RE: Get records which satisfy particular condition and exclude others

sindhupavani123 (11/4/2016)
Thank you all for the help.
What should i do if i want two columns with below output?
Client fields value ...
^{“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

November 4, 2016 at 9:23 am

#1910633
RE: Get records which satisfy particular condition and exclude others

This also matches the somewhat ambiguous and vague requirements:
;WITH SAMPLE_DATA(Client,fields,value) AS
( SELECT X.Client,X.fields,X.value
FROM ( VALUES
(111,'Decision','accept')
...
^{“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

November 4, 2016 at 6:34 am

#1910567
RE: Get records which satisfy particular condition and exclude others

sindhupavani123 (11/4/2016)
I have the following data with client account decision and status
Clientfields value
111Decisionaccept
111Statusdeposited
112decisionaccept
113Decisionaccept
114Decisionaccept
114Statuscontract
115DecisionConditional Accept
115Statusdeposited
116DecisionConditional Accept
117DecisionConditional Accept
118Statuscontract
118DecisionConditional Accept
I would like to get
records...
^{“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

November 4, 2016 at 5:58 am

#1910563
RE: Performance of system tables when loading views and procedures.

keith.gilbert-1064677 (10/6/2016)
The product I work on has a set of objects per business entity, Some customers have 200+ business entities. When a customer moves from one version of our...
^{“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

November 4, 2016 at 5:06 am

#1910553
RE: Dynamic pivot and its effect on the plan cache

From Glenn Berry's diagnostic queries series:
-- Find single-use, ad-hoc and prepared queries that are bloating the plan cache (Query 44) (Ad hoc Queries)
SELECT TOP(50) [text] AS [QueryText], cp.cacheobjtype, cp.objtype,...
^{“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

November 4, 2016 at 4:17 am

#1910540
RE: SQL Query

Or this perhaps? The requirement is rather vague.
DECLARE @Sample TABLE (GroupCode char(1), BinNumber int, ValueCode varchar(20), DetailCode varchar(20))
INSERT INTO @Sample (GroupCode, BinNumber, ValueCode, DetailCode) VALUES
('A',1,'ValueA','Details1'), ('A',2,'ValueA','Details2'),
('B',1,'ValueB','Details1'), ('B',2,'ValueB','Details2'), ('B',3,'ValueB','Details3'),
('C',1,'ValueC','Details1'), ('C',2,'ValueC','Details2'),...
^{“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

November 4, 2016 at 4:08 am

#1910539
RE: Indexes on Views - with UNION

Minnu (11/4/2016)
Hi Team,
Want to create a view using below query, and also want to apply indexes on that view.
SELECT NT.ID, U.acc_name
FROM dbo.NR_VT NT WITH (NOLOCK),
...
^{“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

November 4, 2016 at 2:48 am

#1910530
RE: Speeding Up Delete's on Large Databases

Jeff Moden (11/1/2016)
ChrisM@Work (11/1/2016)
So we decided to try cache priming - getting the required data into cache with a low-cost read before processing it. A single loop of the code...
^{“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

November 1, 2016 at 9:10 am

#1909902
RE: Speeding Up Delete's on Large Databases

Lynn Pettis (11/1/2016)
ChrisM@Work (11/1/2016)
Jeff, the method Eirikur's describing works really well. We implemented such a method here for cleaning up a substantial table earlier in the year. The existing method...
^{“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

November 1, 2016 at 7:59 am

#1909869

Viewing 15 posts - 1,096 through 1,110 (of 10,143 total)