Jeff Moden

Forum Replies Created

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

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
RE: Cloning SQL Server Instances with Containers

pauls 72822 - Monday, December 31, 2018 9:45 AM
When working with database clones the backup restore process is a one-time event to...
--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 8:41 am

#2017691
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Tuesday, January 1, 2019 6:45 AM
Happy new year everyone!
😎
Just wondering if some of 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 1, 2019 at 8:15 am

#2017690

RE: Shrink database only x gig a week.

frederico_fonseca - Monday, December 31, 2018 8:35 AM
It would be great if everyone had enough space and time to move tables from...
--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)

December 31, 2018 at 8:55 am

#2017653

Viewing 15 posts - 10,186 through 10,200 (of 59,099 total)
Prev
1
2
3
…
679
680
681
…
3,938
3,939
3,940
Next