Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,876 through 7,890 (of 59,072 total)

Reply To: Max function and indexes

Craig Smith wrote:
Sorry, I am curious as to how it can do this and what factors influence it; I would like to know when indexes are needed for these types 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 15, 2020 at 8:51 pm

#3715789
Reply To: Migrating 2016 server to 2019

Charmer wrote:
What are you suggesting by lesser environment?
This...
Charmer wrote:
We don't have any testing machine provided yet. I doubt we will get it though.
That's a very real problem. There should 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)

January 15, 2020 at 7:04 pm

#3715765
Reply To: Migrating 2016 server to 2019

Charmer wrote:
Hi,
We have an OLAP cube built with 2016 version. Now DBA team is planning to migrate to 2019 SQL server version. This is a general question that if 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 15, 2020 at 5:43 pm

#3715722
Reply To: NSA Helps Microsoft with a Fairly Major Windows Security Flaw

Grant Fritchey wrote:
Yeah, I see where the paranoia comes from. However, I can also see how the NSA would prefer a more secure Windows OS.
Heh... the first thought that came 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 15, 2020 at 3:08 pm

#3715654
Reply To: Change Log Backup Frequency Automatically

Grant Fritchey wrote:
Jeff Moden wrote:
(heh... no one uses column store, right? :D) but didn't say so. My bad.
BWA-HA-HA!!!
Exactly.
I sure wasn't trying to correct your answer, just add to it.
Not to worry. It's...
--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 15, 2020 at 3:03 pm

#3715651
Reply To: Change Log Backup Frequency Automatically

Neil Burton wrote:
With regard to the recovery model, I'd forgotten about Bulk-Logged. It's definitely something to consider. Another part of the standardisation is to review the backup policies and procedures so...
--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 15, 2020 at 2:14 pm

#3715638
Reply To: Change Log Backup Frequency Automatically

Neil Burton wrote:
Jeff Moden wrote:
I have my production databases set to be "exposed" to the possibility of a transaction log backup every 15 minutes, but it's stupid to do an actual T-Log...
--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 15, 2020 at 2:08 pm

#3715636
Reply To: Change Log Backup Frequency Automatically

Grant Fritchey wrote:
Jeff Moden wrote:
p.s. And stop using REORGANIZE for your index maintenance.
With the noted exception of columnstore indexes, but only when working in 2016 SP1 or greater.
Correct. Thanks for 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 15, 2020 at 1:58 pm

#3715626
Reply To: No Records found

I try to avoid to have hit the table for each section of code and then try to avoid more than 1 section of code. With a little help 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)

January 15, 2020 at 4:55 am

#3715496
Reply To: Migration to SQL Server

Lately, the migration assistant also transmits a shedload of information about the servers involved to Microsoft, which I don't believe I want them to have no matter how benign they...
--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 15, 2020 at 1:38 am

#3715476
Reply To: Transactions Committed vs. Uncommitted Data

The problem in step 4 is that you actually have 2 transactions in step 3 but have only committed once. In step 3, you run it once with COMMIT commented...
--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 15, 2020 at 1:34 am

#3715475
Reply To: Autogrowth for data file

If it has zero or negative growth, why are you worried about the precise value of an autogrowth number? Pick a number (for example, 50 or 100MB) and move on.
I...
--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 15, 2020 at 1:24 am

#3715474
Reply To: tyring to convert a varchar to a Date

jcelko212 32090 wrote:
Actually, the ANSI/ISO Standards say that it ought to look like "2020-01-04", or maybe "2020-04-01";
Not quite right. The ISO standards state that it can look like that 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)

January 15, 2020 at 12:58 am

#3715473
Reply To: Require Recommendations | Index Rebuild

frederico_fonseca wrote:
Jeff Moden wrote:
Michael L John wrote:
I agree. Download and run Ola Hallengren's solution. It's far more complete, and is far more flexible, than what you have written.
https://ola.hallengren.com/
Ola's code is, indeed, 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 15, 2020 at 12:51 am

#3715472
Reply To: tyring to convert a varchar to a Date

itmasterw 60042 wrote:
Hi
I have the following code:
in the end, the date should look like 1/4/2020, in a date format. And while this appears to be doing that, it comes back with...
--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 14, 2020 at 6:13 pm

#3715341

Viewing 15 posts - 7,876 through 7,890 (of 59,072 total)