Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,481 through 9,495 (of 59,091 total)

Reply To: Good sources for SQL training?

The most important step is to have a learning/test/experimentation environment you have all to yourself. The following link contains a "download" button that will provide you with a free copy...
--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)

April 14, 2019 at 6:01 pm

#3336906
Reply To: A single query to display the result of multiple date selection in month columns

These report periods can overlap; a fiscal quarter will be contained in the range of its fiscal year. I like the MySQL convention of using double zeroes for months and...
--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)

April 14, 2019 at 4:37 pm

#3334453
Reply To: Difficulty deciding which job to take

The words that strike me here is ...
I have a good job, but have been offered one from a company i once worked for
The first step is to sit down...
--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)

April 14, 2019 at 4:28 pm

#3334320
Reply To: Why a query would pick unrelated index

S_Kumar_S wrote:
Hi I came across a scenario where a query is picking totally unrelated index in the execution plan. Here is the case: SELECT A.tranid,A.transittime FROM table1 A WITH(nolock) JOIN...
--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)

April 14, 2019 at 3:54 pm

#3333659
Reply To: Sorting Months By Number (SQL Spackle)

Thanks for the feedback folks.
To be honest, I should rewrite the whole, very old article. Using MONTH (which returns on 1-12 regardless of year) or anything else that doesn't observe...
--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)

April 14, 2019 at 3:31 pm

#3333151
Reply To: Today's Random Word!

Sorry to use 4 words all at once but Sunday, Pool, Beer, and Drambui!!! :D:D:D
--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)

April 12, 2019 at 11:20 pm

#3186946
Reply To: Is it a good practice to mix surrogate and natural keys?

elea.grig wrote:
Is it a good practice to mix some surrogate and natural keys...?
Heh... look at sys.objects for an answer to that question. Both the object_id and the name must be...
--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)

April 12, 2019 at 6:39 pm

#3166578
Reply To: Need Help!

ns550 wrote:
Hi, I'm very new to this program and have question...In which or what type of scenario I need to built Store Procedure with output parameters in real life job...
--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)

April 12, 2019 at 6:17 pm

#3166174
Reply To: Is it a good practice to mix surrogate and natural keys?

What I want to know is why people give supposed "design purists" so much credit.
--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)

April 12, 2019 at 6:12 pm

#3166109
Reply To: This why I drink..

I usually don't drink at all because, if I drank every time I ran into some form of stupidity when it comes to code or common sense, I'd be permanently...
--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)

April 12, 2019 at 6:08 pm

#3165970
Reply To: how to write this query accordingly

Grant Fritchey wrote:
Personally, I wouldn't do this through T-SQL. I'd use Powershell. Here's an example.

And then scream as the Network folks draw and quarter you for screwing up internal security.

Lordy,...
--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)

April 12, 2019 at 6:01 pm

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

Sean Lange wrote:
Grant Fritchey wrote:
The Dixie Flatline wrote:
And this thread just keeps on keeping on... This is a pure rant, so read at your own risk. I have been involved in the interview process...
--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)

April 10, 2019 at 11:49 pm

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

Greg Edwards-268690 wrote:
Some of this is the result of the times we are in. We all know the pressure of release and fix it later competing with if everything gets fixed...
--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)

April 10, 2019 at 10:45 pm

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

Sean Lange wrote:
below86 wrote:
When I came back to work Monday I was initially excited to see we were on the new version of SSC. My excitement quickly faded. I read Steve's...
--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)

April 10, 2019 at 4:29 pm

#3094104
Reply To: SELECT COUNT(*) Taking a Very Long Time

True dat! I have seen many time where it will choose a more narrow index to scan (much more quickly) even when it's the second column being used for criteria. ...
--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)

April 9, 2019 at 12:30 am

#3039608

Viewing 15 posts - 9,481 through 9,495 (of 59,091 total)