Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,201 through 16,215 (of 59,101 total)

RE: Is there a way to extract only credit card numbers from text

mxy (12/1/2016)
this is a legacy system i am working , trying to mask all the credit card data that is in plain text. But the challenge itself is the way...
--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)

December 1, 2016 at 9:37 pm

#1915615
RE: Is there a way to extract only credit card numbers from text

Manic Star (12/1/2016)
SQL might not be the best tool for this.
You should look at regular expressions processing in another language, they are usually a lot more robust that 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)

December 1, 2016 at 8:53 pm

#1915614
RE: Learn to Earn

Rod at work (12/1/2016)
I hope what you said in this article comes true. Been using Pluralsight to learn new skills. So far, nothing.
It's kind of like winning the lottery... you...
--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)

December 1, 2016 at 8:22 pm

#1915613
RE: can this be done in another way

Just add the necessary ORDER BY with a CASE statement that forces 'Full Time' to be first... like this...
WITH summary AS
(
SELECT p.Studentstatus
...
--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)

December 1, 2016 at 8:14 pm

#1915611
RE: OpenRowset for CSV File

joshua 15769 (12/1/2016)
Currently I'm looking at solutions on how to fix the error when the CSV file and our database are not equal in terms of column count. But I...
--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)

December 1, 2016 at 6:34 pm

#1915608
RE: Best and economical enterprise monitoring tool

Eric M Russell (12/1/2016)
Jeff Moden (12/1/2016)
Benki Chendu (11/29/2016)
Friends,
I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I am using...
--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)

December 1, 2016 at 6:28 pm

#1915607
RE: A scenario where SQL Server doesn't seem to help

It would appear that the OP has left the building.
--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)

December 1, 2016 at 6:14 pm

#1915606
RE: Execute a Powershell script from inside a stored procedure?

Gail Wanabee (12/1/2016)
Jeff, I agree, I just didn't know you could do that. I'm not a Windows Server administrator.
On a complete server reboot, can you recommend a way to 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)

December 1, 2016 at 6:12 pm

#1915605
RE: Functions Database

Chris Harshman (12/1/2016)
I like to use synonyms for cross-database interaction instead of a 3 part name because our nomenclature has the environment name as a suffix of the db name...
--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)

December 1, 2016 at 4:47 pm

#1915598
RE: OpenRowset for CSV File

joshua 15769 (12/1/2016)
Hi Sir Jeff Moden,
Good Day.
Sir, If you dont mid asnwering again, I searched in the internet but to no avail. My current problem is, the data which I...
--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)

December 1, 2016 at 4:41 pm

#1915597
RE: Best and economical enterprise monitoring tool

Benki Chendu (11/29/2016)
Friends,
I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I am using a tool called traverse 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)

December 1, 2016 at 3:32 pm

#1915594
RE: Best way to automate running adhoc scripts?

I wouldn't make another move without talking with the Developers and finding out what and why there is a need for so many data changes to prod and let them...
--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)

December 1, 2016 at 3:29 pm

#1915593
RE: Execute a Powershell script from inside a stored procedure?

Gail Wanabee (12/1/2016)
Grant, this needs to implemented in a startup stored procedure in the master database, before SQL Server has actually started.
What I plan to do is to create...
--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)

December 1, 2016 at 3:13 pm

#1915591
RE: Execute a Powershell script from inside a stored procedure?

Grant Fritchey (12/1/2016)
It's going to be more than a little sloppy.
Not sure why anyone would say such a thing. What kind of "slop" are you taking about?
--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)

December 1, 2016 at 3:11 pm

#1915590
RE: RAMDisk? Use it for TempDB?

Gail Wanabee (12/1/2016)
Jeff, we've looked as deeply as we can into what is a completely black box implementation.
Ah... got it. Gotta "love" hyper-convergence appliances. Thanks for the feedback.
Considering...
--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)

December 1, 2016 at 2:31 pm

#1915582

Viewing 15 posts - 16,201 through 16,215 (of 59,101 total)