Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,441 through 22,455 (of 59,099 total)

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
RE: Best Practices

ramana3327 (11/18/2014)
Hi Jeff,
The report is now taking more than 12 hr.
The report is executing one SP. The SP initially when tested 2 months it took around 10min to execute from...
--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 18, 2014 at 7:24 pm

#1759445
RE: Export to excel row colors

Is it Excel or SSRS doing that? Or, maybe, both?
--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 18, 2014 at 7:06 pm

#1759444
RE: How do you pad left like using T-SQL query?

ScottPletcher (11/18/2014)
If you're padding a numeric value, I'd suggest using the built-in function:
STR()
I suspect that will perform better than writing the same thing out in your own code.
Actually, STR() 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)

November 18, 2014 at 6:47 pm

#1759442

Viewing 15 posts - 22,441 through 22,455 (of 59,099 total)