ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 10,143 total)

RE: Execution plan ignoring a Temp Table being used to filter the results

TheSQLGuru (9/12/2016)
ChrisM@Work (9/12/2016)
Phil Parkin (9/12/2016)
Don't explicitly drop the #temp table
Hi Chris. Can you explain a little how not dropping the temp table affects things, please?
From memory Phil, if you explicitly...
^{“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 15, 2016 at 2:02 am

#1901036
RE: Quert Required

vs.satheesh (9/14/2016)
Thank you for your reply. But my client using sqlserver2005.This Query not working in sqlserver2005.
Please post the helpful error message.
^{“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 15, 2016 at 1:45 am

#1901030
RE: 'New Query' Slow to Open new tab in SSMS 2016

No, and we're using exactly the same version as you. We're not using SQL Prompt.
^{“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 14, 2016 at 9:41 am

#1900887
RE: String Updation in a formula of a table -Query required

Jason A. Long (9/14/2016)
Looking at execution plans... Chris's script is far more efficient than mine... Use his script.
Just an FYI... Chris and I are using the same split function. We...
^{“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 14, 2016 at 9:01 am

#1900865
RE: create view with CTE SQL statement

SQL Galaxy (9/14/2016)
Yes. it is there..
I checked - select * from sys.sysservers,
servername and datasource as below name
targetserver,96361
There's a linked server with a nondefault port on the instance I'm...
^{“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 14, 2016 at 7:54 am

#1900829
RE: String Updation in a formula of a table -Query required

mytesting9 (9/14/2016)
KPI IDKPI NameKPIFormula
QW1 ABC
SA2 CRF...
^{“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 14, 2016 at 7:24 am

#1900813
RE: Are the posted questions getting worse?

Phil Parkin (9/14/2016)
ChrisM@Work (9/14/2016)
--
That's why I asked the feller the question
--
I think you meant 'fella', rather than 'lumberjack'. Then again ...
For the OP, there's this: "non-standard spelling of fellow, 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 14, 2016 at 6:56 am

#1900798
RE: String Updation in a formula of a table -Query required

Using the house string-splitter[/url]:
SELECT
t.[KPI ID],
t.[KPI Name],
KPIFormula = ISNULL(x.KPIFormula,'No Formula')
FROM #KPI t
CROSS APPLY (
SELECT KPIFormula = STUFF((
SELECT '+['+[KPI ID]+']'
FROM dbo.il_SplitDelimitedStringArray(KPIFormula, '+') d
LEFT JOIN #KPI ti ON '['+ti.[KPI 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 14, 2016 at 6:41 am

#1900783
RE: Are the posted questions getting worse?

jasona.work (9/14/2016)
GilaMonster (9/14/2016)
ChrisM@Work (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.
http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is 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

September 14, 2016 at 6:19 am

#1900774
RE: SQL anaylsis

Bharat21 (9/14/2016)
Top means mostly accessed tables or stored procedure by user and bottom means least accessed tables or stored procedure by user on SQL server ,...
^{“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 14, 2016 at 4:51 am

#1900762
RE: Are the posted questions getting worse?

Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.
http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not...
^{“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 14, 2016 at 4:18 am

#1900760
RE: Filling Buckets

ashishkumarrai (9/14/2016)
J Livingston SQL (9/13/2016)
ashishkumarrai (9/13/2016)
It seems this is not what I am after. I want the filler data to feed to bucket in recursive way and store each recursion....
^{“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 14, 2016 at 2:34 am

#1900740
RE: format query result

Eirikur Eiriksson (9/14/2016)
Quick suggestion
😎
BTW DON'T USE the FORMAT function!
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @LINE_TEMPLATE VARCHAR(50) = '000000000 ...
^{“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 14, 2016 at 1:58 am

#1900735
RE: format query result

WITH SampleData AS (SELECT * FROM (VALUES
('30', CAST('Mike' AS VARCHAR(30)),1600, 300),
('30', 'GIRISH',1250, 500),
('30', 'MARUTI',1250, 1400),
('30', 'MANOJ',1500, 0)
) d (Department, [Name], Salary, Commission))
SELECT
OutputString = RIGHT('000000000'+Department,10)
+ LEFT([Name]+SPACE(20),20)
+...
^{“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 14, 2016 at 1:56 am

#1900734
RE: delete millions of rows

Matt Miller (#4) (9/13/2016)
ChrisM@Work (9/13/2016)
Jeff Moden (9/13/2016)
ChrisM@Work (9/13/2016)
Cache priming can make a very significant difference to batch delete times.
Curious... isn't that just moving the problem to something else? ...
^{“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 13, 2016 at 10:15 am

#1900608

Viewing 15 posts - 1,186 through 1,200 (of 10,143 total)