Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,466 through 18,480 (of 59,071 total)

RE: Can we delay the execution?Or ReWrite this Query?

suryahanuma (1/29/2016)
I am 100% sure it would not go beyond C usually,with 3 exemptions if all are utilized it will go F. SO we do not have to think until...
--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 7:12 pm

#1855432
RE: OPENROWSET - how to read everything as text

Ed Wagner (1/29/2016)
Once you get the syntax of the format file down, the BULK INSERT command is a rock-solid approach. You get to control the data type and maximum...
--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:08 pm

#1855429
RE: Datetime conversion

Ed Wagner (1/29/2016)
Luis Cazares (1/29/2016)
J Livingston SQL (1/29/2016)
fair enough...see your (very valid) point. but why use "CONVERT" instead of "TRY_CONVERT"? (2012 forum)
Thanks
Bad practice. I didn't see it was...
--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:07 pm

#1855428
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

Viewing 15 posts - 18,466 through 18,480 (of 59,071 total)