Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,466 through 15,480 (of 59,063 total)

RE: Create sql login for reporting activity

PeopleFlyFree - Friday, March 3, 2017 6:47 AM
Hello,
I need help to accomplish a 'simple' task.
Our customer need to connect to our sql...
--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)

March 5, 2017 at 1:41 pm

#1931717
RE: How to make one innerjoin to bring all value of all the substrings within a string separated by a comma

benkraiemchedlia - Saturday, March 4, 2017 12:55 AM
Yes this is the actual design of the DB,
I was thinking of counting the 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)

March 5, 2017 at 1:20 pm

#1931716
RE: Varchar Column type estimates

curious_sqldba - Friday, March 3, 2017 2:19 PM
I just realized sql server is estimating different data size when my column is varchar(7000)...
--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)

March 5, 2017 at 1:15 pm

#1931715
RE: Creative IT Learning

Heh... ok.... first of all... people who wear shirts that say "SQL is Cool", aren't. 😉
If you must wear a shirt on the subject, step it up 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)

March 5, 2017 at 12:43 pm

#1931713
RE: tsql help

vsamantha35 - Saturday, March 4, 2017 9:52 AM
Thanks a ton Erik.
The questions remains, though... why are you treating 8:00AM and 8:00PM 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)

March 5, 2017 at 12:08 pm

#1931709
RE: All Columns as Included

VastSQL - Sunday, March 5, 2017 5:34 AM
Hi Experts,
Have a select query which is selecting 40 columns .Created index with key columns...
--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)

March 5, 2017 at 12:05 pm

#1931708
RE: Format Date but Keep as Date Type

You can have some impact on the format by changing server level settings insofar as what order the date parts will appear in but, other than that, the answer is...
--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)

March 5, 2017 at 12:00 pm

#1931707
RE: Please explain difference between these terms

Heh... the reason why Google "doesn't" help here is because you've not Googled enough. 😉 Security in Windows and SQL Server is a huge subject that entire books have been...
--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)

March 5, 2017 at 10:52 am

#1931698
RE: Please explain difference between these terms

Correct and agreed on all points. LMGTFY is hilarious... until you're on the receiving end and you really need some help.
--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)

March 4, 2017 at 3:31 pm

#1931679
RE: SQL question ? How can we find all the occurrences of a text in a string

Jeff Atherton - Friday, March 3, 2017 12:26 PM
Luis Cazares - Friday, March 3, 2017 12:17 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)

March 4, 2017 at 3:23 pm

#1931678
RE: SQL question ? How can we find all the occurrences of a text in a string

Jeff Atherton - Friday, March 3, 2017 12:00 PM
J Livingston SQL - Friday, March 3, 2017...
--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)

March 4, 2017 at 1:14 pm

#1931676
RE: Please explain difference between these terms

You got that, as well. 😉 Glad everything ultimately worked out. Despite the occasional excursion to LMGTFY and occasional frustration on both sides of a given thread, I've found that...
--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)

March 4, 2017 at 8:07 am

#1931668
RE: Please explain difference between these terms

larsp777se - Friday, March 3, 2017 11:21 PM
Jeff Moden - Friday, March 3, 2017 4: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)

March 4, 2017 at 6:18 am

#1931666
RE: SQL question ? How can we find all the occurrences of a text in a string

mw112009 - Friday, March 3, 2017 6:49 AM
Would like the position of each occurrence in a comma separated string.
Apologies for the questions...
--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)

March 3, 2017 at 6:39 pm

#1931650
RE: sqlcmd error when executed from bat file

Agreed. The absence isn't causing a problem.
--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)

March 3, 2017 at 6:08 pm

#1931649

Viewing 15 posts - 15,466 through 15,480 (of 59,063 total)