Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,386 through 17,400 (of 59,102 total)

RE: Democratic Data Science

Steve Jones - SSC Editor (6/28/2016)
Do we need DBAs to manage backups?
Heh... I know you know better but it does bring up a point of observation. Why 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)

June 28, 2016 at 7:04 pm

#1887477
RE: Democratic Data Science

Steve Jones - SSC Editor (6/28/2016)
However now most major sports, at high amateur and pro levels, use all sorts of analytics.
And, most of the time, they don't help at...
--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)

June 28, 2016 at 7:01 pm

#1887475
RE: Changing a function to work with multiple records

NHS Baz (6/28/2016)
2. What do you mean by build a box around the user and what is Halloween protection? I'm not performing any UPDATE in the function so 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)

June 28, 2016 at 6:44 pm

#1887474
RE: Changing a function to work with multiple records

NHS Baz (6/28/2016)
3. What do you mean by inline the logic or convert to an inline table valued function? My function only returns a single integer value.
Please see the...
--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)

June 28, 2016 at 6:33 pm

#1887472
RE: Notification Mail without SMTP

New persopn (6/28/2016)
In that server SMTP is not enabled, We want to get the Backup report through mail using PowerShell without using SMTP. IS it possible
Yes. Please see the...
--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)

June 28, 2016 at 6:27 pm

#1887471
RE: Practical Uses for Synonyms in SQL Server

MMartin1 (6/28/2016)
I am wondering about the three part naming convention and its substitution with a synonym. I envision a scenario where the code reads like
/* block 1*/
SELECT ...
FROM ProductionDB_test.dbo.tableA
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)

June 28, 2016 at 6:00 pm

#1887469
RE: Return string between 2 characters from the end of the string

manderson 20961 (6/28/2016)
Sorry guys my first post on here. I'll try to be better the next time. Thanks for all your help!
Understood. Please see the first link under "Helpful...
--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)

June 28, 2016 at 5:48 pm

#1887468
RE: SQL Server 2016 is Out and It's Fabulous!

Steve Jones - SSC Editor (6/28/2016)
Jeff Moden (6/25/2016)
From the Article:
“This doesn’t work like it used to.”
While I agree that it probably has fewer bugs that previous releases, this one...
--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)

June 28, 2016 at 5:19 pm

#1887465
RE: Reduce Log Database

angelreynosog (6/28/2016)
It is the same query , not wanting to send it twice
I don't believe you included the results from the SELECT that Gail pointed out.
--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)

June 28, 2016 at 4:40 pm

#1887462
RE: rows to columns

durga.palepu (6/28/2016)
Yet another good alternative to learn but little complex compared to pivot solution.
It depends. Did you read the article I recommended? Pivot doesn't do so well on...
--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)

June 28, 2016 at 4:37 pm

#1887461
RE: Update 1 of 3 tables based on parameter

ScottPletcher (6/28/2016)
Jeff Moden (6/28/2016)
David92595 (6/28/2016)
@jeff
Because I inherited this database and the person that made it thought in spreadsheets not relational tables.
@scott
Thank you! Are their any other good ways to stop...
--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)

June 28, 2016 at 4:13 pm

#1887459
RE: Update 1 of 3 tables based on parameter

David92595 (6/28/2016)
@jeff
If im going to hard code it wouldn't it just be easier (i.e. not having to create a view) to go with the IF @State = 'AZ'...
Its hard...
--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)

June 28, 2016 at 4:09 pm

#1887457
RE: Practical Uses for Synonyms in SQL Server

MMartin1 (6/28/2016)
aj2red (6/24/2016)
If you live in a universe where you control database and scheming naming conventions, then I imagine you don't need to synonyms.
However, I don't.
For example:
We have written multiple...
--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)

June 28, 2016 at 4:01 pm

#1887455
RE: Update 1 of 3 tables based on parameter

David92595 (6/28/2016)
@jeff
Because I inherited this database and the person that made it thought in spreadsheets not relational tables.
@scott
Thank you! Are their any other good ways to stop a sql injection?...
--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)

June 28, 2016 at 12:13 pm

#1887408
RE: Return string between 2 characters from the end of the string

Luis Cazares (6/28/2016)
Jeff Moden (6/27/2016)
Luis,
Quote the OPs post where he posted the data and you'll see that the spaces are not where you expect. The sub-fields within the column...
--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)

June 28, 2016 at 7:31 am

#1887286

Viewing 15 posts - 17,386 through 17,400 (of 59,102 total)