Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,006 through 7,020 (of 59,091 total)

Reply To: Estimate a count

Rune Bivrin wrote:
Good question to showcase a new feature!
From a BI/DS perspective, this is potentially very useful for data profiling.
Do you have a short example or suggestion of when data profiling...
--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)

June 1, 2020 at 3:24 pm

#3759114
Reply To: Inserting an incremental range of decimal numbers into a table

So, Paul... what are you going to do if a value comes in at, say, 2.005? That won't be caught by any range you've defined. Are you absolutely sure 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)

June 1, 2020 at 3:16 pm

#3759113
Reply To: Index fill factor

Heh... there actually is a way. 😉 I've presented the method to just a couple of PASS chapters and I'm working on some proposed articles for a "Stairway".

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

June 1, 2020 at 2:55 pm

#3759107
Reply To: Index fill factor

You say that you're "REBUILDing" indexes. Do you really mean that or are you including REORGANIZE, which I refer to as "Death by defragmentation"?
Obviously, I recommend NOT using REORGANIZE. 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)

June 1, 2020 at 2:31 pm

#3759082
Reply To: Estimate a count

It's amazing to me that people will tolerate a built-in 2% error for just about anything. It's just not that difficult to maintain an active total for "big data".
--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)

June 1, 2020 at 2:25 am

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

wrote:
i also want some details
Details on what? Don't expect folks to read every post on this thread to figure out what you're talking about. Be specific or quote 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 31, 2020 at 7:57 pm

#3758979
Reply To: Query

I'm actually a bit concerned about the original query because it basically returns EVERYTHING from the beginning of the table up to a point in time. That could be a...
--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 31, 2020 at 5:00 pm

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

Lynn Pettis wrote:
Brandie Tarvin wrote:
The U.S. Congress decided (wisely for once) that they wanted people to want to stay home without worrying about the bills. So they authorized an extra $600.00 per...
--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 31, 2020 at 2:10 am

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

Lynn Pettis wrote:
Jeff Moden wrote:
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...
--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 31, 2020 at 2:05 am

#3758940
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

Viewing 15 posts - 7,006 through 7,020 (of 59,091 total)