Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,496 through 6,510 (of 59,072 total)

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
Reply To: SQL server index recommendations different from one environment to another

I've never used Brent's BlitzIndex but... you say that everything is the "same" on your boxes... is the data identical, as well? Probably not.
And I love Sergiy's "P.S.". Great example. ...
--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)

August 31, 2020 at 3:12 pm

#3784912
Reply To: Learning Isn’t Easy, But It’s Vital

While I agree that people need to learn new things (I'm in the process of learning a fair bit about AWS myself... and, unfortunately, am learning that it's not all...
--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)

August 31, 2020 at 3:02 pm

#3784910
Reply To: Data Compression Double Take

David.Poole wrote:
Compression to save disk space is of dubious value unless it saves IO.
With technologies such as Fusion-IO and SSDs where you are talking about literally thousands of times 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)

August 29, 2020 at 1:48 am

#3784559
Reply To: Update many records to a date next week based on a Numeric Day Value

sgmunson wrote:
Jeff Moden wrote:
sgmunson wrote:
Okay...
Dude! What's with all the SPAM in your signature line???
SPAM? Is it not okay to have links to business pursuits?
I'm thinking not... at least not non-SQL related...
--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)

August 29, 2020 at 1:33 am

#3784555
Reply To: Rebuild index on a 5TB database

coolchaitu wrote:
We have 5 TB database and the rebuild index job is taking days to complete. Is there a way to rebuild indexes on chunks of tables/indexes. For eg, rebuild...
--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)

August 29, 2020 at 1:30 am

#3784554
Reply To: Update many records to a date next week based on a Numeric Day Value

sgmunson wrote:
Okay...
Dude! What's with all the SPAM in your signature line???
--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)

August 28, 2020 at 5:45 pm

#3784484
Reply To: Delivering in a Day

It seems to me that if a company wants to really be effective (especially a software company), innovation shouldn't be limited to just 1 day or 1 week during working...
--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)

August 28, 2020 at 2:48 pm

#3784408
Reply To: How to read list of files in folder using T-SQL?

Tomys wrote:
Hi,
My command is : EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1
And I have one file in the directory, but the out is : (0 rows affected)
I am running this on SQL Server 2017...
--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)

August 27, 2020 at 6:46 pm

#3784213
Reply To: Rebuild index on a 5TB database

Brahmanand Shukla wrote:
What is your current Index Rebuild strategy and how frequently and in what % the fragmentation is happening?
To Sergiy's point, asking about the % of Fragmentation is the first...
--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)

August 27, 2020 at 6:17 pm

#3784202

Viewing 15 posts - 6,496 through 6,510 (of 59,072 total)