Jeff Moden

Forum Replies Created

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

RE: INSERT running slow in SQL 2016

coolchaitu - Wednesday, January 24, 2018 11:24 PM
Good Morning Experts,
We had a database on SQL Server 2012. INSERTS were running fine....
--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 2:37 pm

#1977779
RE: how to find if xp_cmdshell is being used or not

ffarouqi - Monday, January 29, 2018 2:18 PM
I am trying to figure out if we can find out if xp_cmdshell is used...
--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 2:30 pm

#1977777
RE: Refresh all views in a database

Heh... not only different schema but the quite different problem of a view that uses the WITH SCHEMABINDING directive. You might also want to think about NOT rebuilding Indexed Views...
--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:46 am

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

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