ChrisM@Work

Forum Replies Created

Viewing 15 posts - 721 through 735 (of 10,143 total)

RE: Are the posted questions getting worse?

Eirikur Eiriksson - Monday, May 29, 2017 2:21 PM
GilaMonster - Monday, May 29, 2017 1:18 PM
^{“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 30, 2017 at 1:57 am

#1944526
RE: UNION returns null values

acmedeepak - Friday, May 19, 2017 6:45 AM
The @StoreNumber actually is a set of column names in a table. To test 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 30, 2017 at 1:50 am

#1944525
RE: CTE and UNION performance issue

cmartel 20772 - Thursday, May 25, 2017 10:11 AM
Chris,
Dates are not consecutive. This script transform transactional data into a register. Initial data is contained 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

May 26, 2017 at 1:56 am

#1944297
RE: CTE and UNION performance issue

cmartel 20772 - Wednesday, May 24, 2017 1:09 PM
I am optimizing an inline table-valued function that performs calculations by heavily using OVER,...
^{“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 25, 2017 at 9:50 am

#1944204
RE: Unable to dynamically delete current cursor record using WHERE CURRENT OF

reachprth - Thursday, May 25, 2017 5:03 AM
ChrisM@Work - Thursday, May 25, 2017 4:47 AM
^{“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 25, 2017 at 5:27 am

#1944135
RE: Unable to dynamically delete current cursor record using WHERE CURRENT OF

reachprth - Thursday, May 25, 2017 3:29 AM
Hi,
I am trying to write a script that will delete data from a given table...
^{“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 25, 2017 at 4:47 am

#1944131
RE: Are the posted questions getting worse?

Neil Burton - Thursday, May 25, 2017 2:11 AM
ChrisM@Work - Thursday, May 25, 2017 1:47 AM
^{“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 25, 2017 at 2:21 am

#1944115
RE: Are the posted questions getting worse?

Neil Burton - Thursday, May 25, 2017 1:17 AM
I'm looking forward to getting the smoker out at weekend. As I said, 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

May 25, 2017 at 1:47 am

#1944108
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Tuesday, May 23, 2017 9:00 AM
Neil Burton - Tuesday, May 23, 2017 7:16 AM
^{“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 24, 2017 at 1:57 am

#1943930
RE: Are the posted questions getting worse?

Neil Burton - Tuesday, May 23, 2017 7:10 AM
rodjkidd - Tuesday, May 23, 2017 6:57 AM
^{“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 23, 2017 at 8:06 am

#1943794
RE: Dynamic Statement with Cursor loop, help

DROP TABLE #mycompanytable2;
CREATE TABLE #mycompanytable2 (
CompanyName NVARCHAR(50) NOT NULL
,ItemName NVARCHAR(50) NOT NULL
,[Percent] NUMERIC(7,5) NOT NULL
);
INSERT INTO #mycompanytable2(CompanyName, ItemName, [Percent])
^{“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 23, 2017 at 5:44 am

#1943745
RE: Different Query Plan for same query

free_mascot - Tuesday, May 23, 2017 3:31 AM
Thank you Kevin and all.
Posting my experience so that it help to others too.
Finally 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

May 23, 2017 at 5:24 am

#1943740
RE: Join two tables using several criterias

This should get you started:
IF 0 = 1 BEGIN
DROP TABLE #tb1
CREATE TABLE #tb1 (ID INT IDENTITY(1,1), [date] DATE , ref INT, amount INT, T2ID...
^{“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 22, 2017 at 5:21 am

#1943520
RE: How to include or create NULL values to a query

In addition to Thom's points:

Your query...
^{“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 22, 2017 at 4:49 am

#1943515
RE: Rewriting Stored Procedure to be easier on the eye

SELECT *
FROM ##Activity_Tracking
WHERE (
Referral_C IS NULL OR
    Note_Ordered_C IS NULL OR
    Breach_Ordered_C IS NULL OR
    Breach_Recvd_C IS NULL OR   ...
^{“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, 2017 at 9:33 am

#1943343

Viewing 15 posts - 721 through 735 (of 10,143 total)