Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,446 through 11,460 (of 59,095 total)

RE: Unicode Support and Conversion

Lynn Pettis - Tuesday, August 21, 2018 7:01 PM
Jeff Moden - Tuesday, August 21, 2018 5:31 PM
--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)

August 21, 2018 at 9:11 pm

#2002786
RE: Unicode Support and Conversion

p.s. And they did remember to plan for you to nearly double the size of all the databases and the backups, right? All that extra space is already available, right? ...
--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)

August 21, 2018 at 5:36 pm

#2002776
RE: Unicode Support and Conversion

tinausa - Monday, August 20, 2018 12:13 PM
I have SQL Server 2012 and all my inputs got changed to Unicode. I have...
--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)

August 21, 2018 at 5:31 pm

#2002774
RE: Non Clustered Index on Phone column

Eirikur Eiriksson - Tuesday, August 21, 2018 10:13 AM
Jeff Moden - Tuesday, August 21, 2018 9:51 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)

August 21, 2018 at 10:43 am

#2002715
RE: Prevent duplicates in a table

RonKyle - Tuesday, August 21, 2018 7:11 AM
Yes. The table design is bad and it will kill you in 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)

August 21, 2018 at 9:58 am

#2002706
RE: Non Clustered Index on Phone column

Lynn Pettis - Tuesday, August 21, 2018 9:00 AM
David Burrows - Tuesday, August 21, 2018 1:49 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)

August 21, 2018 at 9:51 am

#2002705
RE: Prevent duplicates in a table

Senchi - Monday, August 20, 2018 3:18 PM
Though I appreciate your opinions can somebody actually tell me on how to accomplish this...
--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)

August 20, 2018 at 8:12 pm

#2002609
RE: Prevent duplicates in a table

drew.allen - Monday, August 20, 2018 2:32 PM
Jeff Moden - Monday, August 20, 2018 2:13 PM
--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)

August 20, 2018 at 8:11 pm

#2002608
RE: Prevent duplicates in a table

andycadley - Monday, August 20, 2018 3:43 PM
RonKyle - Monday, August 20, 2018 2:21 PM
--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)

August 20, 2018 at 8:03 pm

#2002607
RE: Data Has a Dollar Value

A good example of where extrapolation can hurt is trend lines. It can cause non-obvious trend lines to be totally obfuscated/discarded as a possibility and you have to remember that 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)

August 20, 2018 at 7:46 pm

#2002605
RE: Non Clustered Index on Phone column

Joe Torre - Monday, August 20, 2018 6:10 PM
Clustering on a phone number column can introduce fragmentation as inserts are not "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)

August 20, 2018 at 7:11 pm

#2002604
RE: How to determine hardware option for a specified number of concurrent user in SQL Server?

elea.grig - Monday, August 20, 2018 12:30 PM
I am new to DB Administration and I'd like to know how to determine exact...
--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)

August 20, 2018 at 5:59 pm

#2002601
RE: Import MIllion rows into Excel

sathwik.em91 - Monday, August 20, 2018 2:34 PM
Hi Team,
I am trying to copy 2 million + rows from sql server Grid view...
--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)

August 20, 2018 at 5:17 pm

#2002599
RE: Data Has a Dollar Value

Matt Miller (4) - Monday, August 20, 2018 1:50 PM
Let me see if I get this:
1.we want to use mass analytics tools,...
--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)

August 20, 2018 at 2:15 pm

#2002570
RE: Prevent duplicates in a table

RonKyle - Monday, August 20, 2018 9:37 AM
Jeff Moden - Monday, August 20, 2018 9:30 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)

August 20, 2018 at 2:13 pm

#2002568

Viewing 15 posts - 11,446 through 11,460 (of 59,095 total)