Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,351 through 7,365 (of 59,091 total)

Reply To: Are the posted questions getting worse?

Brandie Tarvin wrote:
Wow. My joke really hit with a thud. I'm surprised no one pulled out the Pork Chop Launcher on me. @=)
Nah... I was too busy laughing with you to...
--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)

April 8, 2020 at 6:27 pm

#3741542
Reply To: Developer Edition

Grant Fritchey wrote:
Admingod wrote:
Sensitive data should absolutely not be in use in dev & test servers that means the data needs to me masked in dev?
Yes!
General Data Protection Regulation, California Citizens...
--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)

April 8, 2020 at 6:22 pm

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

No need to pile on for the following but, because of things like this, security breeches in the world just don't surprise me anymore.
https://www.sqlservercentral.com/forums/topic/only-one-expression-can-be-specified-in-the-select-list-when-the-subquery-is-not
How do these people get their...
--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)

April 8, 2020 at 5:21 pm

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

jasona.work wrote:
So, how's everyone surviving the shut in?
We've got a nice day on tap here, and while I'm putting in a couple extra hours this afternoon, I think I still...
--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)

April 8, 2020 at 5:18 pm

#3741519
Reply To: Arithmetic overflow error converting expression to data type nvarchar.

I think you also find that the Date data coming from an AS400 or IBM PowerSystem will contain all 0's for "null" dates.
Also, don't use VARCHAR(10) to hold string representations...
--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)

April 8, 2020 at 4:56 pm

#3741498
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

Ken McKelvey wrote:
It is best to store integers as integers, dates as dates etc. There is nothing wrong with having nulls.
While I totally agree with the first statement there, I seriously...
--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)

April 8, 2020 at 4:42 pm

#3741496
Reply To: Compression: should I compress the entire table or each index indivitually?

reka_liebe wrote:
Before answering your question, first you need to priorities why you need compression. If the answer is you need to save space, then you will benefit from index compression....
--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)

April 8, 2020 at 3:49 pm

#3741474
Reply To: Partitioning table techniques which one is best way?

Saravanan_tvr wrote:
When you have lot of budget then we will prefer the consultant, but handling sql 7.0 to till 2017 we need to take over this with being backup and...
--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)

April 8, 2020 at 2:25 pm

#3741442
Reply To: Need T-SQL to list all tables in database that 'qualify' for Compression

VoldemarG wrote:
oh well.
Should I not even bother compressing non-clustered indexes?
what if my table does not have clustered indexes? it only has a composite primary key, non-clustered. And a dozen 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)

April 7, 2020 at 11:08 pm

#3741249
Reply To: Iterating Over Calculated Tables using Power Query

I can't comment much about your good article other than it seems well laid out and produces the correct order of revelation. So nice job there.
I'll also state that I...
--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)

April 7, 2020 at 9:12 pm

#3741214
Reply To: Daily Coping Tip 3 Apr 2020

I have a tip... Download the Developer's Edition of T-SQL, a copy of SQL Server "Books Online", and start teaching yourself more about SQL Server so that when you do...
--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)

April 7, 2020 at 4:16 pm

#3741108
Reply To: Permissions to Run CLR Assembly

What would be more interesting is what the CLR assemblies actually do. A lot of people resort to CLR simply because they don't know how to do something in T-SQL. ...
--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)

April 7, 2020 at 4:05 pm

#3741099
Reply To: bcp format file and import fixed width text file

smattiko83 wrote:
I'm trying to set up a format file using bcp but I'm unsure of how to set it up.
I used "bcp de_identified.dbo.test format -c -t -f c:\sql\test3.fmt -T" and...
--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)

April 7, 2020 at 4:02 pm

#3741094
Reply To: Partitioning table techniques which one is best way?

A trillion row table and you folks have no previous experience with partitioning. My recommendation is that you don't try this on your own. Get a consultant that really knows...
--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)

April 7, 2020 at 3:29 pm

#3741074
Reply To: Execute permission on a function

evaz wrote:
Thank you all!
I have asked and they are sorting it out 🙂

Excellent! I have found that "The answer is always 'NO'... unless you ask". 😀
--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)

April 7, 2020 at 3:17 pm

#3741071

Viewing 15 posts - 7,351 through 7,365 (of 59,091 total)