Forum Replies Created
Viewing 15 posts - 1,606 through 1,620 (of 10,143 total)
-
RE: Are the posted questions getting worse?
Grumpy DBA (5/10/2016)
Low and slow (cooking in a smoker) is the way to go.Although it has "butt" in it's name it really is the shoulder.
It's probably from...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Are the posted questions getting worse?
Sean Lange (5/10/2016)
ChrisM@Work (5/10/2016)
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a couple...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Help with query excluding certain combo of rows
Try this:
WHERE
Code NOT IN ('GST','TAX', 'COMM')
AND NOT (Ty IN ('A','C') AND [Cr Ind] = 'C'))
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Are the posted questions getting worse?
BWFC (5/10/2016)
ChrisM@Work (5/10/2016)
BLOB_EATER (5/10/2016)
ChrisM@Work (5/10/2016)
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Are the posted questions getting worse?
BLOB_EATER (5/10/2016)
ChrisM@Work (5/10/2016)
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a couple gator...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Are the posted questions getting worse?
Sean Lange (5/9/2016)
So I brought back some yummy foods from New Orleans. I got some crawfish and pork sausage, some gator and pork sausage and a couple gator fillets. This...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: select from self without FROM-clause in WHERE?
Your observations arise from the necessity to support queries such as this:
SELECT
dk.hpnr,
dk.artnr,
dk.Vorhanden
FROM#d1 as dk
WHERE EXISTS (SELECT 1 FROM #d2 d2 WHERE d2.hpnr = dk.hpnr)
The...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Who's going to SQL Bits in Liverpool?
Mark Cowne (5/9/2016)
Really enjoyable few days, lots of excellent presentations, Itzik Ben-Gans was simply brilliant. Also got a chance to briefly meet Grant and Steve.I'd like to have bought you...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Who's going to SQL Bits in Liverpool?
Eirikur Eiriksson (5/7/2016)
Heading home after a great two days in Liverpool, very good to see you guys again, finally met Gianluca and Hugo, saw Chris, Grant, Steve, Erland, Itzik and...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: rewrite a query
Thanks.
There's plenty of scope for tuning here, few of the indexes are fully supportive.
You have a residual predicate
[SurveillanceDashboardRepository].[dbd].[fResult].[GeoLevel] as [a].[GeoLevel]=(2)
on a 27 million row table. An "actual" execution plan...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: rewrite a query
Hadrian (4/29/2016)
initial request was to replace views with indexes views with clustered index on it in order to improve performance. indeed I will check the index...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Are the posted questions getting worse?
Grant Fritchey (4/28/2016)
Technical question:I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Are the posted questions getting worse?
BLOB_EATER (4/28/2016)
SQLRNNR (4/27/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according...“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Who's going to SQL Bits in Liverpool?
Beatrix Kiddo (4/28/2016)
ChrisM@Work (4/28/2016)fear not, very few of them are attention-seeking party animals.
😀 Yeah, I think non-DBAs would definitely say that about us. I might see you at Inside ...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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 -
RE: Who's going to SQL Bits in Liverpool?
Beatrix Kiddo (4/28/2016)
tindog (4/27/2016)
I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know anyone! (Never been to Liverpool)I'll...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor 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
Viewing 15 posts - 1,606 through 1,620 (of 10,143 total)