Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,036 through 13,050 (of 59,095 total)

RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

jonathan.crawford - Thursday, January 25, 2018 9:20 AM
Jeff Moden - Thursday, January 25, 2018 7:48 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)

January 25, 2018 at 6:09 pm

#1977461
RE: How to copy a database with one big mdf file to another server with smaller multiple drives.

I've not had to work at the OS level in about a decade because I've worked for companies that have a separate group to do such things but take 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)

January 25, 2018 at 6:00 pm

#1977460
RE: Question Regarding Date logic

As a bit of a side-bar, ALL of the discussions have been great, IMHO. We got everything from speculation to "here's my experience" to "my stuff is pretty much encased...
--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)

January 25, 2018 at 4:11 pm

#1977452
RE: Question Regarding Date logic

below86 - Thursday, January 25, 2018 10:24 AM
Jeff Moden - Thursday, January 25, 2018 8:34 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)

January 25, 2018 at 4:07 pm

#1977451
RE: The percent ranks

You've just got to love some of the contradictions found in Microsoft documentation. First, they say (emphasis is mine)...
The range of values returned by PERCENT_RANK 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)

January 25, 2018 at 3:48 pm

#1977449
RE: Searching a windows explorer folder set of .sql files for a keyword using t-sql

Weegee2017 - Thursday, January 25, 2018 10:56 AM
hi there
I have a folder of .sql scripts, in a windows path 'E:\DeploymentScripts'.
I want to be able...
--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)

January 25, 2018 at 2:02 pm

#1977431
RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

GilaMonster - Thursday, January 25, 2018 8:50 AM
Jeff Moden - Thursday, January 25, 2018 7:48 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)

January 25, 2018 at 9:02 am

#1977368
RE: Question Regarding Date logic

below86 - Thursday, January 25, 2018 8:03 AM
I can't believe the number of people hung up on February not always having 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)

January 25, 2018 at 8:34 am

#1977354
RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

Jeff Moden - Thursday, January 25, 2018 7:48 AM
jonathan.crawford - Thursday, January 25, 2018 6:56 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)

January 25, 2018 at 8:08 am

#1977349
RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

jonathan.crawford - Thursday, January 25, 2018 6:56 AM
Because I don't have to know T-SQL inside out and upside down in order 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)

January 25, 2018 at 7:48 am

#1977340
RE: Should I add indexes to a log table?

river1 - Wednesday, January 24, 2018 1:11 PM
One thing seems that we all agree. As this is purely a delete and insert...
--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)

January 24, 2018 at 2:42 pm

#1977217
RE: SQL Server to recognize each individual user

jasona.work - Wednesday, January 24, 2018 1:45 PM
Vic,
Presuming your server is using Windows Authentication and your front end (which you indicated 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)

January 24, 2018 at 2:39 pm

#1977214
RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

GroverVivek - Wednesday, January 24, 2018 5:50 AM
Hello Guys,
Is it time for SQL Server Developers to start learning R/Python to excel in...
--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)

January 24, 2018 at 12:51 pm

#1977185
RE: Should I add indexes to a log table?

Before you add any indexes, examine the code that's having the performance issue and make sure that the code is SARGable and will actually be able to make use of...
--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)

January 24, 2018 at 12:48 pm

#1977184
RE: SQL Server to recognize each individual user

Vic Rauch-303403 - Wednesday, January 24, 2018 10:41 AM
What must I do within SQL Server or the SQL Database itself in order...
--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)

January 24, 2018 at 11:48 am

#1977169

Viewing 15 posts - 13,036 through 13,050 (of 59,095 total)