Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,561 through 1,575 (of 59,082 total)

Reply To: Microsoft.ACE.OLEDB.12.0" for linked server - Error

PJ_SQL wrote:
Those configurations were set to 1 before as well, file is not open and it lets me make a copy of it and even with different name it gives...
--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 16, 2023 at 3:06 pm

#4174772
Reply To: Microsoft.ACE.OLEDB.12.0" for linked server - Error

PJ_SQL wrote:
Hello!
This suddenly stopped working and giving this error message below:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1...
--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 16, 2023 at 2:53 pm

#4174767
Reply To: Which version of SQL should I use?

ganatbasa wrote:
While a lot of us I doubt have much choice in what version we use for those that have used multiple version of SQL what version do you prefer...
--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 16, 2023 at 4:52 am

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

I'm humbled, Lynn. Thank you for the honorable mention. Coming from someone like you and with your knowledge, that's quite the compliment.
--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 16, 2023 at 4:47 am

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

lan2022nguyen wrote:
Jeff Moden wrote:
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...
--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 16, 2023 at 2:02 am

#4174628
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

Viewing 15 posts - 1,561 through 1,575 (of 59,082 total)