Jeff Moden

Forum Replies Created

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

RE: Specified file is not a SQL Server backup file

RandomStream - Friday, January 26, 2018 4:56 PM
chrisr2 - Friday, January 26, 2018 4:14 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)

January 29, 2018 at 10:40 am

#1977730
RE: My database can't be opened

This thread has all the classic symptoms of something that will probably turn out to be spam. In the next day or two, someone will post a link to 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 29, 2018 at 10:32 am

#1977727
RE: how to get all values from one table repeated to each group on a column in another table

Naveen PK - Friday, January 26, 2018 1:54 PM
Updated Query tables:
I have a table called DisplayFields and another one called tax....
--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 27, 2018 at 10:41 am

#1977629
RE: Changing Extensions

Steve Jones - SSC Editor - Thursday, January 25, 2018 8:52 PM
I'm going to disagree on #4. That might be preferable for...
--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:52 pm

#1977480
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

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