Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,526 through 6,540 (of 59,091 total)

Reply To: SQL server index recommendations different from one environment to another

I've never used Brent's BlitzIndex but... you say that everything is the "same" on your boxes... is the data identical, as well? Probably not.
And I love Sergiy's "P.S.". Great example. ...
--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)

August 31, 2020 at 3:12 pm

#3784912
Reply To: Learning Isn’t Easy, But It’s Vital

While I agree that people need to learn new things (I'm in the process of learning a fair bit about AWS myself... and, unfortunately, am learning that it's not all...
--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)

August 31, 2020 at 3:02 pm

#3784910
Reply To: Data Compression Double Take

David.Poole wrote:
Compression to save disk space is of dubious value unless it saves IO.
With technologies such as Fusion-IO and SSDs where you are talking about literally thousands of times that...
--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)

August 29, 2020 at 1:48 am

#3784559
Reply To: Update many records to a date next week based on a Numeric Day Value

sgmunson wrote:
Jeff Moden wrote:
sgmunson wrote:
Okay...
Dude! What's with all the SPAM in your signature line???
SPAM? Is it not okay to have links to business pursuits?
I'm thinking not... at least not non-SQL related...
--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)

August 29, 2020 at 1:33 am

#3784555
Reply To: Rebuild index on a 5TB database

coolchaitu wrote:
We have 5 TB database and the rebuild index job is taking days to complete. Is there a way to rebuild indexes on chunks of tables/indexes. For eg, rebuild...
--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)

August 29, 2020 at 1:30 am

#3784554
Reply To: Update many records to a date next week based on a Numeric Day Value

sgmunson wrote:
Okay...
Dude! What's with all the SPAM in your signature line???
--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)

August 28, 2020 at 5:45 pm

#3784484
Reply To: Delivering in a Day

It seems to me that if a company wants to really be effective (especially a software company), innovation shouldn't be limited to just 1 day or 1 week during working...
--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)

August 28, 2020 at 2:48 pm

#3784408
Reply To: How to read list of files in folder using T-SQL?

Tomys wrote:
Hi,
My command is : EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1
And I have one file in the directory, but the out is : (0 rows affected)
I am running this on SQL Server 2017...
--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)

August 27, 2020 at 6:46 pm

#3784213
Reply To: Rebuild index on a 5TB database

Brahmanand Shukla wrote:
What is your current Index Rebuild strategy and how frequently and in what % the fragmentation is happening?
To Sergiy's point, asking about the % of Fragmentation is the first...
--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)

August 27, 2020 at 6:17 pm

#3784202
Reply To: find group of time

sharon-472085 wrote:
tank you solve 🙂
I'm not quite sure how to read that... Does that mean that you already have a solution that solved the problem or that you need 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)

August 27, 2020 at 5:25 pm

#3784183
Reply To: What is XE_SERVICES_RWLOCK and why am I seeing it so much?

Ok... now I'm curious, Jason... Which "cloud" provider are you having to move 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)

August 27, 2020 at 12:56 am

#3783975
Reply To: Getting File System Volume Info

I agree with ilyaioffe, which means that the most correct answer is actually the XP_CmdShell answer which, by the way, IS also a supported answer.
What you have listed as 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)

August 27, 2020 at 12:36 am

#3783973
Reply To: Problems with FullText re-population and iFilters on 2014 - 12.0.6024.0

I'm of no help here. I just wanted to say "thanks" for the followups on your problem... it's bound to help someone in the future and that might even be...
--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)

August 27, 2020 at 12:12 am

#3783966
Reply To: How to CAST() the value column in a dynamic unpivot

Since you're importing from a spreadsheet, do you really need a VARCHAR(MAX) column? This question also has pertinence to your other post on the subject.
--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)

August 26, 2020 at 10:26 pm

#3783946
Reply To: Changing values in Partitioned Key

How many rows are actually in this table? And, if you have that indexes, it could help if you posted the CREATE TABLE statement along with the CREATE INDEX statements. ...
--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)

August 26, 2020 at 10:23 pm

#3783945

Viewing 15 posts - 6,526 through 6,540 (of 59,091 total)