Jeff Moden

Forum Replies Created

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

Reply To: Data Modeling Information

As a bit of a sidebar...
Even when GETDATE() was really the only show in town, I've never understood the propensity of people to make the terrible mistake of using DATE_IDs...
--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, 2023 at 5:12 pm

#4176386
Reply To: A Work Conference

PiperKerman wrote:
Regarding your concern about the potential for outsourcing to cheaper labor markets, I think it's a valid concern.
(ppts)
Please identify where in the article or this conversation where 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)

April 19, 2023 at 5:03 pm

#4176385
Reply To: Swapping values of variables

Great question and even better explanation, Thomas. Nicely done.
--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, 2023 at 3:33 pm

#4176356
Reply To: Code Correction

Thom A wrote:
I never had any exposure to SQL Server 2000, but my Google-Fu tells me you'll need to use DBCC SHOWCONTIG (see SQL SERVER – Comparison Index Fragmentation,...
--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 18, 2023 at 10:03 pm

#4175894
Reply To: ChatGPT implementation "reluctance"

Steve Collins wrote:
Fragmentation is my main area of interest and its my overriding concern. Of course, when I speak about fragmentation I'm really emphasizing it as my overarching concern.
Based on 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 17, 2023 at 7:11 pm

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

daytonbrown2 wrote:
Exactly Jeff. But you didn't read down far enough 🙂
The current environment I'm in is pushing to move to datalake/databricks, but I actually don't know what problem we are...
--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 17, 2023 at 7:04 pm

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

lan2022nguyen wrote:
thanks for suggestions @jeff Moden, @Jeffrey Williams. i'll take a look. am new to the whole DBA thing and learning as i go.
Thanks for the feedback and welcome 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 17, 2023 at 4:03 pm

#4175206
Reply To: Are senior SQL developer interview questions too difficult?

gulshan212 wrote:
One thing that I will say you that if your basic concepts are clear then it becomes very easy to crack any level interview.
I'll have to strongly disagree with...
--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 17, 2023 at 4:00 pm

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

PJ_SQL wrote:
I am in same machine
Ok... so what changed?
And, I'm not trying to be difficult here. It's just that these type of failures don't just suddenly appear after working for...
--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 11:39 pm

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

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