Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 59,067 total)

Reply To: Are the posted questions getting worse?

I love the knee-brace analogy.
I don't like the idea of an automatic code debugger. It would be misused in the same fashion. A lot of people are just too lazy...
--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 15, 2023 at 6:38 pm

#4174554
Reply To: auto refresh a query result (F5) in SSMS

lan2022nguyen wrote:
Jeff Moden wrote:
lan2022nguyen wrote:
instead of hitting F5 every 2-3 mins, can i automate this F5 to refresh the data within the same query result window?
I have to ask... why...
--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 15, 2023 at 5:16 pm

#4174535
Reply To: Fixed Width file

wrote:
jabujakan wrote:
Hi all,
I'm on my way to creating a new pipeline on our Azure stack that is supposed to read Excel sheets located at Google Drive partitions.
We're using Data...
--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 15, 2023 at 5:09 pm

#4174533
Reply To: For a "typical" datawarehouse, does it make sense to add databricks to the ETL

You said that the SSIS packages are all "very simple" and your followup after that seems like everything "works fine, fails safe, and drains to the bilge", to put 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)

April 14, 2023 at 7:25 pm

#4174174
Reply To: auto refresh a query result (F5) in SSMS

lan2022nguyen wrote:
instead of hitting F5 every 2-3 mins, can i automate this F5 to refresh the data within the same query result window?
I have to ask... why do you...
--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, 2023 at 7:04 pm

#4174168
Reply To: Fixed Width file

Nothing like a bit of PPTS. Can't help but watching.
--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, 2023 at 6:30 pm

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

Steve Collins wrote:
Here in New Jersey USA it's too nice of a day to sit behind a screen! Spring fever in full effect here 🙂 After my 2 o'clock meeting... adios
Heh......
--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 13, 2023 at 7:41 pm

#4173674
Reply To: what are the best books to become a DBA SQL?

seanachim@hotmail.com wrote:
I'm EXTREMELY uncomfortable with this approach because it is turning the SQL Professional into a clever user, not a thinker.
Ditto that and love your post. Thanks for taking 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 13, 2023 at 7:34 pm

#4173672
Reply To: How to get top 100 values of a col concatenated in a variable in sqlserver?

@rajemessage 14195 ,
Enquiring minds want to know... did the non-XML method work for you?😋

--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, 2023 at 11:11 pm

#4173200
Reply To: Can SSIS Check for Viruses?

Michael L John wrote:
Does anyone realize that if the docs are stored on the file system as opposed to a blob in a table, the need to scan them is then part...
--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, 2023 at 2:56 pm

#4172954
Reply To: Big Data Downsides

Heh... I remember my Grandmother telling me when I was quite young, "Figures can lie... and liars figure". She was so right even back in the late 50's when she...
--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, 2023 at 2:24 pm

#4172945
Reply To: How to get top 100 values of a col concatenated in a variable in sqlserver?

rajemessage 14195 wrote:
we do not want to use xml. so pls tell me with out it?
At least read the latest posts. 🙁 Kaj wrote a solution for you and I tweaked...
--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, 2023 at 2:15 pm

#4172938
Reply To: Waitfor Threads

You've just gotta love people that give a super low rating to an article or QoTD without leaving a reason. 🙁 I thought this was a great question because 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)

April 12, 2023 at 2:03 pm

#4172931
Reply To: The place of SMALLDATETIME

sean redmond wrote:
The rounding up of the last 30 seconds to the next hour is not a problem.
...
And as for space, if we have 100GB of data, then we 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)

April 12, 2023 at 1:34 pm

#4172915
Reply To: Copy DB from Prod to Test !!

Lidou123 wrote:
But users want to test with real data.
Then you really, really need to make sure that security is as air-tight as it is in production and management needs 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)

April 12, 2023 at 1:23 pm

#4172908

Viewing 15 posts - 1,546 through 1,560 (of 59,067 total)