Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,941 through 20,955 (of 59,098 total)

RE: Creating Mutliple Logins

Eirikur Eiriksson (4/26/2015)
Jeff Moden (4/24/2015)
Yeahhhh.... PoSH... NOT! 😉
Surely you meant "Not posh enough":-D
😎
normally do these things on linux using sqsh[/url].
Don't call me "Shirley". 😉
--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 26, 2015 at 2:09 pm

#1793541
RE: Creating Mutliple Logins

Thanks for the feedback, Steve.
As for the "user" part of this, we also used similar code to create the code at the DOS level to create the AD users 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)

April 26, 2015 at 11:45 am

#1793533
RE: How do I find out if I double loaded a file, programmatically?

DSNOSPAM (4/24/2015)
I was just doing a table import task (right click database name/Tasks/Import Data), not knowing my boss had just loaded the same file. it did not warn me...
--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 24, 2015 at 3:55 pm

#1793442
RE: Table Function question

That's the whole idea here! 🙂
Thank you for the feedback and please post back if you have more questions on this problem. And, if the function has the word...
--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 24, 2015 at 3:38 pm

#1793437
RE: Table Function question

adam-639168 (4/24/2015)
Thanks, I was hoping there would be some kind of loop (beyond my level) or something that could iterate through each account.
Ideally, I'd like to avoid creating a duplicate...
--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 24, 2015 at 2:48 pm

#1793422
RE: Creating Mutliple Logins

Yeahhhh.... PoSH... NOT! 😉
If they're just test users that will go away right after you're done testing, then something like the following might do.
DECLARE @sql VARCHAR(MAX)
...
--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 24, 2015 at 2:40 pm

#1793418
RE: split a comma separated string into columns

To be honest, the front end is storing the data incorrectly. The data should be sorted with just one IP address per row and, once the table is properly...
--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 24, 2015 at 2:03 pm

#1793409
RE: Importing Large Datasets

BSavoie (4/24/2015)
Hi Jeff, thanks for the reply. I'll work on tracking down those specifics for you by tomorrow. What I can tell you so far is that the files 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 24, 2015 at 6:13 am

#1793232
RE: how to assess a sql expert for a job?

sqlguy-736318 (4/23/2015)
Hi, I need to create a job description for a SQL developer. My company has several applications which use stored procs so we're going to hire a SQL...
--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 10:14 pm

#1793168
RE: Your Role Is Changing

Gail Wanabee (4/23/2015)
Teamwork is what works in all well implemented work environments. It has nothing to do with DevOps.
Heh... that's precisely what I'm talking about. Most people make the...
--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:52 pm

#1793165
RE: Code Reviews

We do 100% code reviews on any and all things SQL. That includes me and I'm the DBA. I do NOT make production code or data changes without...
--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:41 pm

#1793164
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

Viewing 15 posts - 20,941 through 20,955 (of 59,098 total)