Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,121 through 15,135 (of 59,101 total)

RE: It's all about Customer Service

My policy is simple. Prove the ROI, maintainability, safety, security, and long term cost of ownership of the new method along with an explanation as to why it can't be 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)

April 25, 2017 at 7:36 pm

#1939860
RE: SQL 2008 R2 varChar(Max) field not storing all data.. cutting off.

spitfire677 - Tuesday, April 25, 2017 3:55 PM
I recently moved my database from an older version of MS SQL Express to MS...
--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)

April 25, 2017 at 7:17 pm

#1939859
RE: How to take database backup between 2 dates (database partitioning)?

saklanivijay87 - Monday, April 24, 2017 10:35 PM
2-3 tables.
Then it is possible and maybe relatively "easy" to do what you want and...
--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)

April 25, 2017 at 8:05 am

#1939757
RE: How to take database backup between 2 dates (database partitioning)?

saklanivijay87 - Monday, April 24, 2017 5:23 AM
I am working on desktop application using .net framework and sql server as database. 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)

April 24, 2017 at 8:37 am

#1939554
RE: Dynamic connection string for pass through query

Yowch! I'm really happy I don't have to deal with case sensitive servers.
--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)

April 24, 2017 at 8:35 am

#1939552
RE: Masking emails

Good question. I learned something new today.
--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)

April 24, 2017 at 8:34 am

#1939551
RE: T-SQL Filtering data with more than one condition by row

Very cool analysis, guys.
--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)

April 23, 2017 at 8:44 am

#1939466
RE: Presentation Software Recommendations

Lowell - Sunday, April 23, 2017 5:37 AM
The who thing is very dynamic. while showing a video, for example, i might need...
--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)

April 23, 2017 at 8:40 am

#1939465
RE: T-SQL Filtering data with more than one condition by row

benkraiemchedlia - Saturday, April 22, 2017 5:09 PM
Hi,
I want to select result filtered by more than a value by a row.
I don't...
--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)

April 22, 2017 at 8:42 pm

#1939451
RE: Need help on SQL SERVER WARNING.!

sreesree.96 - Wednesday, April 19, 2017 2:05 PM
HI Experts
I am unable to change the data type VARCHAR to INT . I...
--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)

April 22, 2017 at 5:56 pm

#1939450
RE: Need help on SQL SERVER WARNING.!

GilaMonster - Saturday, April 22, 2017 3:41 PM
Jeff Moden - Saturday, April 22, 2017 11:31 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)

April 22, 2017 at 4:51 pm

#1939448
RE: Need help on SQL SERVER WARNING.!

sgmunson - Friday, April 21, 2017 10:14 AM
Jeff,
Every time I "replace" a REPLACE with something less expensive like LEFT, RIGHT, and/or SUBSTRING,...
--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)

April 22, 2017 at 11:31 am

#1939435
RE: Presentation Software Recommendations

I'm still thinking that PowerPoint can be made to do just about anything you want but the following Google search came up with a pretty good return. Anything more professional...
--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)

April 22, 2017 at 8:07 am

#1939424
RE: Presentation Software Recommendations

It doesn't help but wanted to let you know someone is listening. 😉 I've got nothing on this. I guess I should get out more. 😉
--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)

April 22, 2017 at 7:11 am

#1939423
RE: Need help on SQL SERVER WARNING.!

sgmunson - Thursday, April 20, 2017 10:05 AM
ThomasRushton - Thursday, April 20, 2017 7:12 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)

April 20, 2017 at 3:28 pm

#1939212

Viewing 15 posts - 15,121 through 15,135 (of 59,101 total)