Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,246 through 7,260 (of 59,072 total)

Reply To: How Much AI Do We Need?

To me, most machines/computers/whatever aren't "intelligent" nor are they able to "learn". At least, not yet. Don't get me wrong... there's some very, very clever programing being done out there...
--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 21, 2020 at 3:52 am

#3744864
Reply To: Get both Count and the data through single query to reduce time

John Mitchell-245523 wrote:
Jeff Moden wrote:
John Mitchell-245523 wrote:
Jeff Moden wrote:
John Mitchell-245523 wrote:
Have you tried getting the row count from the sys.partitions view?
John
In this case, I think that's a bad idea because that may not match 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)

April 20, 2020 at 7:09 pm

#3744775
Reply To: How Much AI Do We Need?

Doctor Who 2 wrote:
I hear you, Steve. There's no one-size-fits-all type of AI. Your analogy of cooking and baking is excellent. I'm a terrible cook, so if I were left on my...
--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 20, 2020 at 6:54 pm

#3744773
Reply To: Real columns are comma separated instead of dot separated ?

K. Thanks. I'll keep looking. This one has me stumped so far.

--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 20, 2020 at 6:40 pm

#3744766
Reply To: Get both Count and the data through single query to reduce time

binds wrote:
Yes. I got to know that Rowcount variable will not be updated until the complete control flow completes.
The sql table have millions of records.Is that the reason it is...
--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 20, 2020 at 6:38 pm

#3744765
Reply To: Stored Procedure that joins tables and accepts a parameter to filter the result

kaj wrote:
I don't know that we know that it's Social Security Numbers in clear text, do we? We only know that the name of the column is SSN, I think....
--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 20, 2020 at 5:04 pm

#3744736
Reply To: Get both Count and the data through single query to reduce time

John Mitchell-245523 wrote:
Jeff Moden wrote:
John Mitchell-245523 wrote:
Have you tried getting the row count from the sys.partitions view?
John
In this case, I think that's a bad idea because that may not match the actual number...
--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 20, 2020 at 4:10 pm

#3744708
Reply To: Get both Count and the data through single query to reduce time
John Mitchell-245523 wrote:
Have you tried getting the row count from the sys.partitions view?
John
In this case, I think that's a bad idea because that may not match the actual number of rows...
- This reply was modified 6 years, 2 months ago by Jeff Moden.
--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 20, 2020 at 3:47 pm

#3744695
Reply To: Stored Procedure that joins tables and accepts a parameter to filter the result

@DataRat and to all those helping him... please raise your hand if you wouldn't be upset if it was YOUR plain text SSN that was splattered across 35 tables even...
--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 20, 2020 at 3:44 pm

#3744693
Reply To: A Data Science Approach in Product Analytics

I think that one of the most important parts of all of this can be found in the conclusion section of the article. In particular, I'm talking about the following...
--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 20, 2020 at 3:26 pm

#3744679
Reply To: Real columns are comma separated instead of dot separated ?

gormus wrote:
Hi Jeff,
Language on Windows is also en-us. So can't be that either. Thanks for replying tho.
I'm not talking about the language on Windows... I'm talking about the language settings...
--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 20, 2020 at 3:08 pm

#3744677
Reply To: Temp table and table variable

I know it seems like a strange question because the answer may seem obvious but why are you doing this? If the answer is to do supposed "Best Practice" index...
--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 20, 2020 at 2:45 pm

#3744658
Reply To: How Much AI Do We Need?

skeleton567 wrote:
Depending on AI is like listening to the news. It is more opinion than fact. It is by its very nature biased by the beliefs and desires of those...
--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 20, 2020 at 2:09 pm

#3744647
Reply To: Monitor Database and Log Growth

René Oertel wrote:
I want to run this script on the server itself. I don't have a SQL Server for administrative purposes. Can I adapt this script for this purpose or is...
--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 20, 2020 at 2:05 pm

#3744645
Reply To: Sql Statement to display multiple true statement
bionicsamir wrote:
I have a sql statement that checks for certain special characters in a string and returns that.
SELECT
```
CASE

WHEN (LEN(DSC1) - CHARINDEX(char(1), DSC1)) <> LEN(DSC1) THEN '[DSC1 -...
```
--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 19, 2020 at 11:21 pm

#3744032

Viewing 15 posts - 7,246 through 7,260 (of 59,072 total)