Jeff Moden

Forum Replies Created

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

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
RE: The Next SQL Server Version

George Vobr - Wednesday, January 2, 2019 2:38 PM
Jeff Moden - Wednesday, January 2, 2019 8:41 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 2, 2019 at 7:44 pm

#2017816
RE: SQL Server DB auditing

Use another question mark?
As a bit of an important sidebar, there's no way on this good Green Earth that I'd ever grant EXECUTE for an entire database to the PUBLIC...
--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 4:47 pm

#2017812
RE: Query Performance

The Op hasn't gotten back on my questions yet. If the problem definition turns out to be what I what I posted in my questions, then it will be what...
--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 4:39 pm

#2017811
RE: Where did our 30GBs go?

Michael L John - Wednesday, January 2, 2019 10:16 AM
scarr030 - Wednesday, January 2, 2019 10:08 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 2, 2019 at 10:33 am

#2017769
RE: Query Performance

chandan_jha18 - Wednesday, January 2, 2019 6:49 AM
Hello All,
Wish you a very happy new year 2019!!
I had been asked to review performance...
--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 9:52 am

#2017760
RE: Query Performance

ScottPletcher - Wednesday, January 2, 2019 8:26 AM
Cluster the [SearchSuggest_QGram_tbl] on [nameCacheId] rather than on gram.
While I agree that will cure the problem 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 2, 2019 at 9:46 am

#2017759
RE: The Next SQL Server Version

George Vobr - Wednesday, January 2, 2019 7:24 AM
Yes, they did at least something, but I want to start the new year...
--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 8:41 am

#2017749
RE: Where did our 30GBs go?

Jonathan AC Roberts - Monday, December 17, 2018 7:37 PM
Jeff Moden - Monday, December 17, 2018 4:52...
--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 7:44 am

#2017740
RE: How to insert variables in rows

Based on the question and if you intend to use SQL on a regular basis (you are creating a stored procedure so I assume you're doing something with SQL on...
--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 6:34 am

#2017731

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