Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,001 through 6,015 (of 59,072 total)

Reply To: Get Particular Date from a Month

Sorry... had to take down this post because I found a bug in the formula.
--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 30, 2020 at 3:41 pm

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

Kathi Kellenberger wrote:
I think he came up with this from watching movies and TV shows. "Office Space" is one example of employees doing bad things to get back at the company.
Yowch......
--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 30, 2020 at 2:50 pm

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

Gordon Feeney wrote:
25 years in IT. Laid off: 2. Brought back at 20 times the old salary: 0.
20 Times the salary??? How much did that amount to?
--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 30, 2020 at 2:49 pm

#3815164
Reply To: Delivering Patches Quickly

I'm thinking "Ok... Catch 22". IMHO, the more quickly you move, the more likely you are to make a mistake and that's not limited to what most people consider to...
--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 30, 2020 at 1:48 am

#3814986
Reply To: The TUF File

Great question, Steve. I have to admit that I had to look this one up. Now I know what my next task will be... determine the ramifications of that file. ...
--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 30, 2020 at 1:19 am

#3814984
Reply To: Tempdb increasing crazily

The things you mention don't typically cause the crazy increase you speak of. And I just told you a "good way" to find it so someone can fix it. 😉 ...
--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 30, 2020 at 1:08 am

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

ScottPletcher wrote:
Frankly, you're still totally missing the point of q, thus your qs are misdirected. Performance does not matter here, since the company you're interviewing for is a commercial business,...
--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 30, 2020 at 12:58 am

#3814981
Reply To: Rebuild vs Reorganize

SQLWinther wrote:
I totally agree with you that a lot of half full pages is bad for disk storage, memory consumption and reading a lot of extra pages due to 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 29, 2020 at 10:39 pm

#3814956
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

Viewing 15 posts - 6,001 through 6,015 (of 59,072 total)