Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,101 through 8,115 (of 59,091 total)

Reply To: Prevent Record Deletion

Hmmm... maybe an "Instead-of" trigger to reject DELETEs?
--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 18, 2019 at 9:28 pm

#3708917
Reply To: Grouping data based on each team
Jonathan AC Roberts wrote:
drew.allen wrote:
Jonathan AC Roberts wrote:
An alternative solution
```
;WITH cte AS
(
    SELECT s.Teams, s.Category, SUM(s.Sales) Sales
      FROM dbo.Sales 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)
December 18, 2019 at 9:26 pm

#3708916
Reply To: query a new vendor database

I agree with Jeff Williams... contact the vendor for this information but be careful and don't hold your breath. They either won't have it or will be loath to part...
--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 18, 2019 at 9:20 pm

#3708914
Reply To: Updating Statistics

ktflash wrote:
I a m developer (SSAS/SSIS) and familiar with the concepts of clusted and nonclustered indexes.
How much more about indexing/statistics/... should i have knowledge of?
What is "nice to have" and...
--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 4:15 pm

#3708516
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

Viewing 15 posts - 8,101 through 8,115 (of 59,091 total)