Jeff Moden

Forum Replies Created

Viewing 15 posts - 151 through 165 (of 59,099 total)

Reply To: Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions

While I do have an appreciation for anyone that steps up to share information, there are a couple of serious problems with the supposed "Practical Use Cases" in the article...
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)

March 19, 2025 at 4:31 pm

#4563074
Reply To: Search all databases on one server instance to find a specific view

JP789 wrote:
Humm... I couldn't get it to work. You gave: 'USE ? select DB_NAME(DB_ID(''?''))
But I don't know the database name. The server has many databases. I want to search 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)

March 17, 2025 at 4:10 am

#4561042
Reply To: Database restoration slowed down abnormally.

It could be anything. Did they switch domains that one of the machines was on? Did they add any new switches or routers or make any "settings changes". We had...
--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 17, 2025 at 4:06 am

#4561041
Reply To: Alternatiives to Junk Dimensions

Thanks for the links, Martin.
--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 13, 2025 at 7:46 pm

#4558970
Reply To: how do you explain the cardinal sin of warehousing to the chiefs?

I'm curious... what does the lowest level of management think of what you said. Has anyone even told them? And how about the next level or two above that? Have...
--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 13, 2025 at 1:45 am

#4558332
Reply To: Job requires X years of SQL... How do you respond?

Just to say it out loud... It's very likely that I'll never post anything on GitHub. However... a lot of companies insist that if you're not adding to GitHub on...
--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 12, 2025 at 9:33 pm

#4558218
Reply To: Alternatiives to Junk Dimensions

Never mind about me thinking they were talking about "Jump" tables. I'm not a DW kind of person.
I asked Perplexity.AI the following...
What is a "junk" dimension in a data warehouse?...
--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 12, 2025 at 8:31 pm

#4558170
Reply To: windows services monitor

Jeffrew wrote:
You also have some options. One approach is to use Windows built-in Task Scheduler to trigger a PowerShell script only when the service actually stops, rather than polling constantly....
--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 12, 2025 at 7:05 pm

#4558127

Reply To: using Sql without using Pivot .

jagjitsingh wrote:

How to get the below data we can create dynamically using Sql in a Table and then display using query. I will not be using Pivot .

--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 12, 2025 at 7:01 pm

#4558126

Reply To: Alternatiives to Junk Dimensions

Are you sure they said "junk" and not "jump"? There is good use for tables that only contain IDs from the Fact Tables and the Dimension tables. In relational databases,...

--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 12, 2025 at 6:43 pm

#4558116

Reply To: Backup taking too much time

My inline responses are in Bold'n'Black print below....

VastSQL wrote:

Thank you Jeff, Please find my inline response below.

Jeff Moden wrote:

If those backup drives are on the same system as your SQL Server,...

--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 12, 2025 at 5:58 pm

#4558077

Reply To: Backup taking too much time

EdVassie wrote:

From your command it looks like you are using SQL native backup. There are other backup products out there (eg SQL Litespeed) that have as part of their USP...

--Jeff Moden