Jeff Moden

Forum Replies Created

Viewing 15 posts - 646 through 660 (of 59,063 total)

Reply To: Question about Conceitual Database Model

dougsan wrote:
I am creating a database for an ecommerce...
Why? In the long run, it's going to be less expensive and less worrisome to buy one, which will also take into...
--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)

March 24, 2024 at 11:01 pm

#4401243
Reply To: How Can I set the right value according to comparison conditition

You have 15 rows that got expanded to 24 and you say you have 30 million original rows, which would be expanded to 48 million rows according the 24/15 ratio...
--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)

March 23, 2024 at 9:08 pm

#4400835
Reply To: Query performance analysis

as_1234 wrote:
All,
Thank you for your replies and suggestions. Sorry I haven't been back to this topic, I've had some other unplanned things to sort out. When I get back 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)

March 23, 2024 at 8:53 pm

#4400816
Reply To: Should I stop replication jobs while running SQL server maintenance jobs?

Step 1 would be to stop doing the re-indexing. Chances are that you're actually causing more damage than you're fixing especially if your using REORGANIZE or the old supposed 5/30...
--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)

March 23, 2024 at 8:46 pm

#4400815
Reply To: Cranky Curmudgeons

David.Poole wrote:
I read a wonderful book "A man called Ove" filmed as "A man called Otto" starring Tom Hanks. Read the book. Ove is the GOAT of cranky curmudgeons. 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)

March 23, 2024 at 8:32 pm

#4400814
Reply To: Cranky Curmudgeons

skeleton567 wrote:
Yes, I a cranky curmudgeon, and proud of it. I earned it the hard way.
I'm not as old as you are, Rick, but Roger that and ditto 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)

March 23, 2024 at 2:14 am

#4400465
Reply To: OLDEDB drivers

I also download at least the latest version of the "ACE" driver/providers so that I don't need to go anywhere near SSIS just to import a spreadsheet.
https://www.microsoft.com/en-us/download/details.aspx?id=54920&irgwc=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)

March 22, 2024 at 2:31 am

#4399842
Reply To: case for 'DBCC TRACEON - Trace Flags'

See the following for the list of supported Trace Flags.
https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
1118 (No longer required but I used to have it on server wide. I have the equivalent turned on in every...
--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)

March 22, 2024 at 2:10 am

#4399841
Reply To: unix timestamp to datetime

Why on Earth would you use PoSh to do this? You have the data in a table already.
https://www.sqlservercentral.com/articles/convert-unix-timestamps-to-date-times-in-sql-server-part1

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

March 22, 2024 at 1:46 am

#4399838
Reply To: Managed Vs Unmanaged Tables – Data Engineering with Fabric

John Miner wrote:
Hi Jeff,
At the bottom of the article is a zip file link.
I saw that and I kept asking myself where the heck the link was. I have the "nightlight...
--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)

March 21, 2024 at 11:06 pm

#4399778
Reply To: Cranky Curmudgeons

From the article:
Further, because we’re aging, we’re not ready to embrace all the wonderful new technologies that are clearly superior in every possible way.
I know I responded...
--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)

March 21, 2024 at 10:54 pm

#4399772
Reply To: Help with date range subquery

p.s. Read the article at the first link in my signature line below for how to post some readily consumable test data. It'll help you get a coded answer instead...
--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)

March 20, 2024 at 6:51 pm

#4399022
Reply To: Help with date range subquery

ThePhoenix wrote:
No, I won't be limiting the TicketOpenDate for the query. I may add a month filter to limit TicketOpenDate at a later time. The initial query will look at...
--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)

March 20, 2024 at 6:43 pm

#4399021
Reply To: Precuations of reducing the VLFs

vsamantha35 wrote:
Yeah, we do index rebuilds quite often but I am not 100% sure. but definitely that could be one of the reasons.
Jeff, I got your point. Could you please...
--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)

March 20, 2024 at 6:39 pm

#4399018
Reply To: Re-platforming
My two thoughts on things like this continue to be...
1. Change is inevitable. Change for the better is not.
2. If you want to learn something totally new, then try learning...
--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)
March 20, 2024 at 6:16 pm

#4399009

Viewing 15 posts - 646 through 660 (of 59,063 total)