Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,056 through 5,070 (of 59,089 total)

Reply To: column count per table best practice

Ben wrote:
I want to design a database for an OLTP app where it mainly involves customer and transaction. I know we have up to 1024 columns in a table, 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)

June 28, 2021 at 12:39 pm

#3901164
Reply To: Reading and Writing your Database's Documentation using JSON
I guess I don't understand two things...
1. Why you would ever want the documentation to be separate from the database.
2. Why on Earth you would want the result to be...
--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 28, 2021 at 12:29 pm

#3901157
Reply To: Seeking input on Best Method to Join on First or Last Row in a 1:M Join

None of that actually has anything to do with the OP's table except that you've done the same unnecessary expansion of a column like you claim he did with 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)

June 25, 2021 at 8:12 pm

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

Some good but with little to no experience??? Dude, suck them up and train them before someone corrupts them. 😀
--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 25, 2021 at 7:53 pm

#3900627
Reply To: create total record in html email

Bruin wrote:
Totally Awesome!!!!
Many Thanks!!!!
Ok... so let's see your final output as an attached file, please.
--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 25, 2021 at 4:38 pm

#3900502
Reply To: When to use calculated columns in SQL Server

Brent Ozar wrote an article about how they can force you query to go single threaded even if you're query is absolutely perfect in every other way and even when...
--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 25, 2021 at 3:57 am

#3900286
Reply To: Seeking input on Best Method to Join on First or Last Row in a 1:M Join

jcelko212 32090 wrote:
(inmate_nbr CHAR(18) NOT NULL PRIMARY KEY, -- required, not optional.
Man... talk about a worse practice ever. If you're going to do something this silly, use a GUID... at least...
--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 25, 2021 at 2:58 am

#3900276
Reply To: create total record in html email

Bruin wrote:
@jeff When I ran your code and seeing what @sql has in it, that's exactly what I was trying to achieve. How to you get that into an email...
--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 25, 2021 at 2:52 am

#3900273
Reply To: create total record in html email

Bruin wrote:
Thanks to you BOTH for taking the time posting the code, lot to digest...
I just have a question, would it be possible to also include a row total 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)

June 25, 2021 at 2:49 am

#3900270
Reply To: Doing a select with dynamic columns

jcelko212 32090 wrote:
>> I have a query that produce a table where I have a list of columns. Then I choose check what columns are on the table excluding the column...
--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 24, 2021 at 11:01 pm

#3900226
Reply To: about the concern about sp_updatestats

892717952 wrote:
Do I still need to run sp_updatestats if I execute DBCC DBREINDEX(tablename) for tables in database?
I think you should still use to run sp_updatestats as dbcc dbreindex doesn't 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)

June 24, 2021 at 10:57 pm

#3900225
Reply To: create total record in html email

First, here's a shorter way to provide the data in a readily consumable format. It's also better to do it in a temp table than a real table in most...
--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 24, 2021 at 10:08 pm

#3900221
Reply To: TSV

Jeffrey Williams wrote:
@JeffModen - that would be great, except most don't even know what character 7 let alone 28 through 31 are or how they were used. Or why we used...
--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 24, 2021 at 7:34 pm

#3900176
Reply To: Deleting folder on a drive

I figured. You can tell that's "never" happened to me before, right? 😀 Thanks for the feedback. Long live the command 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)

June 24, 2021 at 6:48 pm

#3900159
Reply To: TSV

It's a funny thing how people crab about the way Excel handles data that has a comma in a "field". It actually works exactly the way the CSV standards say...
--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 23, 2021 at 8:08 pm

#3899816

Viewing 15 posts - 5,056 through 5,070 (of 59,089 total)