ChrisM@Work

Forum Replies Created

Viewing 15 posts - 121 through 135 (of 10,143 total)

RE: nvarchar to smalldatetime

UCDA2019 - Thursday, March 7, 2019 4:03 AM
Having done more work on this the most effective way to update the records 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

March 7, 2019 at 4:48 am

#2023782
RE: How does the target table size impact the insert performance

Rocky's - Wednesday, March 6, 2019 5:22 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

March 7, 2019 at 3:44 am

#2023769
RE: HOW TO USE EXISTS FUNCTION WITH 3 TABLES

ipervez784 - Sunday, March 3, 2019 8:32 PM
Can you Please show me that how can we use EXISTS FUNCTION WITH 3 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

March 7, 2019 at 3:24 am

#2023767
RE: nvarchar to smalldatetime

UCDA2019 - Wednesday, March 6, 2019 8:54 AM
Having done some digging the Feb 29 2011 is an error and has been removed...
^{“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

March 6, 2019 at 8:58 am

#2023679
RE: nvarchar to smalldatetime

UCDA2019 - Wednesday, March 6, 2019 3:42 AM
Im currently working on updating company database in which on one of the tables 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

March 6, 2019 at 6:35 am

#2023651
RE: Save the actual execution plan of a SQL statement in a script

Today's SSC Featured Contents includes a section on capturing live execution plans using Extended Events.
^{“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

March 6, 2019 at 5:28 am

#2023647
RE: Query runs slow when executing under the context of a different DB

Feivel - Tuesday, March 5, 2019 2:21 PM
ScottPletcher - Tuesday, March 5, 2019 12:56 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

March 6, 2019 at 2:17 am

#2023632
RE: SELECT and UPDATE Data

Rechana Rajan - Sunday, March 3, 2019 11:43 PM
Hi All,
We have a table which have high data insert with a status flag...
^{“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

March 4, 2019 at 4:45 am

#2023415
RE: Expand multi-join with another table

You might wish to disambiguate your WHERE clause before pursuing this further:
WHERE
  t2.uitdnst_dt is null
  AND t5.OPDRGVR_NR <> '23929'
  AND t5.OPDRGVR_NR <> '23843'
  OR t2.uitdnst_dt...
^{“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

February 22, 2019 at 6:16 am

#2022646
RE: distinct in over partition

SELECT
t.*,
--q = COUNT(DISTINCT t.Colour) OVER(PARTITION BY [order]),
x.*
FROM #testing t
CROSS APPLY (SELECT n = COUNT(DISTINCT Colour)
FROM #testing ti WHERE ti.[order] =...
^{“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

February 19, 2019 at 8:21 am

#2022379
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, February 15, 2019 4:16 AM
I guess it is my turn.
I received a call this morning (2019-02-15) at approximately...
^{“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

February 15, 2019 at 4:33 am

#2022131
RE: Distinct is taking a lot of time and want to avoid that

skmoh2 - Wednesday, February 13, 2019 11:05 PM
Hi , I have a query which is taking a lot of time...
^{“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

February 14, 2019 at 5:01 am

#2022040
RE: dynamic sql query

Your code can be made much simpler by putting all those lookups into a table, like this:
SELECT *
INTO #BalanceFlowTypes
FROM (VALUES
('31', 'Disbursement Debit'),
^{“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

February 8, 2019 at 8:30 am

#2021507
RE: How do I convert a uk date in string format to date?

Lorna-331036 - Thursday, January 31, 2019 6:56 AM
Thanks guys - I already validate before passing the string. I also added SET DATEFORMAT...
^{“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

January 31, 2019 at 7:04 am

#2020695
RE: How do I convert a uk date in string format to date?

Lorna-331036 - Thursday, January 31, 2019 4:46 AM
Hi
A user enters a date in uk format (i.e '24/01/2019') into a web form (.net). ...
^{“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

January 31, 2019 at 6:31 am

#2020690

Viewing 15 posts - 121 through 135 (of 10,143 total)