Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,991 through 7,005 (of 59,072 total)

Reply To: The Basics of Using a Sequence as a Table Default

Steve, great article. Thanks for taking the time to write it up, work out the nice simple demo's and post it all. Well done!
--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)

May 30, 2020 at 7:06 pm

#3758928
Reply To: The Basics of Using a Sequence as a Table Default

DaveBoltman wrote:
Aha! Great article, and I can immediately see a use case for having unique numbers even across different tables, where both tables get the number generated by the same...
--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)

May 30, 2020 at 7:05 pm

#3758927
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Labor Day probably makes sense. Easier to put this out there and then change later, than keep extending it.
No update from RG, but quite a few people are thinking...
--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)

May 30, 2020 at 6:03 pm

#3758908
Reply To: DATEFIRST
Steve Jones - SSC Editor wrote:
This is based on your language setting.
```
SELECT top 10
 *
 FROM sys.syslanguages
```
There is a datefirst column here. If you change the language, you change this.
Apart from...
--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)
May 30, 2020 at 5:29 am

#3758870
Reply To: Find Space occupied by a Row

Rather than using DBCC SHOWCONTIG, use sys.dm_db_index_physical_stats. The row header information is included as a part of the Min, Avg, and Max row sizes.
I'd still like to know why someone...
--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)

May 29, 2020 at 8:17 pm

#3758801
Reply To: one Rows in two Line in Result one line in one row

Since you're new, let me explain what Phil means by directing you to the first link in my signature line below. It helps others help you both a lot better...
--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)

May 29, 2020 at 5:56 pm

#3758748
Reply To: Find Space occupied by a Row

T.Ashish wrote:
My objective is to find out the space occupied by each record in a table ...
To what end? What will such information be used for? I ask because 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)

May 29, 2020 at 3:07 pm

#3758702
Reply To: how to remove null values from pivot sql

The method that Phil posted is known as a "CROSSTAB" and was the way we did pivots long before the PIVOT operator became available. CROSSTABs are also generally faster than...
--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)

May 28, 2020 at 5:57 pm

#3758259
Reply To: I need to delete a duplicate line

Sounds like a plan... especially the part about validation before deletion. Thanks for the feedback.

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

May 28, 2020 at 5:53 pm

#3758258
Reply To: Career Advice: Data Warehouse Architect/Modeler

I'd say that DW in the Cloud is on the rise and is probably a safe bet.
That, notwithstanding, ask yourself what your passion is (not to mention the finances of...
--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)

May 28, 2020 at 5:47 pm

#3758257
Reply To: How often are DB names ever referenced outside of connection strings?

I've been living with similarly named databases that have different suffixes based on the environment for a very long time. I say "living"... what I really mean is "enforcing". We...
--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)

May 28, 2020 at 5:38 pm

#3758255
Reply To: Need help with a BCP statement

What does the print statement yield?
--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)

May 27, 2020 at 2:56 pm

#3757743
Reply To: High sensitivity of SQL server 2016 to statistics ?

martinreiser wrote:
Today I have a peformance issue where setting legacy cardinality estimator ON helps.
From 100s to 1 sec. Really interesting.

Heh... that's not just "help"... that's a freakin' miracle and we...
--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)

May 27, 2020 at 1:45 pm

#3757718
Reply To: Run critical job during upgrade window - SQL Agent stopped

Why not write a query that finds all enabled jobs, makes a list (table of them), and then disable all jobs except for that critical one you're talking about?
--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)

May 27, 2020 at 3:12 am

#3757601
Reply To: I need to delete a duplicate line
I think this will be a bit more safe... details are in the comments in the code
```
 WITH cteEnumerate AS
(--==== Number each set of rows in descending...
```
--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)
May 27, 2020 at 2:20 am

#3757597

Viewing 15 posts - 6,991 through 7,005 (of 59,072 total)