ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 10,143 total)

RE: selecting top rows by counting a variable total

louise 28346 (8/18/2016)
thanks Chris
Its this part
SELECT 123, 1 UNION ALL
SELECT 456, 2 UNION ALL
SELECT 789, 1 UNION ALL
SELECT 789, 2 UNION ALL
SELECT 789, 3
Ive an issue with because my data...
^{“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

August 18, 2016 at 7:40 am

#1896151
RE: Are the posted questions getting worse?

Brandie Tarvin (8/18/2016)
ThomasRushton (8/18/2016)
Wow. For the first time in *mumble* years as a SQL guy, I've been asked "how do I get the date in SQL Server"
erm... SELECT...
^{“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

August 18, 2016 at 7:30 am

#1896148
RE: Compute worked minutes group by hour

-- sample data setup
DROP TABLE #MyTable
SELECT
POS,
Employee_ID,
[Name],
[Date] = CAST([Date] AS DATE),
WkTimeStart = CAST(WkTimeStart AS TIME),
WkTimeEnd = CAST(WkTimeEnd AS TIME)
INTO #MyTable
FROM (
SELECT 18, 96, 'John', '01/07/2016',...
^{“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

August 18, 2016 at 7:21 am

#1896146
RE: selecting top rows by counting a variable total

-- set up some data to code against
DROP TABLE #MyTable
SELECT *
INTO #MyTable
FROM (
SELECT 123, 1 UNION ALL
SELECT 456, 2 UNION ALL
SELECT 789, 1 UNION ALL
SELECT 789, 2 UNION ALL
SELECT 789,...
^{“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

August 18, 2016 at 6:39 am

#1896133
RE: Execution Plan Question

Grant Fritchey (8/18/2016)
ChrisM@Work (8/18/2016)
Brandie Tarvin (8/18/2016)
Brandie Tarvin (8/18/2016)
Ed Wagner (8/17/2016)
I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - 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

August 18, 2016 at 5:38 am

#1896118
RE: Execution Plan Question

Brandie Tarvin (8/18/2016)
Brandie Tarvin (8/18/2016)
Ed Wagner (8/17/2016)
I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the JOIN...
^{“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

August 18, 2016 at 5:28 am

#1896113
RE: How to generate sequence number based two columns

SELECT
sNo = DENSE_RANK() OVER(ORDER BY [name] DESC, cycleno),
cycleno, [name]
FROM #tmp1
ORDER BY [name] DESC, cycleno
^{“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

August 18, 2016 at 3:55 am

#1896096
RE: Still Confused about the difference between varchar(max) and varchar(8000)

joshua 15769 (8/17/2016)
My primary keys are int sirs, But my database columns are all varchar(MAX)
I would like to thank you both for the great answers, i'm thinking, could I mark...
^{“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

August 18, 2016 at 1:45 am

#1896082
RE: Are the posted questions getting worse?

tindog (8/17/2016)
ChrisM@Work (8/17/2016)
tindog (8/17/2016)
ChrisM@Work (8/17/2016)
Luis Cazares (8/17/2016)
Brandie Tarvin (8/17/2016)
Eirikur Eiriksson (8/17/2016)
BrainDonor (8/17/2016)
ChrisM@Work (8/17/2016)
We have git hubs all over the UK. They're also known as Weatherspoons.
You owe me a new keyboard...
😀
...just...
^{“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

August 17, 2016 at 8:08 am

#1895924
RE: Are the posted questions getting worse?

tindog (8/17/2016)
ChrisM@Work (8/17/2016)
Luis Cazares (8/17/2016)
Brandie Tarvin (8/17/2016)
Eirikur Eiriksson (8/17/2016)
BrainDonor (8/17/2016)
ChrisM@Work (8/17/2016)
We have git hubs all over the UK. They're also known as Weatherspoons.
You owe me a new keyboard...
😀
...just managed to...
^{“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

August 17, 2016 at 7:30 am

#1895912
RE: Execution Plan Question

It sounds like one or more of the join columns are missing from whatever index is chosen, which would go some way to explaining the poor row count estimate 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

August 17, 2016 at 7:24 am

#1895909
RE: Are the posted questions getting worse?

Luis Cazares (8/17/2016)
Brandie Tarvin (8/17/2016)
Eirikur Eiriksson (8/17/2016)
BrainDonor (8/17/2016)
ChrisM@Work (8/17/2016)
We have git hubs all over the UK. They're also known as Weatherspoons.
You owe me a new keyboard...
😀
...just managed to save mine
😎
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

August 17, 2016 at 6:52 am

#1895900
RE: Query subtree costs justify parallelism, but it doesn't

Indianrock (8/17/2016)
Almost all of our application code is ORM-generated, originally in C# code. ( entity framework type stuff )
Are you saying the table/column aliases etc actually have a bearing on...
^{“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

August 17, 2016 at 6:07 am

#1895885
RE: Index Usage

There is a use case for having an ordinary index with the same leading edge column as the clustered index. If your table is very wide (meaning less rows per...
^{“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

August 17, 2016 at 5:38 am

#1895876
RE: String or binary would be truncated error.

Anandkumar-SQL_Developer (8/17/2016)
Dear ChrisM@Work / twin.devil ,
...
^{“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

August 17, 2016 at 3:43 am

#1895871

Viewing 15 posts - 1,261 through 1,275 (of 10,143 total)