Jeff Moden

Forum Replies Created

Viewing 15 posts - 691 through 705 (of 59,063 total)

Reply To: find the number of values less than the current row

Interesting solutions, so far. Let's try one more...
First, let's simplify the code to make the readily consumable data. This is the best one of the better ways to post such...
--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)

March 11, 2024 at 3:54 am

#4393111
Reply To: query run time changes alot...why?
I'm thinking that the answer is somewhere in the Actual Execution Plans.
p.s. That's a major hint for what you might want to provide.
- This reply was modified 2 years, 2 months ago by Jeff Moden. Reason: Add p.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)
March 11, 2024 at 1:44 am

#4393073
Reply To: Assistants in the Age of AI

Robin Wilson wrote:
I was offered the help of a secretary once when I was getting around 350 emails per day so it was very hard to find the important emails mixed...
--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)

March 11, 2024 at 1:09 am

#4393054
Reply To: Will AI end with SQL, Is this the end of SQL?

The concept of AI in the picture near the end of the article is actually pretty grotesque, IMHO. Sex doll for both the body and the mind. Possibly the worst...
--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)

March 11, 2024 at 12:55 am

#4393053
Reply To: A Big SmallDateTime

Mark Dalley wrote:
Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes...
--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)

March 10, 2024 at 9:24 pm

#4393001
Reply To: A Big SmallDateTime

Michael L John wrote:
Mark Dalley wrote:
Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in 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)

March 10, 2024 at 9:21 pm

#4393000
Reply To: SQL server disk block size formatted as 4KB runs slow

ScottPletcher wrote:
The *data* file drives should be 64K. Log file drives should still be 4K. If you mix data and log files on the same drive, you'll want to use...
--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)

March 7, 2024 at 6:07 am

#4391071
Reply To: SQL Server Count Query

sathishkm wrote:
Hi All,
I have a data in column A in where in need to achieve the count which I have mentioned in column B. Please find the attached excel dataset...
--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)

March 7, 2024 at 6:00 am

#4391065
Reply To: how to filter out zeros when calculating average

water490 wrote:
thank you both! i know how to fix my query now because of your feedback. thank you again for the help!!
Cool. Can you show us what you settled on?
--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)

March 6, 2024 at 5:13 am

#4390370
Reply To: Assistants in the Age of AI

I'll take a smart "Pepper" (think Iron Man) over an AI all day long. And, no... not for looks... for smarts that I can trust instead of having serious doubts. ...
--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)

March 6, 2024 at 5:09 am

#4390369
Reply To: Creating Candidate Interest

I got my "best job ever" by answering the ultimate ad for someone that knows SQL...
"We need someone that can look at SQL, figure out what's wrong, and fix it".
That...
--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)

March 4, 2024 at 6:23 pm

#4389506
Reply To: DBCC CheckDB errors

Please see the following article for how to capture the results for all databases. What most people don't know is that most of the DBCC commands will allow for 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)

March 3, 2024 at 9:48 pm

#4388865
Reply To: performance issue, need to tune a query

kris6363 wrote:
can you please provide optimized t-sql query . Thanks in advance.
Like has already been stated, it's pretty much impossible to help with performance issues just by looking at code. ...
--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)

March 1, 2024 at 5:53 pm

#4387805
Reply To: I need to delete 180 million records from a table

Grant Fritchey wrote:
Whoof! 500 rows took 12 minutes? Honestly, that should be something that occurs in, at most, a few seconds.
Indexes may help (they can also add overhead to deletes 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)

March 1, 2024 at 5:49 pm

#4387804
Reply To: Importing Data

Chrissy321 wrote:
I believe that is the limitation of an Excel import. Try saving your file as a csv and then import as a flat file.
Just adding my 2 cents... That...
--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)

February 28, 2024 at 2:54 am

#4386038

Viewing 15 posts - 691 through 705 (of 59,063 total)