Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,461 through 11,475 (of 59,102 total)

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
RE: Converting gibberish String to DateTime

tinoco43 - Monday, August 20, 2018 10:45 AM
the stuffing worked,
thank you for your help. Greatly appreciated..
this is what worked for me.
, cast(stuff(stuff(substring(o.dsply_val,3,12),11,0,':'),9,0,'...
--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:08 pm

#2002567
RE: Prevent duplicates in a table

Senchi - Monday, August 20, 2018 8:53 AM
I am entering 'salaries' information into a sql server table called 'salaries'.
Fields are :
id (pk,identity),c_id...
--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 9:30 am

#2002502
RE: Copy all objects (tables, views, functions, stored procedures) from one DB to another DB

adonetok - Monday, August 20, 2018 5:18 AM
Someone told me that bcp will do it.
I'll learn it.
Eirikur is correct and you're not...
--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 6:49 am

#2002465
RE: Annoying error message 'Cannot drop table because table does not exist' in ExecuteSQL Task BIDS 2008.

VoldemarG - Sunday, August 19, 2018 5:39 PM
Well.. I realize that this whole Drop /Create issue is minor, it is only 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)

August 20, 2018 at 6:39 am

#2002459
RE: Move master DB due to restricted file permissions

Ross McMicken - Sunday, August 19, 2018 8:29 PM
Jeff Moden - Saturday, August 18, 2018 6:56 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 6:33 am

#2002458
RE: Non Clustered Index on Phone column

sunilkmr284 - Saturday, August 18, 2018 3:48 AM
Dear All,
I have a Lead table with below fields.
LeadId int (Not a primary key)
Telephone
...
...Table have 4...
--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 19, 2018 at 1:37 pm

#2002418
RE: Non Clustered Index on Phone column

Jonathan AC Roberts - Sunday, August 19, 2018 4:58 AM
Eirikur Eiriksson - Sunday, August 19, 2018 3:57...
--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 19, 2018 at 1:36 pm

#2002417
RE: How much RAM required to server

eshults5 - Sunday, August 19, 2018 10:18 AM
Well for initial sizing out, we typically deploy some standard based on requirements and what...
--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 19, 2018 at 1:24 pm

#2002416

Viewing 15 posts - 11,461 through 11,475 (of 59,102 total)