Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,031 through 6,045 (of 59,089 total)

Reply To: Practice SQL querying with dates and aggregations

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
I provide the table structure, that's it. They are in SSMS session, so they can use whatever SSMS tools there are to view that structure.
Ah... therein lies...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 29, 2020 at 10:10 pm

#3814954
Reply To: Tempdb increasing crazily

Crazy increases in size are normally due to a query that has one or more "accidental Cross Joins" in the form of "Many-to-Many" results. They typically contain a DISTINCT or...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 29, 2020 at 9:45 pm

#3814951
Reply To: Practice SQL querying with dates and aggregations

ScottPletcher wrote:
I provide the table structure, that's it. They are in SSMS session, so they can use whatever SSMS tools there are to view that structure.

Ah... therein lies the key. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 29, 2020 at 9:22 pm

#3814939
Reply To: Practice SQL querying with dates and aggregations

Lord Slaagh wrote:
I have a major problem with ego-maniacs that like to hijack meetings. Which is what we had here. I asked for a few practice tests so I can prepare...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 29, 2020 at 9:18 pm

#3814938
Reply To: Practice SQL querying with dates and aggregations

Lord Slaagh wrote:
Jeff - I am going to create another thread on this issue. Could you please do me a favor and NOT participate? I would really appreciate it.
Your original reply...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 29, 2020 at 5:34 pm

#3814912
Reply To: Practice SQL querying with dates and aggregations

@Lord Slaagh ,
You asked "Jeff - Do you have any challenge queries that you can provide for practice?"
Yes I do. Anywhere from "pretty simple" to "OMG! How can this possibly...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 29, 2020 at 3:57 am

#3814815
Reply To: Practice SQL querying with dates and aggregations

jcelko212 32090 wrote:
But, by definition, an identifier is on a nominal scale and nominal scales are never numeric.
That's really a mistake on your part to think so in the world...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2020 at 11:20 pm

#3814780
Reply To: Practice SQL querying with dates and aggregations

Lord Slaagh wrote:
Scott - I agree with Jeff in the sense that this test is somewhat unrealistic because you have CTE's and sub queries at your disposal. However, if this is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2020 at 7:41 pm

#3814751
Reply To: Practice SQL querying with dates and aggregations

ScottPletcher wrote:
This is the main test q I use to test query-writing skill. It's not as trivial / obvious as it sounds at first.
A table contains 1, 2 or 3...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2020 at 4:12 pm

#3814720
Reply To: Practice SQL querying with dates and aggregations

Lord Slaagh wrote:
Acceptable data?
I would have to say "No"... not acceptable. The table that you've defined is different than the table that Scott very explicitly described not once but twice in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2020 at 4:09 pm

#3814719
Reply To: Bad career advice from a 14 year old

I guess my question would be is... where would a 14 year old hear of such things in such a repeatable fashion that he'd be able to repeat them as...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 28, 2020 at 3:49 pm

#3814718
Reply To: date Different
Jonathan AC Roberts wrote:
```
--DECLARE @CurrentDate as date='2020-11-25'
DECLARE @CurrentDate as date='2020-12-10'

;WITH Data (Id, WeekName, WeekDate) AS (
    SELECT 5, 'Gameweek 1', CONVERT(date,'2020-12-01')
    UNION
 ...
```
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
November 26, 2020 at 2:57 am

#3814068
Reply To: Are the posted questions getting worse?

Brandie Tarvin wrote:
Regarding the accidental DBA, has no one seriously running into the anti-virus scanning issue? The more he posts, the more I'm convinced one of his servers is scanning the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 26, 2020 at 2:32 am

#3814067
Reply To: Rebuild vs Reorganize

SQLWinther wrote:
Thank you for pointing this out to anyone! Optimizing queries and keep your statistics up to date is far more efficient for the performance. The impact of fragmentation is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 26, 2020 at 2:16 am

#3814065
Reply To: Backup time not reducing even after DB size went down 300 GB

Jeffrey Williams wrote:
Earlier in the thread he stated the database was taking 2 hours.
PJ_SQL wrote:
Database was 500Gb, 200 GB worth data deleted and then shrink files to reclaim space, backup was...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 26, 2020 at 1:55 am

#3814056

Viewing 15 posts - 6,031 through 6,045 (of 59,089 total)