Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 59,067 total)

Reply To: No experience with programming; how difficult is SQL for new prospect?

As a bit of a sidebar, I've not yet found an online video course for beginners that I actually like or think that does the job adequately. 🙁
--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)

January 20, 2023 at 7:32 pm

#4140153
Reply To: No experience with programming; how difficult is SQL for new prospect?
julunyeti wrote:
1. Microsoft's new journey and phase is causing many well developed areas of skills to be discarded. By the time we hit SQL Server 2016 the exams were robust...
--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)
January 20, 2023 at 7:21 pm

#4140143
Reply To: Read data based on date-range in huge table is slow

oRBIT wrote:
If "Time" were the first in order in the index, that would be much better?
Maybe for your query but might crush everyone else's performance.
Looking at the graphic that 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)

January 20, 2023 at 7:15 pm

#4140142
Reply To: Conventions when writing queries/stored procedures

First of all, there have been religious wars over code formatting. Even the original post contains a possible declaration of such a war where the OP works.
I'm NOT trying 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)

January 20, 2023 at 7:07 pm

#4140141
Reply To: SQL 2019 Standard - DB role, how to find create date and who created it.

If you know the date the principal was created AND you have a log file that spans that date, you can find it in the log file. I don't have...
--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)

January 20, 2023 at 1:27 am

#4139792
Reply To: Join aggregated queries via a date formatted YYYY-MM

saintor1 wrote:
Suggestions from kaj and Jonathan AC Roberts (both) work! Thanks to for spending a few minutes to solve this. I didn't know about the EOMONTH() function.
If your dates have...
--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)

January 20, 2023 at 12:50 am

#4139791
Reply To: How to turning 1 Row into 2 Rows following best practices?
Instead of making 2 passes through the table, use a CROSS APPLY to do the "unpivot". There IS an UNPIVOT operator but I don't care for 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)
January 20, 2023 at 12:38 am

#4139790
Reply To: Split string using multiple delimiters - version 2

ChrisM@Work wrote:
Iwas Bornready (9/15/2016)
ChrisM@Work (9/15/2016)
Interesting. It does a lot of work for the result. Have you speed-tested it against the house splitter? Here's one I knocked up in a couple...
--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)

January 20, 2023 at 12:25 am

#4139787
Reply To: What does date show?

To continue the math behind all of this and what the verbal description of what the code actually does, run the following code and let me know what number 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)

January 19, 2023 at 11:45 pm

#4139778
Reply To: What does date show?

Remember what I said about the DW datepart and DATEFIRST? What happens to the output when you change DATEFIRST and how does it relate to DATEFIRST insofar as the first...
--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)

January 19, 2023 at 11:42 pm

#4139777
Reply To: What does date show?

Don't apologize for the question. You got a good part of it right. Just not the "fine point". Very specifically, which part of last week does it ALWAYS show?
--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)

January 19, 2023 at 11:40 pm

#4139775
Reply To: What does date show?

Gosh, Jeremy. Put a SELECT on it, run it, and see. If you can't guess that, then break out pieces and see what it comes up with for values. If...
--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)

January 19, 2023 at 11:10 pm

#4139772
Reply To: No experience with programming; how difficult is SQL for new prospect?

seanachim@hotmail.com wrote:
I would STRONGLY suggest attending the Querying SQL Course.
When I do a search for "Querying SQL Course", I get a ton of returns from different sites and none of...
--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)

January 19, 2023 at 10:11 pm

#4139758
Reply To: SQL on Hyperv

Jo wrote:
In reponse to Jo
I agree with Jeff, the applications seems to use a single connection sequentially.
So if i understand correctly, within the software, when they launch a query, 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)

January 19, 2023 at 9:54 pm

#4139753
Reply To: 10 years as Sql server dba but still fears of Interview and lack of Confidence

anoop.mig29 wrote:
Jeff Moden wrote:
anoop.mig29 wrote:
Hi jeff thanks for advice , i went by website you suggested geeks for geeks and i found it to more for programmers . .I didnt...
--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)

January 19, 2023 at 9:47 pm

#4139750

Viewing 15 posts - 2,071 through 2,085 (of 59,067 total)