Jeff Moden

Forum Replies Created

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

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

RE: steps for performance tuning of a sql server

Eirikur Eiriksson - Monday, December 31, 2018 7:13 AM
Few years back, a batch job was taking 17 hours and beefing up...
--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:32 am

#2017651

RE: Set a Variable Inside a Case Statement

harini_vaidyanath - Monday, December 31, 2018 1:01 AM
Hello Jason and Kingston,
I am working on a similar problem and am looking for your...
--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:29 am

#2017650

RE: Shrink database only x gig a week.

Eirikur Eiriksson - Monday, December 31, 2018 7:23 AM
Jeff Moden - Monday, December 31, 2018 7:12 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)

December 31, 2018 at 8:23 am

#2017649

RE: WMI connection error using Invoke-Sqlcmd

Sue_H - Friday, December 28, 2018 9:46 AM
Could also be related to the issue in this article - worth taking a...
--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 7:55 am

#2017648

RE: Shrink database only x gig a week.

frederico_fonseca - Friday, December 28, 2018 12:40 PM
have a look at my post on https://www.sqlservercentral.com/Forums/1866405/dbcc-shrinkfile?PageIndex=1
by setting @shrink_target to your desired value it will...
--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 7:12 am

#2017645

RE: steps for performance tuning of a sql server

Steve Jones - SSC Editor - Friday, December 28, 2018 8:26 AM
A poorly performing database will always look like hardware and more...
--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 6:57 am

#2017643

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