Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,626 through 11,640 (of 59,099 total)

RE: BCP Error

EMtwo - Monday, August 6, 2018 5:03 PM
So far it appears that the user has permissions on the files in the directory.
I...
--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 6, 2018 at 6:45 pm

#2000527
RE: SQL Database Documentation

Charles_P - Sunday, August 5, 2018 8:39 PM
We have a situation where the Lead SQL Developer is leaving the company and he...
--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 6, 2018 at 6:36 pm

#2000526
RE: Delete and shrink data file

WhiteLotus - Sunday, August 5, 2018 7:24 PM
Hi guys
I just deleted a lot of rows in a table to gain more...
--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 6, 2018 at 10:53 am

#2000462
RE: how to one-way encode sensitive data for display?

ScottPletcher - Monday, August 6, 2018 10:12 AM
And for all decency's sake, whatever you do, don't name the column "SSN". This...
--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 6, 2018 at 10:47 am

#2000458
RE: how to one-way encode sensitive data for display?

Eirikur Eiriksson - Monday, August 6, 2018 8:58 AM
Jeff Moden - Monday, August 6, 2018 8:46 AM
--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 6, 2018 at 9:52 am

#2000446
RE: Time Outs!!

nighthawkk - Monday, August 6, 2018 9:13 AM
I'm looking into the above now, I'm essentially walking into the db with-out any of...
--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 6, 2018 at 9:42 am

#2000438
RE: how to one-way encode sensitive data for display?

ScottPletcher - Monday, August 6, 2018 8:14 AM
Jeff Moden - Monday, August 6, 2018 8:00 AM
--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 6, 2018 at 8:46 am

#2000424
RE: how to one-way encode sensitive data for display?

autoexcrement - Monday, August 6, 2018 8:23 AM
I still just don't fully understand how salts and the like are supposedly so helpful,...
--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 6, 2018 at 8:45 am

#2000423
RE: how to one-way encode sensitive data for display?

ScottPletcher - Monday, August 6, 2018 7:43 AM
For storing of SSN, you might consider adding a check digit to the value, so...
--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 6, 2018 at 8:00 am

#2000416
RE: Will Terminators Be Required?

Dan Guzman-481633 - Monday, August 6, 2018 6:21 AM
Although not using semi-colon statement terminators has been deprecated for a decade, using
--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 6, 2018 at 7:25 am

#2000411
RE: Index fragmentation - performance within application context

Grant Fritchey - Monday, August 6, 2018 6:21 AM
The issue is, defragmentation leads to refragmentation. To really evaluate if defragmentation on 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 6, 2018 at 6:39 am

#2000404
RE: Capture the required stored stored procedures to execute

Jonathan AC Roberts - Monday, August 6, 2018 6:05 AM
Another thing you could do, provided your database isn't really busy and 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 6, 2018 at 6:24 am

#2000401
RE: A "safe" replacement for xp_CmdShell - for test purposes

glen205 - Monday, August 6, 2018 3:34 AM
Hi,
I'm currently reverse-engineering a system which makes use of xp_cmdshell to move files around 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 6, 2018 at 6:14 am

#2000397
RE: Are the posted questions getting worse?

Thom A - Monday, August 6, 2018 2:29 AM
Are you saying you don't use SSMS and stick to SOS or SQLCMD...
--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 6, 2018 at 5:48 am

#2000394
RE: Will Terminators Be Required?

scoan - Monday, August 6, 2018 1:53 AM
F%$#)ing semicolons
Heh... even though I use them all the time and very consistently so I...
--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 6, 2018 at 5:34 am

#2000391

Viewing 15 posts - 11,626 through 11,640 (of 59,099 total)