Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,036 through 10,050 (of 59,093 total)

RE: split text into rows: The maximum recursion 100 has been exhausted before statement completion

Jonathan AC Roberts - Wednesday, January 16, 2019 6:40 AM
marc.corbeel - Wednesday, January 16, 2019 6:14 AM
--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 16, 2019 at 8:10 am

#2019092
RE: Fun with Dates and Times

mark.edwards-1115881 - Wednesday, January 16, 2019 7:29 AM
This whole date thingy ought to be a lot simpler than all what this rhetoric...
--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 16, 2019 at 7:43 am

#2019085
RE: Fun with Dates and Times

Jerry Kelk - Wednesday, January 16, 2019 7:05 AM
Maybe so. My point, perhaps poorly made, was that it's not stored as...
--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 16, 2019 at 7:10 am

#2019078
RE: Why do we use SQL limitations? Which constraints can we use while making a database in SQL?

agrawalanjita123 - Wednesday, January 16, 2019 5:05 AM
--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 16, 2019 at 6:46 am

#2019071

RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, January 15, 2019 10:35 PM
Not sure the hospital would approve and he hasn't had alcohol in a...
--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 16, 2019 at 6:41 am

#2019067

RE: Fun with Dates and Times

Jerry Kelk - Wednesday, January 16, 2019 6:17 AM
They are always stored as a long decimal. It's about how you choose...
--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 16, 2019 at 6:36 am

#2019065

RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, January 15, 2019 9:54 PM
Okay, I only had two shots of Fireball Whiskey.
You should grab a couple...
--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 15, 2019 at 10:19 pm

#2019028

RE: Run New PowerShell Process As A Different User

Coozie - Tuesday, January 15, 2019 11:19 AM
Thanks for the reply, Jeff. This is just a simulation where I'm using a dummy...
--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 15, 2019 at 2:45 pm

#2019010

RE: Which index will perform better

Eliyahu - Tuesday, January 15, 2019 4:13 AM
I have a table with about 12M records. Between the columns, there is a datetime...
--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 15, 2019 at 7:27 am

#2018933

RE: Cross Apply Executing Too Many Times

Jonathan AC Roberts - Monday, January 14, 2019 7:36 PM
Jeff Moden - Monday, January 14, 2019 5:54...
--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 14, 2019 at 7:50 pm

#2018894

RE: Cross Apply Executing Too Many Times

Jonathan AC Roberts - Monday, January 14, 2019 10:35 AM
CROSS APPLY is a row level operator. So your table_valued_function will be run once...
--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 14, 2019 at 5:54 pm

#2018891

RE: Badly Trained AI

patrickmcginnis59 10839 - Monday, January 14, 2019 6:25 AM
I have a different opinion on that one. I don't doubt his luck...
--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 14, 2019 at 3:44 pm

#2018888

RE: Run New PowerShell Process As A Different User

$UserName = 'DOMAIN\DifferentUser'
$PlainPassword = 'StrongPassword'
The snippet of code above is from the code you posted. I'm no ninja at PowerShell but that code seems...
--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 13, 2019 at 1:33 pm

#2018797

RE: Database refresh from Production DB to Test DB in Sql server 2014

GilaMonster - Sunday, January 13, 2019 12:56 PM
You do step 2 once. Not every time.
And you generate the login script 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)

January 13, 2019 at 1:00 pm

#2018795

RE: Slow stored procedures after migration 2008 to 2016 SQL server

alexandermkd - Sunday, January 13, 2019 5:35 AM
Dear friends i want to say big tnx for all effort and help about my...
--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 13, 2019 at 12:53 pm

#2018793

Viewing 15 posts - 10,036 through 10,050 (of 59,093 total)
Prev
1
2
3
…
669
670
671
…
3,938
3,939
3,940
Next