Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,141 through 16,155 (of 59,067 total)

RE: Converting time - from "seconds after midnight"

sgmunson (12/5/2016)
Jeff Moden (12/5/2016)
sgmunson (12/5/2016)
Jeff Moden (12/5/2016)
Lynn Pettis (12/5/2016)
Jeff Moden (12/3/2016)
tacy.highland (12/2/2016)
The only thing I have against these nice simple answers:
As you can see, the neat thing about nice simple...
--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 5, 2016 at 9:31 pm

#1916139
RE: SQl Script runs slow running from SQL Agent

PJ_SQL (12/5/2016)
I have a job which runs SQL Script along with function which has started to run slow.
But when run the same query in the SSMS, it runs fine.
What could...
--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 5, 2016 at 7:17 pm

#1916135
RE: TLOGS

cbrammer1219 (12/5/2016)
Thank You, that was it..
Now that you've found them, you should probably fix them. If something is worth backing up, it's usually worth backing up with the ability...
--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 5, 2016 at 7:14 pm

#1916134
RE: Converting time - from "seconds after midnight"

sgmunson (12/5/2016)
Jeff Moden (12/5/2016)
Lynn Pettis (12/5/2016)
Jeff Moden (12/3/2016)
tacy.highland (12/2/2016)
The only thing I have against these nice simple answers:
As you can see, the neat thing about nice simple answers is that...
--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 5, 2016 at 7:10 pm

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

mxy (12/5/2016)
thanks alan for your time and providing a solution i will test it on my data and make necessary changes if needed based on my real data
Careful, now... 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)

December 5, 2016 at 6:48 pm

#1916132
RE: Today's Random Word!

Alan.B (12/5/2016)
Luis Cazares (12/5/2016)
crookj (12/5/2016)
djj (12/5/2016)
Lane
Lois
Lana
Turner
Postman
--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 5, 2016 at 4:42 pm

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

kevaburg (12/5/2016)
Jeff Moden (12/5/2016)
kevaburg (12/5/2016)
Have you maybe thought about creating a file watcher task that can be used as a trigger to automatically run a script when it is dropped...
--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 5, 2016 at 4:36 pm

#1916122
RE: Import data in parquet format

Aaron N. Cutshall (12/5/2016)
The team did identify a method of pushing the data to SQL Server but this approach requires coordinating the stored procedure execution on SQL Server to occur...
--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 5, 2016 at 3:45 pm

#1916118
RE: Converting time - from "seconds after midnight"

Lynn Pettis (12/5/2016)
Jeff Moden (12/3/2016)
tacy.highland (12/2/2016)
The only thing I have against these nice simple answers:
As you can see, the neat thing about nice simple answers is that they're nice and...
--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 5, 2016 at 3:43 pm

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

kevaburg (12/5/2016)
Have you maybe thought about creating a file watcher task that can be used as a trigger to automatically run a script when it is dropped into a folder?
That...
--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 5, 2016 at 9:26 am

#1916029
RE: Import data in parquet format

Just trying to use the right tool for the right thing. As with most things, shredding the parquet format in SQL Server could be done but, like using even...
--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 5, 2016 at 9:23 am

#1916028
RE: Import data in parquet format

Heh... I just looked up "Parquet Format" online. You would probably be better off writing a magic decoder ring for this in Java to expand the data into...
--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 5, 2016 at 8:58 am

#1916021
RE: Import data in parquet format

Hi Aaron,
I have no idea what the "parquet" format is. I also don't know what the source is. Would it be from a text file?
If it's from 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)

December 5, 2016 at 8:51 am

#1916018
RE: Alternatives to Microsoft Certifications

To be honest, I've found a good number of people that have achieved certification that can't actually do much for real. One of the best ways to learn is...
--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 4, 2016 at 7:25 pm

#1915933
RE: Unable to execute JOB (SSIS package)

badalkataria (12/3/2016)
Hi,
I'm trying to run a JOB which should execute an SSIS package. Unfortunately, I landed up on multiple errors stating "Dimension Processing: Error: Either the user. NT SERVICE \SQLSERVERAGENT....
--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 3, 2016 at 11:35 am

#1915903

Viewing 15 posts - 16,141 through 16,155 (of 59,067 total)