Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,956 through 11,970 (of 59,099 total)

RE: Phone Number Validation

N.B. - Friday, June 29, 2018 12:51 PM
Greetings,
I'm working on a project where we have to take a list of unique phone...
--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)

July 3, 2018 at 11:49 am

#1996206
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Monday, July 2, 2018 11:04 PM
Comments posted to this topic are about the item Importing Tricky CSV...
--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)

July 3, 2018 at 8:59 am

#1996168
RE: Importing Tricky CSV Files with PowerShell

Jerry Kelk - Tuesday, July 3, 2018 2:43 AM
This has been a personal annoyance for years.
Surely, the import engine should properly respect...
--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)

July 3, 2018 at 8:25 am

#1996160
RE: After Insert trigger

Arsh - Tuesday, July 3, 2018 2:19 AM
Arsh - Sunday, July 1, 2018 12:01 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)

July 3, 2018 at 6:22 am

#1996121
RE: DevOps is Really Helpful

funbi - Tuesday, July 3, 2018 2:32 AM
Jeff Moden - Monday, July 2, 2018 1: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)

July 3, 2018 at 6:08 am

#1996117
RE: Phone Number Validation

Sergiy - Monday, July 2, 2018 2:31 PM
crmitchell - Monday, July 2, 2018 11:08 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)

July 2, 2018 at 3:00 pm

#1996069
RE: DevOps is Really Helpful

Steve Jones - SSC Editor - Monday, July 2, 2018 12:50 PM
Jeff Moden - Monday, July 2,...
--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)

July 2, 2018 at 1:31 pm

#1996062
RE: String or binary data would be truncated

Steve Jones - SSC Editor - Thursday, June 28, 2018 9:45 AM
Japie Botma - Thursday, June 28,...
--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)

July 2, 2018 at 12:56 pm

#1996059
RE: DevOps is Really Helpful

Steve Jones - SSC Editor - Monday, July 2, 2018 9:03 AM
I think you're being pendantic and picky, Jeff.
Hammers existed before we...
--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)

July 2, 2018 at 12:16 pm

#1996054
RE: Looking for TSQL Query to display Parent child relationships

If it's for a one-off task, you can use SQL Diagrams, which is a built in tool. It's fairly limited but for simple tasks such as you describe, it may...
--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)

July 2, 2018 at 7:10 am

#1996000
RE: Phone Number Validation

The whole purpose of the third party software is to do exactly what is being requested and it's being done for "legal reasons". Pre-filtering is not only more difficult than...
--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)

July 2, 2018 at 6:56 am

#1995998
RE: Move files without moving subfolder files

Brandie Tarvin - Monday, July 2, 2018 6:25 AM
I have been tasked with building a powershell file mover to move files (which...
--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)

July 2, 2018 at 6:49 am

#1995997
RE: how to get the people i follow but they don't follow me back ???

Luis Cazares - Monday, July 2, 2018 6:29 AM
Have you tried using EXCEPT?
That would be my recommendation, as well. WHERE...
--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)

July 2, 2018 at 6:44 am

#1995995
RE: SQL Server 2016 - Tran log growing huge

Doing more frequent log file backups
Lj Burrows - Sunday, July 1, 2018 11:08 PM
Shrinking is bad! Shrinking database files causes blocking...
--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)

July 2, 2018 at 6:38 am

#1995991
RE: DevOps is Really Helpful

funbi - Monday, July 2, 2018 4:33 AM
You can do it without specialised tools, but it is EASIER with them. There are...
--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)

July 2, 2018 at 6:27 am

#1995988

Viewing 15 posts - 11,956 through 11,970 (of 59,099 total)