Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,926 through 20,940 (of 59,072 total)

RE: Your Role Is Changing

I've never "implemented" and never will "implement" DevOps because, as the article said, it's a culture. It didn't have a name back in 1980 when I got my first...
--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)

April 23, 2015 at 8:20 pm

#1793162
RE: Computed columns: max from other column for the same ID

DennisPost (4/23/2015)
Could you please demonstrate.
Actually, I can't because I screwed up and misread. This thread is about a "GREATEST" function and I thought it was something else entirely. ...
--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)

April 23, 2015 at 7:10 pm

#1793161
RE: Importing Large Datasets

BSavoie (4/23/2015)
SQL Server 2008 R2
We have an application that essentially sits and waits for external text files to arrive. Some of the files can be quite large. The problem 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)

April 23, 2015 at 5:17 pm

#1793150
RE: How to import a fixed length file with each row in different length

Smells like an "EDI" file.
--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)

April 23, 2015 at 5:07 pm

#1793149
RE: Any way to count the number of files deleted from share path?

~~What's wrong with just adding a counter to the loop?~~
Ah... never mind. Didn't look to see how you were deleting the files.
You could use xp_Dirtree before and after each...
--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)

April 23, 2015 at 4:56 pm

#1793148
RE: Would a Duress Password be a Good Idea?

Charles Kincaid (4/22/2015)
Eric:
In Japan would that be floor 4, and for the same reason?
Jeff:
Are you older than me? I guess that it could happen.
Also don't mess with disabled folks....
--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)

April 23, 2015 at 4:20 pm

#1793143
RE: XP_cmdshell DIR

SQL-DBA-01 (4/23/2015)
Can you please suggest all the files from one location to another using the temp table (#FileDetails)?
I have a rmeote location where I want to copy all the files...
--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)

April 23, 2015 at 4:12 pm

#1793142
RE: Help needed- Generate 8 char Alphanumeric Unique Sequence

Hmmm... depending on what it is, joint article?
--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)

April 22, 2015 at 8:11 pm

#1792903
RE: Help needed- Generate 8 char Alphanumeric Unique Sequence

dwain.c (4/22/2015)
Jeff Moden (4/22/2015)
dwain.c (4/22/2015)
Jeff - that is extremely clever!
Heh... thanks Dwain. As you can immediately tell, I've never had to do such a thing before. 😀 ...
--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)

April 22, 2015 at 8:10 pm

#1792902
RE: Help needed- Generate 8 char Alphanumeric Unique Sequence

dwain.c (4/22/2015)
Jeff - that is extremely clever!
Heh... thanks Dwain. As you can immediately tell, I've never had to do such a thing before. 😀 I've had to...
--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)

April 22, 2015 at 7:54 pm

#1792899
RE: Help needed- Generate 8 char Alphanumeric Unique Sequence

Matt Miller (#4) (4/22/2015)
Jeff Moden (4/22/2015)
grant-665832 (4/22/2015)
I'd do this in a C# CLR. Or in a simple program to generate the sequence and write it to DB table.
The code...
--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)

April 22, 2015 at 7:52 pm

#1792898
RE: Help needed- Generate 8 char Alphanumeric Unique Sequence

@ditha,
Ok, here we go.
As I previously stated and most on this thread implied, generating and storing all 3+ billion values of the complete sequence isn't just going to...
--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)

April 22, 2015 at 7:43 pm

#1792895
RE: Help needed- Generate 8 char Alphanumeric Unique Sequence

grant-665832 (4/22/2015)
I'd do this in a C# CLR. Or in a simple program to generate the sequence and write it to DB table.
The code would be straightforward.
Why? 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)

April 22, 2015 at 2:38 pm

#1792863
RE: Computed columns: max from other column for the same ID

Why not just use MAX(columname) OVER () in any queries you 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)

April 22, 2015 at 11:35 am

#1792838
RE: Would a Duress Password be a Good Idea?

SumOfDavid (4/21/2015)
So let me get this right. You're suggesting Password123 be my duress password instead of password123? Yah, I think that might work! 😀
I think there...
--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)

April 22, 2015 at 11:23 am

#1792833

Viewing 15 posts - 20,926 through 20,940 (of 59,072 total)