Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,511 through 6,525 (of 59,091 total)

Reply To: how to get Pivot result set using 3 tables

So print out the dynamic SQL and post it. It's likely going to be in line 9 of the Dynamic SQL.
--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)

September 2, 2020 at 6:18 am

#3785453
Reply To: Using Recommendations for MAXDOP and Max Memory During Installation

p.s. I don't know who left you a rating of "1" but it wasn't me. I generally don't rate articles and I certainly wouldn't rate one so low without an...
--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)

September 2, 2020 at 6:13 am

#3785448
Reply To: Using Recommendations for MAXDOP and Max Memory During Installation

I'm not sure where the 70-30 recommendation actually came from but I have do disagree with it on large systems. I can't believe it's not a total waste to give...
--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)

September 2, 2020 at 6:06 am

#3785443
Reply To: Using NOLOCK in UPDATE or DELETE

At this point, it's almost a dead issue but I have to agree with Scott. If you want to say that using WITH (NOLOCK) or setting the transaction isolation level...
--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)

September 2, 2020 at 5:47 am

#3785440
Reply To: Using NOLOCK in UPDATE or DELETE

pdanes wrote:
Grant Fritchey wrote:
... we get companies that require NOLOCK in every query (and yeah, run across this one many times now).
Seriously? An official, company-wide mandate to DB coders to use this?...
--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)

September 2, 2020 at 5:41 am

#3785437
Reply To: Using NOLOCK in UPDATE or DELETE

khushbu wrote:
Any reference link I can refer too and make my point?
Frederico provided one in his post... the very first post after your question.
--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)

September 2, 2020 at 5:34 am

#3785435
Reply To: how to get Pivot result set using 3 tables

gaurav wrote:
Jeff Moden wrote:
How many rows do you have in the tbl_Projects table?
Sir, there are 51 rows.
Ok... so we definitely need Dynamic SQL, at least to build the query if you...
--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)

September 2, 2020 at 5:19 am

#3785431
Reply To: Database Modeling - Relationships

I agree. Very nice article and I share Scott's joy in seeing someone make a Bridge/Intersection/Cross Reference/M2M/Cartesian/Relational Multiplication table (heh.. those are just some of the names I've heard 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)

September 2, 2020 at 4:04 am

#3785424
Reply To: The Coping Thread

Aubrey Love wrote:
Jeff,
I just love that quote. "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
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)

September 2, 2020 at 3:38 am

#3785419
Reply To: how to get Pivot result set using 3 tables

gaurav wrote:
Erland Sommarskog wrote:
There are several reporting tools that support a dynamic pivot out of the box.
Sir, I just need it for presentation purposes only. Please suggest any tool...
--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)

September 2, 2020 at 3:31 am

#3785418
Reply To: How Many Sales for Each Year?

BWAAA-HAAAAA!!! All the answers are incorrect... the correct answer is "This is easy to do in T-SQL... why don't you stick with 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)

September 2, 2020 at 3:15 am

#3785415
Reply To: How to pivot two columns or do it another way.

Never mind...
Jeff Williams is using the result of your query... that makes the CROSSTAB (which does the pivot) a bit more complicated and, perhaps, a bit slower (maybe not... it's...
--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)

September 2, 2020 at 3:01 am

#3785412
Reply To: How to pivot two columns or do it another way.

Tech,
Is there a fixed maximum number of people that can work on a work order?

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

September 2, 2020 at 1:26 am

#3785401
Reply To: Query to return the number of logical reads
Are you looking for something like the following?
```
USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_ShowWorst]
/**********************************************************************************************************************
Purpose:  
This store procedure returns the "worst" performing queries in descending order...
```
--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)
September 2, 2020 at 12:13 am

#3785392
Reply To: query to calculated based on the value of previous month

Steve Jones - SSC Editor wrote:
So, I broke this down a bit, using a tally table to project to the future. I think all your dates after n= 5 will be the same, but...
--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)

September 1, 2020 at 9:07 pm

#3785355

Viewing 15 posts - 6,511 through 6,525 (of 59,091 total)