Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,171 through 10,185 (of 59,102 total)

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
RE: Lack of Memory

Doctor Who 2 - Thursday, January 3, 2019 9:03 AM
Jeff Moden - Wednesday, January 2, 2019 10:07...
--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:45 pm

#2017935
RE: Lack of Memory

robert.sterbal 56890 - Thursday, January 3, 2019 6:20 AM
One of the things end users can do is baseline their applications.
Baselines alone won't...
--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:41 pm

#2017934
RE: The Next SQL Server Version

George Vobr - Thursday, January 3, 2019 7:05 AM
Hmm ... there's something to think about. Thanks for this detailed information, Jeff.
Heh......
--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:35 pm

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

The problem is how you're treating the leading quote. You can't treat it as a delimiter. It has to be treated as a guaranteed single character (a fixed field length...
--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:01 am

#2017878
RE: Query Performance

chandan_jha18 - Thursday, January 3, 2019 7:02 AM
Jeff Moden - Wednesday, January 2, 2019 9:52 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 8:45 am

#2017873
RE: Lack of Memory

I wonder why there's always the justification that developers are expensive when it is they that wrote the code that's causing the problem. Having them write the same crap code...
--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 2, 2019 at 10:07 pm

#2017821

Viewing 15 posts - 10,171 through 10,185 (of 59,102 total)