Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,411 through 22,425 (of 59,072 total)

RE: SQL DBA knowing user passwords

ZZartin (11/20/2014)
There's a difference between a service account login used by an application to connect, which a dba should know as the dba is likely the one who will need...
--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)

November 20, 2014 at 3:30 pm

#1759979
RE: SQL DBA knowing user passwords

sqldriver (11/20/2014)
Jeff Moden (11/20/2014)
NJDave (11/20/2014)
Today, a DBA in my group doesn't understand the reasoning and has experiencing storing the passwords for end-users.
Sounds mean but my suggestion is that anyone 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)

November 20, 2014 at 10:09 am

#1759900
RE: calculating working hours per day for week/month for each employee

tamer.h (11/20/2014)
based on (first in/last out) rule, i need to calculate the working hours (difference between first and last timing per day) per each employee.
Ok, so what do you want...
--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)

November 20, 2014 at 10:05 am

#1759899
RE: SQL DBA knowing user passwords

NJDave (11/20/2014)
Today, a DBA in my group doesn't understand the reasoning and has experiencing storing the passwords for end-users.
Sounds mean but my suggestion is that anyone that doesn't understand isn't...
--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)

November 20, 2014 at 9:55 am

#1759891
RE: is there a way to know who and when and what program to disable xp_cmdshell

Very cool. Thank you for the feedback. Just be aware that will also find usage and not just the instances where someone turned it off.
--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)

November 20, 2014 at 9:43 am

#1759887
RE: need table returning function with input table name as parameter

DSNOSPAM (11/19/2014)
I was kidding about the inner circle. I understand your reservations. That's why I included the comment about learning to code sql out of a cracker...
--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)

November 20, 2014 at 8:17 am

#1759858
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

hkravitz (11/20/2014)
Thanks for the article!
If I may add another solution for splitting a list of values into a table
here is a short function that does the trick:
CREATE FUNCTION FN_LIST_TO_TABLE (@List...
--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)

November 20, 2014 at 8:07 am

#1759853
RE: Are the posted questions getting worse?

Koen Verbeeck (11/20/2014)
I have been nominated for the "Author of the Year" award at MSSQLTips.com.
This means people have to vote for me (or other people, but preferable me):
http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp
Note that you...
--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)

November 20, 2014 at 7:52 am

#1759848
RE: is there a way to know who and when and what program to disable xp_cmdshell

If you have the "Default Trace" running (and you should if you don't, it's on by default though), the following should do with the understanding that you get to pick...
--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)

November 19, 2014 at 11:00 pm

#1759717
RE: Education in IT/SQL

Port1433 (11/19/2014)
Does any one know any good education and training centers in IT in U.S. in any city/state or you recommend going through a traditional public 4 year univeristy?
Get 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)

November 19, 2014 at 10:01 pm

#1759712
RE: Sum two money field columns in SQL

ksatpute123 (11/18/2014)
I'm not saying money is the best thing ever and it sure has it's issues, but just to go around declaring it should never be used is one step...
--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)

November 19, 2014 at 9:43 pm

#1759711
RE: Sum two money field columns in SQL

iammichaelclark 21625 (11/18/2014)
Hi,
I am having two columns with the money datatype values.
Column1 Column2
$134,456 $15,897
$123 ...
--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)

November 19, 2014 at 8:31 pm

#1759708
RE: Sum two money field columns in SQL

ksatpute123 (11/18/2014)
Disadvantages of money datatype:
It is proprietary, so porting it is a pain. It is one of the many "Sybase Code Museum" features from decades ago. Remember the early versions...
--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)

November 19, 2014 at 5:47 pm

#1759700
RE: Why are my transactions running in SERIALIZABLE isolation level?

My thought would be that you're spending a whole lot of time on something that might not help. IMHO, it would be much more fruitful to find the cause...
--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)

November 19, 2014 at 4:19 pm

#1759690
RE: need table returning function with input table name as parameter

I don't believe "the kludge" allows you to pass parameters to a stored procedure in a function. To do that, I believe that you still need dynamice 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)

November 19, 2014 at 3:58 pm

#1759681

Viewing 15 posts - 22,411 through 22,425 (of 59,072 total)