Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,531 through 1,545 (of 59,067 total)

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

Viewing 15 posts - 1,531 through 1,545 (of 59,067 total)