Jeff Moden

Forum Replies Created

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

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
RE: SQL Server 2016 - Catching Up Since SQL Server 2008R2

eshults5 - Sunday, August 19, 2018 7:20 AM
Also, developer now doesn't cost anything in non production environments and has every enterprise feature...
--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 8:03 am

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

Eirikur Eiriksson - Sunday, August 19, 2018 4:31 AM
Jeff Moden - Saturday, August 18, 2018 9:12 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 19, 2018 at 8:00 am

#2002402
RE: Long Formats

Steve Jones - SSC Editor - Saturday, August 18, 2018 11:33 AM
You're welcome. Once I started with R, I realized it's 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 18, 2018 at 6:57 pm

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

alastair.dewar1979 - Saturday, August 18, 2018 5:08 PM
Jeff,
The only server I wish to use is that one running on my own...
--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 18, 2018 at 6:56 pm

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

as0917041 - Friday, August 17, 2018 11:56 PM
To avoid wastage of time, what you can do is try a recovery tool, if...
--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 18, 2018 at 9:12 am

#2002365
RE: Replace String in multiple triggers

Steven.Grzybowski - Friday, August 17, 2018 7:24 PM
Jeff Moden - Friday, August 17, 2018 4:38 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 17, 2018 at 7:54 pm

#2002341
RE: SSMS and SOS, difference in execution times

Heh... Oh no... I knew what it was. When I first saw the abbreviate when it came out, I was thinking of the old Navy abbreviation for some unknown form...
--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 17, 2018 at 7:53 pm

#2002340

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