Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,726 through 31,740 (of 59,099 total)

RE: Does the Role of the DBA Need to Evolve?

From the article:
Will the DBA role evolve naturally from being a "caretaker of data", to "interpreter of data", for the good of society?
I believe that anyone who doesn't already 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)

December 11, 2011 at 9:23 am

#1419813
RE: The Employment Contract

Considering that folks in HR, hiring managers, and many direct managers don't actually know what a DBA does (especially a "Hybrid" DBA) or the value they bring to an organization,...
--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)

December 11, 2011 at 9:06 am

#1419811
RE: Count Words in Text Field and/or Column (frequency of use)

texpic (12/10/2011)
All I have is read rights on a few servers (can't save a sp either to those databases). I'll just extract the data I need and move it....
--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)

December 11, 2011 at 8:58 am

#1419810
RE: Insert Millions of rows into a table at a time

1Ankit1 (12/11/2011)
If your requirement is to insert all those rows at a time into the concerned table, you might as well try using the BULK INSERT command.
)
Very nice post on...
--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)

December 11, 2011 at 8:40 am

#1419809
RE: Scrambling data which has no constraints

haivenki3 (12/10/2011)
Hi,
I would like to scramble two tables( Table A and Table B) for ID columns, which doesn't have any constraints. After scrambling I would...
--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)

December 11, 2011 at 8:31 am

#1419808
RE: Wjat would be a good supplmental skill to SQL server

ALZDBA (12/11/2011)
That's one of the reasons some of us try to stick with ansi sql and never use proprietary language features.
But, as Jeff mentioned, excel.
Heh... It's a personal belief, for...
--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)

December 11, 2011 at 8:25 am

#1419807
RE: Wjat would be a good supplmental skill to SQL server

bitbucket-25253 (12/10/2011)
If you are not completely committed to IT .. and I mean COMPLETELY, then I would suggest taking a college or graduate school course leading to a degree, and/or...
--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)

December 11, 2011 at 8:22 am

#1419806
RE: caculate age from birthdate in SQL stored procedure

You don't really need a function for this although you could certainly put it in a function for programming consistency.
SELECT DATEDIFF(yy,BirthdayColumn,GETDATE())
- CASE
...
--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)

December 11, 2011 at 8:14 am

#1419805
RE: Is a good practice to put a state field in a table?

PaulB-TheOneAndOnly (12/10/2011)
luis martin ortiz barrutia (12/10/2011)
Hello
Is a good practice to put a state field in a table?, so if it is 1 means active, 0 is deleted, so i can...
--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)

December 11, 2011 at 7:59 am

#1419804
RE: Query to find which columns have different values in a pair of rows

Marios Philippopoulos (12/9/2011)
Is there an elegant way to find out programmatically which columns have different values in each pair of rows?
1Ankit1 (12/10/2011)
There's the SQL Server "tablediff" utility as well; if...
--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)

December 11, 2011 at 7:54 am

#1419803
RE: data function

As a side bar, storing dates as separate columns for Year, Month, and Day normally creates more problems than it's worth especially when it comes to future aggregations for reporting....
--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)

December 11, 2011 at 6:54 am

#1419799
RE: Masking

vino5786 (12/9/2011)
Hi,
In a Blob column we storing mail contents, comments, documents etc.,
That content contains credit card number, While sending it to screen we need to mask that...
--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)

December 11, 2011 at 6:49 am

#1419798
RE: Divide Decimal value By ^ value(XOR)

"^" means "Bitwise OR" in SQL and not an XOR. In most other things, it means "raised to a power". The formula you have appears to be an...
--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)

December 10, 2011 at 5:37 pm

#1419762
RE: Wjat would be a good supplmental skill to SQL server

My recommendation would be to be a lot different than the masses of unemployed. Although it's certainly good to have a well rounded background, unless you're really, really good...
--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)

December 10, 2011 at 5:32 pm

#1419760
RE: Count Words in Text Field and/or Column (frequency of use)

texpic (12/10/2011)
Ahh ok, I though a function could be part of the stored procedure, that the reason for it was to make it easier to reuse that part of 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)

December 10, 2011 at 1:09 pm

#1419745

Viewing 15 posts - 31,726 through 31,740 (of 59,099 total)