Jeff Moden

Forum Replies Created

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

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

@patrick-2,
Heh... it's so odd. You and I actually are joined at the hip on a lot of things.
On the subject of the original app, I agree...
--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 7:06 pm

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

ebeng - Monday, October 29, 2018 5:00 AM
Thanks Jeff
Ill check out the Estimator also
Whether it fixes it or not, the Quirky Update...
--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:55 am

#2011512
RE: Changing 1 or + in a telephone number to the correct format

What about the spaces between area code, exchange, and line that were originally posted?
--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:51 am

#2011511
RE: Where is the Performance Bottleneck?

With the understanding that it resets when the SQL Server Service bounces and that something can be driven out of cache, I'd bet that it's code problems that need to...
--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:48 am

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

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