Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,786 through 10,800 (of 59,095 total)

RE: Can't remove multiple char(32) strings

ChrisM@Work - Monday, October 29, 2018 3:19 AM
Jeff Moden - Friday, October 26, 2018 9: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)

October 29, 2018 at 6:42 am

#2011507
RE: Tables using ANSI_NULLS

Mike Scalise - Friday, October 26, 2018 1:54 PM
Phil Parkin - Friday, October 26, 2018 1:48 PM
--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)

October 28, 2018 at 3:02 pm

#2011472
RE: How to build an app with GUI that works with SQL Server?

And sorry for the quote blocks not encompassing everything that I intended. It would appear that the forum code was written as so many other have and I've gotten used...
--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)

October 28, 2018 at 1:11 pm

#2011468
RE: How to build an app with GUI that works with SQL Server?

patrickmcginnis59 10839 - Friday, October 26, 2018 10:39 AM
All you've done is advocate the status quo, which is broken. Anyone that can build...
--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)

October 28, 2018 at 1:04 pm

#2011467
RE: Sql 2017 upgrade from 2014 with sequential numbers

ebeng - Friday, October 26, 2018 12:47 PM
Hi
Just figured out it had nothing to do with the SQL upgrade but it does...
--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)

October 27, 2018 at 12:40 pm

#2011455
RE: Are the posted questions getting worse?

Sergiy - Friday, October 26, 2018 7:52 PM
jasona.work - Thursday, October 25, 2018 12:15 PM
--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)

October 27, 2018 at 12:31 pm

#2011454
RE: Splitting value into multiple rows based on size variable

Eirikur Eiriksson - Saturday, October 27, 2018 9:27 AM
Jeff Moden - Saturday, October 27, 2018 8:29...
--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)

October 27, 2018 at 12:28 pm

#2011453
RE: Splitting value into multiple rows based on size variable

jcelko212 32090 - Friday, October 26, 2018 3:26 PM
Jackie Lowery - Friday, October 26, 2018 11:11 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)

October 27, 2018 at 8:29 am

#2011449
RE: Best apk store to download utility apps and awesome games for your Android!

anhramosus - Saturday, October 27, 2018 3:52 AM
Why I post want to ask about...
--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)

October 27, 2018 at 8:06 am

#2011448
RE: impersonation for specific username and password

mtl20144102 - Friday, October 26, 2018 3:25 PM
How do you set up impersonation for a specific username and password in sql server...
--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)

October 26, 2018 at 11:45 pm

#2011440
RE: Identifying the 3rd qualifying record

jcelko212 32090 - Friday, October 26, 2018 3:16 PM
>> I have a scenario where the client wants to identify the 3rd...
--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)

October 26, 2018 at 11:22 pm

#2011439
RE: Deleting data from a table ... quickly

Jeff Moden - Monday, October 22, 2018 3:48 PM
ScottPletcher - Monday, October 22, 2018 2:05 PM
--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)

October 26, 2018 at 3:11 pm

#2011427
RE: Naming Conventions for SQL Server Objects

David Walker-278941 - Friday, October 26, 2018 9:30 AM
Jonathan AC Roberts - Wednesday, October 24, 2018 5:28...
--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)

October 26, 2018 at 9:45 am

#2011371
RE: Prevent accidental DB drop\delete

Steve Jones - SSC Editor - Friday, October 26, 2018 8:56 AM
Script removed. User warned
Thanks, Steve.
--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)

October 26, 2018 at 9:19 am

#2011366
RE: Database Coordinator/ETL Developer (Washington, DC)

ascruggs - Friday, October 26, 2018 8:48 AM
Hi there, Integral, a leading fundraising analytics firm, is looking for a relatively entry-level/junior Database...
--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)

October 26, 2018 at 9:14 am

#2011365

Viewing 15 posts - 10,786 through 10,800 (of 59,095 total)