Jeff Moden

Forum Replies Created

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

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
RE: Backup database to disk for insufficient disk space

Check for old backups (according to your DR plan) that can be deleted, as well.
--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:20 pm

#1939208
RE: Split out a field of comma separated values based on a unique code in the same row.

Trawler - Thursday, April 20, 2017 2:13 AM
Koen Verbeeck - Tuesday, October 21, 2014 4:02 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:11 pm

#1939206
RE: Byte Me: Functional Fashion

Heh... to coin a phrase...
"It's no longer a matter of how many sticks I have in the fire... It's now a matter of how many fires I have sticks...
--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 19, 2017 at 6:33 pm

#1938996
RE: Replace string

sgmunson - Wednesday, April 19, 2017 2:22 PM
Luis Cazares - Wednesday, April 19, 2017 1: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)

April 19, 2017 at 6:26 pm

#1938995

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