Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,956 through 20,970 (of 59,098 total)

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
RE: Encryption Key not known

@sarah,
Seriously off topic but I have to ask... are you related to Ed Wagner on these forums?
--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 9:42 am

#1792802
RE: How is MSBI market in India

super48 (4/21/2015)
Hello,
I have total 2.6 years experienced in ssis,ssrs,ssas.still I don't feel I have enough experience on these tools.
even though I have knowledge I didn't worked on many features...
--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 9:41 am

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

@ditha,
Tonight after work, I'm going to try to save your professional life. If you run any code that generates all 3+ billion rows, the table just for that one...
--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 9:37 am

#1792797
RE: ETL Archive Issue, advice sought, please.

aaron.reese (4/22/2015)
@OP
so if you don't know what dates records were created/last updated, how would you choose records to be archived?
@JM
If someone changes the table structure, you 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)

April 22, 2015 at 9:27 am

#1792789

Viewing 15 posts - 20,956 through 20,970 (of 59,098 total)