Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,246 through 7,260 (of 59,091 total)

Reply To: EF Code-First

Eirikur Eiriksson wrote:
CF normally doesn't stand for Code First, it is rather a notation of a Cluster Fxxk, but then again that would be the same thing
😎
Heh... I'll remind you 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)

April 24, 2020 at 11:32 pm

#3746217
Reply To: A Remote Work Guide

Chris Harshman wrote:
Now I find out about things later and wonder why they did it that way.
We all know the reason, though, right? It's the same reason why we sit in...
--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 24, 2020 at 11:11 pm

#3746215
Reply To: EF Code-First

EFCF is great if you want everything to be NVARCHAR(256) and even True/False columns to be NUMERIC(18,0). That's great for the economy, as well, because it keeps a raft 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 24, 2020 at 3:39 pm

#3746075
Reply To: Link Server

mariomoyeda wrote:
Hello All,
thank you all for your contributions.
The problem was resolved.
Two way street here... 😉 Please tell us what you did to resolve the problem.
--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 24, 2020 at 2:51 pm

#3746052
Reply To: A Remote Work Guide

I have to say that I'm loving the isolation (of course, I don't have kids at home and I don't like the reason for the isolation). Not much has changed...
--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 24, 2020 at 2:11 pm

#3746037
Reply To: A Solution for the Bin Packing Problem

Alessandro Mortola wrote:
Thanks you Jeff for your accurate post; I will keep your observations in mind and I will consider them in they more general meaning. At the moment I am...
--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 24, 2020 at 1:55 pm

#3746027
Reply To: Representing XML data in SQL Server

Eirikur Eiriksson wrote:
Jeff Moden - Wednesday, August 8, 2018 12:12 AM
Eirikur Eiriksson - Tuesday, August 7, 2018 11:49 PM
Thank you 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)

April 24, 2020 at 1:41 pm

#3746023
Reply To: query CTE

jcelko212 32090 wrote:
>> I have a table with 2 fields [sic] DocumentID and ArrivedDate. <<
You might want to actually read the standards for SQL. A field is a subset of 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)

April 23, 2020 at 8:55 pm

#3745805
Reply To: query CTE

Steve Collins wrote:
It's conditional counting. Sql is terrible at this.
To add to that,
Mr. Brian Gale wrote:
I agree with Ken here that the application side is better suited for this.
Personally, I would refrain...
--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 23, 2020 at 5:39 pm

#3745750
Reply To: Entity Relationship diagram - Path and Node entities

boolean wrote:
I do this in order to store an XML path
To be honest, that sounds like a slow and possibly error prone process being made to be slower and more...
--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 23, 2020 at 4:56 pm

#3745741
Reply To: Design question on Columnstore indexing implementation.

VoldemarG wrote:
If my table has 1 Clustered Index (PK), and a dozen of non-clustered row-store indexes.
I drop constraint... (existing PK/Clustered Index), Create Clustered Columnstore index on the table.
After this should...
--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 23, 2020 at 2:57 pm

#3745668
Reply To: Multi-Select Parameters with Large Number of Values

I'll second Grant's recommendation on Gail's articles. Personally, I consider them to be THE "Goto" articles on the subject especially since she's keen not only about performance but also 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)

April 23, 2020 at 2:53 pm

#3745666
Reply To: Finding Lowercase Characters

Robert Sterbal wrote:
Just curious how many of us use case insensitive fields?
I generally have no need for case sensitive data. However, if I did, I'd likely NOT make the whole server...
--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 23, 2020 at 2:32 pm

#3745664
Reply To: A Solution for the Bin Packing Problem

First, and to be sure, I always appreciate anyone that steps up to the plate with an article, especially on such a topic.
I agree with Aaron. This is NOT 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)

April 23, 2020 at 2:03 pm

#3745650
Reply To: Agent Job never ending
I'll also add....
1. Might need an update on statistics.
2. Different or missing indexes.
3. Skewed 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)
April 22, 2020 at 7:43 pm

#3745463

Viewing 15 posts - 7,246 through 7,260 (of 59,091 total)