Jeff Moden

Forum Replies Created

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

Reply To: Peaks and troughs from fluctuating prices

Steve Collins wrote:
Thanks ChatGPT for fixing the data.
interesting. What prompt did you use for that, Steve? I'm always curious.
--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 25, 2023 at 12:14 am

#4178886
Reply To: Summing a BIT column with a numeric as the outcome
While answer 3 may meet the overt requirements, it' returns the following "extra" info in the presence of NULL values, as well.
```
Warning: Null value is eliminated by...
```
--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 24, 2023 at 3:07 pm

#4178669
Reply To: Data Modeling Information

Steve Jones - SSC Editor wrote:
Sometimes having dates, or parts of dates, as integers work well. But not often. A dimension can make sense, but in most transactional tables, I think dates ought 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 22, 2023 at 12:44 am

#4177657
Reply To: Data Modeling Information

David.Poole wrote:
Calendar and Clock tables make life a lot easier when used as part of a Dimensional model. Especially if it is implemented in a column store.
If you've seen 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 22, 2023 at 12:43 am

#4177656
Reply To: partitioning a table

p.s. You should also post the CREATE TABLE code for the table, its keys, and the indexes so we can see if you have possibilities going on such as "Trapped...
--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:41 pm

#4176400
Reply To: partitioning a table

My first bit of advice on this is to move all but the last 13 months of data to an "Archive" database for the current database. Keep it 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)

April 19, 2023 at 5:24 pm

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

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