Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,906 through 19,920 (of 59,072 total)

RE: Making Guesses

Disk space actually isn't cheap if you have no more space in a rack and have to meet the corporate standard of "all disks must be properly racked in 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)

August 11, 2015 at 8:00 am

#1818956
RE: Pivot Tables v Reports

ps_vbdev (8/11/2015)
When i get requests in from departments regarding MI i always try to deliver using ssrs. There is an old school in the company that insist on using excel...
--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)

August 11, 2015 at 7:58 am

#1818955
RE: How to insert CSV data into DB where some data don't have double quotes

Ken Tot (8/11/2015)
Example of data in CSV are as follows:
"XXX","0001",-990039739 ,0 ...
--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)

August 11, 2015 at 7:53 am

#1818952
RE: Restricting Sysadmins from adding new sysadmins

Steve Jones - SSC Editor (8/10/2015)
I think the design of many of these auditing products is to log and detect issues, not prevent them. Nor should they be under 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)

August 11, 2015 at 7:43 am

#1818947
RE: Making Guesses

Everyone I know keeps saying that "Disk space is cheap". I know better but it's still cheaper than having to work within ridiculously small confines on an unknown project....
--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)

August 11, 2015 at 7:36 am

#1818944
RE: script to list all database level permissions in a Database

Perry Whittle (8/6/2015)
This is my script, feel free to use it, I'm constantly updating and improving it
Oddly enough, I just started looking for such a thing. Timing couldn't be...
--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)

August 10, 2015 at 12:36 pm

#1818683
RE: Is there a tool that inventories SQL Server instances?

Perry Whittle (8/10/2015)
MAP is about as useful as a chocolate saucepan.
Heh... I tried MAP about 6 months ago just to see what it was all about. I couldn't think...
--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)

August 10, 2015 at 10:52 am

#1818638
RE: Comparing a column between two tables with a wildcard

j.kalkowski (8/9/2015)
I have a table containing records of criminal convictions. There are over 1M records and the only change is additions to the table on a monthly basis. ...
--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)

August 9, 2015 at 4:48 pm

#1818410
RE: Old brain, new question

You did good! Just wanted to make sure because you're the one that has to support it.
And thank you very much for explaining what it was for. Worthy...
--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)

August 9, 2015 at 4:20 pm

#1818409
RE: Old brain, new question

Thanks for the feedback and glad it worked for you.
Actually, the code was on "one line" to begin with. The method I used is known as a CTE 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)

August 9, 2015 at 12:41 pm

#1818406
RE: Varchar size change

That's a great question and is the subject of many a battle between front-end developers that are supposedly avoiding the evils of "pre-optimization" and DBAs. As with all else...
--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)

August 9, 2015 at 12:31 pm

#1818405
RE: Compatibility Mode causes query not to finish

NP. It IS one of the many reasons why I prefer to not be on the bleeding edge.
--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)

August 9, 2015 at 11:03 am

#1818402
RE: Restricting Sysadmins from adding new sysadmins

Greg Edwards-268690 (8/9/2015)
SQLRNNR (8/8/2015)
Jeff Moden (8/8/2015)
Something like CyberArk is absolutely wonderful for making auditors and soccer Moms happy but it always boils down to the root problem and no software...
--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)

August 9, 2015 at 10:04 am

#1818401
RE: Old brain, new question

No problem and please pardon my manners. I did notice you were new and meant to say "Welcome aboard" and here's a helpful hint but it was getting late...
--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)

August 9, 2015 at 10:00 am

#1818400
RE: What can I do to speed it up? Thanks.

halifaxdal (8/8/2015)
Jeff Moden (8/8/2015)
That answers my questions #2 and #5. Still looking for answers on #1, 3, and 4. Those may also make a difference.
1. Is this 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)

August 8, 2015 at 8:42 pm

#1818380

Viewing 15 posts - 19,906 through 19,920 (of 59,072 total)