Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 59,067 total)

Reply To: Are the posted questions getting worse?

I agree with Eirikur on all this... I believe that a whole lot of people resort to the likes of Python because they don't actually know how to use SQL...
--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)

May 18, 2023 at 3:23 am

#4191997
Reply To: In memory tables

I can't answer your question but my question would be, "Why"? What problem are you trying to solve with "In Memory" tables?
The reason I ask is because I've made 20...
--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)

May 18, 2023 at 3:11 am

#4191996
Reply To: How to capture sqlscript from a specific computer while using sqlserver profiler

When you setup the trace in SQLProfiler, be sure to include the TextData and HostName columns. Then, on the Events Selection tab, click on the column name and setup a...
--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)

May 18, 2023 at 2:54 am

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

Dennis Jensen wrote:
By the way has anyone else noticed that this discussion has gone way off topic??
It became a "water cooler" thread very early in its existence. 😉 Most of us...
--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)

May 18, 2023 at 2:37 am

#4191986
Reply To: How to Improve Database Design to Speed Up SQL Queries

To me, encrypting it is always in scope. I just got yet another hack-attack alert about 6 million peoples' data being stolen including SSNs. Seems like I get one every...
--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)

May 16, 2023 at 3:13 am

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

Dennis Jensen wrote:
Still if I am going to use code to process data manipulation with a need for speed I am going to use a compiled language (C, C++, Java, etc...)...
--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)

May 16, 2023 at 2:41 am

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

Phil Parkin wrote:
Jeff Moden wrote:
Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".
How about the rest of you good folks... did anyone else...
--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)

May 15, 2023 at 7:27 pm

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

below86 wrote:
Jeff Moden wrote:
Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".
How about the rest of you good folks... did anyone else...
--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)

May 15, 2023 at 7:17 pm

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

Jonathan AC Roberts wrote:
SQL would be my first choice for cleaning data, while it's a powerful tool for querying and cleaning data, it may not be the best choice for performing complex...
--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)

May 15, 2023 at 7:16 pm

#4190290
Reply To: Create League Standings use game data table with home and away on same line

wrote:
Hi there! It sounds like you want to create league standings based on game data and team data in different seasons. Here's what you can do:
First, you'll need 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)

May 14, 2023 at 10:37 pm

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

Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".
How about the rest of you good folks... did anyone else have a...
--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)

May 14, 2023 at 6:58 pm

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

Eirikur Eiriksson wrote:
Jeff Moden wrote:
why they thought SQL couldn't be used to do any of those things.
He he, first guess is that they don't know how to! 😎
Thanks, Eirikur. I appreciate...
--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)

May 14, 2023 at 3:48 pm

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

Shifting gears a bit...
I ran across an article that had the following statement in it...
"Learning SQL helps us to communicate with databases, but when it comes to cleaning, manipulating,...
--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)

May 14, 2023 at 3:05 pm

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

@Below86 ,
Looking at what you said, I can really sympathize. To be sure, my comments were based on people that were actually hired to work with T-SQL day in 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)

May 14, 2023 at 2:42 pm

#4189579
Reply To: Log File continue growing

deubel_m wrote:
The appropriate method to shrink a log file for a database in bulk/full recovery model is:
1. put the database in simple mode, full backup
2. shrink the log file,
3. put...
--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)

May 12, 2023 at 7:57 pm

#4188872

Viewing 15 posts - 1,441 through 1,455 (of 59,067 total)