Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,496 through 18,510 (of 59,098 total)

RE: Training at the Top

Gary Varga (1/29/2016)
SQLRNNR (1/29/2016)
Jeff Moden (1/28/2016)
Gary Varga (1/28/2016)
I am not being facetious here (I know, surprise) but perhaps putting the cyber security education and implementation remit under the Health &...
--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)

January 29, 2016 at 6:03 pm

#1855427
RE: Are the posted questions getting worse?

BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
Yes. I'd considered 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)

January 29, 2016 at 2:32 pm

#1855401
RE: Crafting Your Resume

xsevensinzx (1/29/2016)
Eric M Russell (1/28/2016)
On the flip side, as a job seeker you should also be suspicious of "opportunities" which seem to always be available. For example, there are some...
--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)

January 29, 2016 at 1:35 pm

#1855379
RE: Formatting SQL

J Livingston SQL (1/29/2016)
Jeff Moden (1/29/2016)
J Livingston SQL (1/29/2016)
http://www.apexsql.com/sql_tools_refactor.aspx
Heh... just select the "obfuscation" method and you're done. 😛
hehe....had never used it, til now.........cant see the point
I use it to show...
--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)

January 29, 2016 at 10:44 am

#1855316
RE: Formatting SQL

J Livingston SQL (1/29/2016)
http://www.apexsql.com/sql_tools_refactor.aspx
Heh... just select the "obfuscation" method and you're done. 😛
--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)

January 29, 2016 at 8:05 am

#1855247
RE: The Most Common Query Blunders...

GilaMonster (1/29/2016)
Jeff Moden (1/28/2016)
Rich Mechaber (1/5/2016)
You've probably got more material than you need by this point. This one's an old article, but I still find it useful to refer...
--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)

January 29, 2016 at 8:02 am

#1855246
RE: SQL 2014 Enterprise Edition

Markus (1/28/2016)
That is the first release of SQL 2012.
Look again. It's the RTM of 2014.
--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)

January 28, 2016 at 8:36 pm

#1855139
RE: Abstract: Tech Writing for Techies

I've found that many technologists that are in the business of writing code don't understand the extreme ROI of commenting code properly. In a previous company where no code...
--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)

January 28, 2016 at 8:33 pm

#1855138
RE: Training at the Top

Gary Varga (1/28/2016)
I am not being facetious here (I know, surprise) but perhaps putting the cyber security education and implementation remit under the Health & Safety umbrella might be all...
--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)

January 28, 2016 at 7:58 pm

#1855134
RE: The Most Common Query Blunders...

Rich Mechaber (1/5/2016)
You've probably got more material than you need by this point. This one's an old article, but I still find it useful to refer people to: https://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/%5B/url%5D.
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)

January 28, 2016 at 7:55 pm

#1855133
RE: Best practice dropping or disabling

Lowell (1/28/2016)
I've got a nifty powershell i wrote that imports Active directory data into a SQL table.
that has whether the user is enabled or disabled rendered right in the table.
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)

January 28, 2016 at 7:15 pm

#1855121
RE: TECHNICAL QUESTION on TRUNCATING and DELETING

mw112009 (1/28/2016)
TECHNICAL QUESTION
TRUE/FALSE
1.) When a table is TRUNCATED the TR-LOG is updated.
2.) When a table is DROPPED the TR-LOG is updated.
I'd say #2 is TRUE but I am not sure...
--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)

January 28, 2016 at 6:24 pm

#1855115
RE: Find Valid Date from String

Steve Jones - SSC Editor (1/28/2016)
You might look at SQL# for regex functionality
http://www.sqlsharp.com/
If it can be done in T-SQL, it'll usually be faster than RegEx. We've proven that 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)

January 28, 2016 at 6:21 pm

#1855114
RE: SSIS Script Task and running a stored procedure

JustMarie (1/27/2016)
The desired outcome - open an existing connection manager, run a stored procedure, save the results to a variable, close the connection manager.
I need to send HTML formatted email...
--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)

January 28, 2016 at 4:01 pm

#1855104
RE: Create Text File from SELECT

Orlando Colamatteo (1/28/2016)
Jeff Moden (1/28/2016)
Orlando Colamatteo (1/27/2016)
What you have here is a multi-record format where the header line has a different column-format than the data lines. T-SQL solutions traditionally have...
--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)

January 28, 2016 at 3:53 pm

#1855103

Viewing 15 posts - 18,496 through 18,510 (of 59,098 total)