Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 59,098 total)

Reply To: Could you list db modeling tools you use on daily basis?

While I agree that a good logical design is essential and required before a physical design, I've found that the wrong people are frequently the wrong people to do so...
--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 16, 2020 at 7:15 pm

#3734829
Reply To: Backing Up Some Log

Sorry, Steve... there is no correct answer here.
--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 16, 2020 at 1:46 am

#3734578
Reply To: Combining many crossing intervals

Itzik Ben-Gan used 5 million rows (your "Source4") in his performance testing. What is the performance of your proposed Geometry method?
--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 16, 2020 at 1:36 am

#3734577
Reply To: Scalar function too slow - Calculated field in column based on another columns

~~You cannot use Table Valued Functions in computed columns in a table, though.~~
EDIT: Sorry... I've obviously confused this with some other post I was working on. The OP never mentioned...
--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 16, 2020 at 1:17 am

#3734572
Reply To: string of data into columns

GrassHopper wrote:
I have a txt file that has about 5 columns when i import it. 1 of the column imports the data incorrectly and puts 15 columns into 1. 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)

March 15, 2020 at 11:23 pm

#3734561
Reply To: Scalar function too slow - Calculated field in column based on another columns

Baldie47 wrote:
and what do you recommend to do? I was looking into using a cross apply, but I think it will be the same
The query isn't appropriate for a computed...
--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 15, 2020 at 11:13 pm

#3734559
Reply To: DBA activities

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 14, 2020 at 5:35 am

#3734386
Reply To: Find rows for a unique ID where value changes in any of the columns

pwalter83 wrote:
handkot wrote:
type sample data
Please find the DDL and sample data below.
the requirement is to display the product_ID for the row where the values have changed for the following 5...
--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 14, 2020 at 5:25 am

#3734382
Reply To: The Developer Arguments for Stored Procedures

MVDBA (Mike Vessey) wrote:
skeleton567 wrote:
Y.B. wrote:
Maybe the answer is much simpler...
Will it be the DBA or the Developer that gets woken up at 3:00am because the application is slow/not working? That person...
--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 14, 2020 at 3:02 am

#3734374
Reply To: Query Tuning Question

ScottPletcher wrote:
Jeff Moden wrote:
coolchaitu wrote:
Is query tuning the responsibilty of a Developer or is it a combined responsibility of DBA and SQL Developer.
jonathan.crawford wrote:
You simply do your best. If you 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)

March 14, 2020 at 2:34 am

#3734371
Reply To: sql r equivalent

I'm not an R enthusiast but if you could tell me what it does, I might be able to help.
Also, doesn't SQL Server now allow diversions to R in some...
--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 14, 2020 at 2:17 am

#3734368

Reply To: AS400 as Linked Server

Ken McKelvey wrote:

SELECT * FROM OPENQUERY([AS400], 'SELECT * FROM AS400.S78359E0.QS36F.INDETLWO')

I do not know much about AS400/DB2 but I think three part naming would be more likely to work with OPENQUERY

--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 14, 2020 at 2:15 am

#3734367

Reply To: Query Help - History Table with no range data.

I'm a bit confused by the first row of your posted desired result... Is the 4/1/2008 date for the SaleDate just a typo that should have been 1/1/2008 or am...

--Jeff Moden

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 14, 2020 at 2:09 am

#3734366

Reply To: Are the posted questions getting worse?

Brandie Tarvin wrote:

So an international academic writers conference (ICFA) that I usually am invited to as a fiction writer, and forgot to accept the invite last October, has been cancelled. I...

--Jeff Moden

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 14, 2020 at 12:11 am

#3734356

Reply To: Could you list db modeling tools you use on daily basis?

A lot of people don't even know about it and a lot of people that have been spoiled by other things don't care for it but SQL Server "Diagrams" can...

--Jeff Moden

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 14, 2020 at 12:09 am

#3734355

Viewing 15 posts - 7,561 through 7,575 (of 59,098 total)