Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,156 through 10,170 (of 59,093 total)

RE: Porting SQLServerCentral

Eric M Russell - Friday, January 4, 2019 6:23 AM
Jeff Moden - Thursday, January 3, 2019 9:28...
--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 4, 2019 at 8:56 am

#2017995
RE: How to Bulk Insert data from csv which contains double quotes to sql server 2014

vikasjagadale8 - Thursday, January 3, 2019 11:14 PM
Thanks, Jeff I tried your suggested format file
Bulk insert generated the error: Bulk load...
--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 4, 2019 at 8:48 am

#2017991
RE: SQL Memory & Tempdb usage

I'll have to defer to someone like Gail Shaw or another MCM for the correct answers there, especially when it comes to the priority of operations...
--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 4, 2019 at 8:31 am

#2017986
RE: Query Performance

chandan_jha18 - Friday, January 4, 2019 6:38 AM
Jeff Moden - Thursday, January 3, 2019 3:57 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 4, 2019 at 7:37 am

#2017977
RE: The Giving Back Workload

Funny... I just read the WIKI article on the subject of RTFM and they don't know what the origin is. I don't either but the first time I heard it...
--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 3, 2019 at 10:37 pm

#2017949
RE: Select convert to 2 decimal places, comma, right aligned

chad 62627 - Thursday, January 3, 2019 3:34 PM
Okay look...I know this is 5 years later...but I googled this issue, and this...
--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 3, 2019 at 10:07 pm

#2017948
RE: Porting SQLServerCentral

I just remembered that on every WordPress.com article that I posted a comment to, I had to subscribe to that article. I hope we don't have to do that 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 3, 2019 at 9:28 pm

#2017947
RE: SQL query to only return a row based on fluid conditions

You'd likely get help more quickly if you posted your data in a readily consumable format. Lot's of people like to test their solutions before posting an answer. 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)

January 3, 2019 at 8:25 pm

#2017944
RE: how to do this join?

APPLY works out to be the same as a correlated subquery that can return more than 1 row for each correlation.
--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 3, 2019 at 8:22 pm

#2017943
RE: SQL Memory & Tempdb usage

Jonathan AC Roberts - Tuesday, January 1, 2019 6:16 PM
sqlguy7777 - Tuesday, January 1, 2019 6:04 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 3, 2019 at 8:01 pm

#2017942
RE: Any way to grant a server level permission to allow [NT AUTHORITY\SYSTEM] to connect to any database?

I know this isn't the helpful answer that you're looking for but I'd start looking for a different tool to use. The one you have is way too demanding.
--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 3, 2019 at 7:55 pm

#2017941
RE: Does Stored Proc Complete if Machine Rebooted?

Heh... write code that runs faster. 😉
--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 3, 2019 at 7:33 pm

#2017940
RE: Insert Faster way

RGP - Thursday, January 3, 2019 1:01 PM
Guys,
I need to improve this Insert in a faster way
Query :
set identity_insert [Test].dbo.JOB ON
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 3, 2019 at 6:24 pm

#2017939
RE: Query Performance

chandan_jha18 - Thursday, January 3, 2019 9:23 AM
Jeff Moden - Thursday, January 3, 2019 8:45 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 3, 2019 at 3:57 pm

#2017937
RE: Query Performance

chandan_jha18 - Thursday, January 3, 2019 11:02 AM
Eirikur Eiriksson - Thursday, January 3, 2019 9: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 3, 2019 at 3:52 pm

#2017936

Viewing 15 posts - 10,156 through 10,170 (of 59,093 total)