Jeff Moden

Forum Replies Created

Viewing 15 posts - 226 through 240 (of 59,069 total)

Reply To: Are the posted questions getting worse?

Since MS messed up with performance starting in 2019 and hasn't made it any better in 2022, I sadly pronounce that I Don't Believe Anymore but I keep Doing 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)

January 1, 2025 at 2:24 am

#4508192
Reply To: need community help on 1 final cdata odbc driver product eval question

I'm confused. You're talking about Oracle but you're posting in an SQL Server 2019 forum.
Since I'm not privy to your previous attempts and have never used "CDATA", what is 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)

December 30, 2024 at 10:18 pm

#4507670
Reply To: How to Attach and Detach Databases in SQL Server

Michael L John wrote:
I would recommend updating statistics after you re-attach the database.
I've seen several people say that. I have to ask "Why"? The statistics are stored in the database just like...
--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)

December 30, 2024 at 10:00 pm

#4507667
Reply To: Why does SSMS always pop up this window every time I get into it?

Just curious, Rod. Did you ever figure this out?
--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)

December 30, 2024 at 9:53 pm

#4507666
Reply To: Database Archive missing FK

Between updates, just set the database to "Read Only". As an alternative, you can create individual File Groups with one or more Files in each and set those File Groups...
--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)

December 30, 2024 at 9:51 pm

#4507665
Reply To: printing complete path

I don't work with Powershell in most cases, which means I'm not very good with it. GOOGLE seems to work for this though.
Try this link.
https://sqlstudies.com/2022/07/07/powershellbasics-expanding-the-column-width-to-avoid-truncation/

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

December 27, 2024 at 4:58 am

#4505500
Reply To: Vendor claims unused table space impacts performance

The following supposedly applies only when your database is in the BULK_LOGGED or SIMPLE Recovery Models.
There is a feature known as "Fast Inserts". I wrote about that hot mess back...
--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)

December 26, 2024 at 10:45 am

#4505149
Reply To: The Reindeer Count

BWAA-HAA-HAA! This was more of a test of knowledge about Christmas songs than I thought it would be. 😀
--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)

December 26, 2024 at 9:43 am

#4505123
Reply To: Merry Christmas 2025

Merry Christmas, Steve, and thank you for the early present of seeing you at the Pittsburgh SQL Saturday. It was a real treat, my ol' friend.

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

December 26, 2024 at 2:47 am

#4504936
Reply To: Significant Digits

Thank you kindly for the feedback, windchaser... especially after nearly 20 years! I couldn't believe 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)

December 24, 2024 at 9:36 pm

#4504276
Reply To: 2 identical tables reads on Table1 PK is 53394 reads on table2 PK 2246847

You've answered you own question. The tables are, in fact, NOT identical. You different indexes, which can make the difference between a full table scan (or clustered index scan) and...
--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)

December 24, 2024 at 7:32 pm

#4504246
Reply To: Big Data or Small Data

I personally don't write code to do imports any more, but I sure used to.
I did pretty much the opposite as what others do. There were some exceptions, of course,...
--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)

December 20, 2024 at 9:56 pm

#4502600
Reply To: Big Data or Small Data

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
I find that a whole lot of people have some really serious problems with smaller data sets. I been told probably hundreds of times that "performance doesn't matter...
--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)

December 20, 2024 at 2:01 am

#4502148
Reply To: Restore Procedure not working
For starters, change this...
```
DECLARE @cmd NVARCHAR(MAX);
```
... to this ...
```
DECLARE @cmd NVARCHAR(4000);
```
Then see the following for why...
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-cmdshell-transact-sql#arguments
- This reply was modified 1 years, 6 months ago by Jeff Moden. Reason: Correct to suggestion. Op used NVARCHAR, not VARCHAR
--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)
December 20, 2024 at 1:40 am

#4502137
Reply To: Big Data or Small Data

I find that a whole lot of people have some really serious problems with smaller data sets. I been told probably hundreds of times that "performance doesn't matter because 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)

December 19, 2024 at 2:20 am

#4500469

Viewing 15 posts - 226 through 240 (of 59,069 total)