Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,116 through 8,130 (of 59,102 total)

Reply To: Issue with using Ola Hallengren Backup script

Disclaimer: I don't use Ola's good code nor do I use "AG" (we use something else at work).
I understand that you currently have a single job but it would appear...
--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 17, 2019 at 3:35 pm

#3708509
Reply To: Tempdb Growth

Just be careful not to over-provision the number of files in TempDB. The "standard" recommendation is 1 file per core up to 8 as a start and then tune 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 17, 2019 at 3:21 pm

#3708501
Reply To: SQL Job advice...am I being ripped off?

Jo Pattyn wrote:
Odd question, have you contacted the CRM-provider about the slowness?
+1 Million for that suggestion.
Also, do you have a proc that properly maintains statistics and (to a lesser extent) fragmented...
--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 17, 2019 at 3:14 pm

#3708500
Reply To: Issue with using Ola Hallengren Backup script

Ummm... call Ola's stuff differently for specific databases?
--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 16, 2019 at 11:20 pm

#3708307
Reply To: Creating Split backups Question

ScottPletcher wrote:
Several. In our normal course of business, we do periodic restores, and I request periodic restores just to make sure they're working correctly. This particular company has done extremely...
--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 16, 2019 at 11:19 pm

#3708306
Reply To: Creating Split backups Question

John Mitchell-245523 wrote:
Yes, we have automated test restores and DBCC checks running constantly. That's for native backups. Unfortunately some of our databases are backed up with a SAN-based snapshot technology, which...
--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 16, 2019 at 11:18 pm

#3708305
Reply To: Creating Split backups Question

ScottPletcher wrote:
I gotta say, my life's been so much easier since we out-sourced the backup part of my DBA job. I just define the backup rules, and someone else insures...
--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 16, 2019 at 3:55 pm

#3708196
Reply To: Tracking History in Fact Table

Shifting gears a bit, you good folks are still on SQL Server 2012. My recommendation is that you need to consider upgrading. After all, 2012 is 7 years old now.
I'm...
--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 16, 2019 at 3:50 pm

#3708193
Reply To: The Evolving DBA

Eric M Russell wrote:
What DaaS means to me is that the more repetitive and time consuming (ie: the boring or 2am stuff) tasks get offloaded elsewhere, and the DBA can focus 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 16, 2019 at 3:34 pm

#3708190
Reply To: The Evolving DBA

Eric M Russell wrote:
Online trading didn't kill financial advisers, prefab construction didn't kill architects, TV dinners didn't kill professional chefs, blogging didn't kill journalism, NoSQL didn't kill SQL, and DaaS won't kill...
--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 16, 2019 at 3:32 pm

#3708185
Reply To: Creating Split backups Question

Someone should also include some of the documented pitfalls of using striped backups...
https://www.sqlservercentral.com/blogs/the-problem-with-striped-backups
--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 16, 2019 at 12:48 pm

#3708123
Reply To: A genuine use for a SQL CLR Aggregate

jcelko212 32090 wrote:
>>I should like to see Microsoft consider adding more in-built statistical functions given the way that the BI world is heading. I should also like to see some focusing...
--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 15, 2019 at 10:46 pm

#3708009
Reply To: DW design help

For question #1, what's going to happen in the single table design when (and it will happen) you end up with more than one emergency contact and more than one...
--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 15, 2019 at 10:33 pm

#3708008
Reply To: Merge statement not working as expected for bulk load.
Jonathan AC Roberts wrote:
For your example you would be much better off, in terms of performance, by having an update followed by an insert:
```
UPDATE p 
   SET...
```
--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 15, 2019 at 9:59 pm

#3708005
Reply To: BAckup history not showing into MSDB

IIRC, you posted about this on another forum. And, if that was you, you posted that you had backup history but only up to and including the 6th of December ...
--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 15, 2019 at 9:54 pm

#3708003

Viewing 15 posts - 8,116 through 8,130 (of 59,102 total)