Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,186 through 10,200 (of 59,102 total)

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

George Vobr - Tuesday, January 1, 2019 5:50 AM
Today's Qotd leads to a secondary question, "What's new in SQL Server 2019?". There...
--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:30 am

#2017730
RE: Today's Random Word!

Neil Burton - Wednesday, January 2, 2019 5:47 AM
Ed Wagner - Wednesday, January 2, 2019 5:22 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 5:58 am

#2017727
RE: Shrink database only x gig a week.

Eirikur Eiriksson - Tuesday, January 1, 2019 10:25 AM
Jeff Moden -...
--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 1, 2019 at 4:20 pm

#2017703
RE: Cloning SQL Server Instances with Containers

Awesome. I've been so far away from the hardware and VM stuff, I feel a bit idiotic about it all. Thanks to your article and your posts. You've inspired...
--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 1, 2019 at 4:16 pm

#2017702
RE: Shrink database only x gig a week.

TRACEY-320982 - Monday, December 31, 2018 9:58 AM
Wow thanks for the information.
I strongly advice against using DBCC SHRINKFILE in...
--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 1, 2019 at 9:36 am

#2017694
RE: Shrink database only x gig a week.

Eirikur Eiriksson - Monday, December 31, 2018 9:53 AM
Jeff Moden -...
--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 1, 2019 at 9:26 am

#2017693

Viewing 15 posts - 10,186 through 10,200 (of 59,102 total)