Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,476 through 8,490 (of 59,091 total)

Reply To: Very large t-log with backups

Greg Goss wrote:
What I've read here and what I'm seeing in my system, it's definitely the weekly index defrag that is the culprit. I have been using the Hallengren reindex script...
--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)

October 29, 2019 at 12:24 am

#3692567
Reply To: tempdb space issues

MVDBA (Mike Vessey) wrote:
Its ALWAYS the dba's fault - we just get used to it 🙂
Heh... not me... and they know better than to try... especially if they want help with 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)

October 29, 2019 at 12:08 am

#3692566
Reply To: Best Practice to Query SQL Server from Another SQL Server

tim.stutzman wrote:
I'm not too worried about having some data latency because this will be a bulk overnight job that only runs once at night. I just need to to 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)

October 28, 2019 at 11:25 pm

#3692562
Reply To: Become a Technological Historian

Steve Jones - SSC Editor wrote:
That stat has been gathered in survey's we've contracted out for from Redgate Software. Each year we hire professional surveyers to contact database people across a wide range 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)

October 28, 2019 at 11:17 pm

#3692561
Reply To: Getting Wait Stats

Someone should do a survey that asks if anyone has actually been successful in using this DMV to actually find and fix performance issues or if they use other methods...
--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)

October 28, 2019 at 6:09 pm

#3692498
Reply To: Need Create View Script for all tables

Getting back to the original replies on this thread, which more than adequately expressed the right idea which I'll strongly second, this exercise is a total waste of time 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)

October 28, 2019 at 5:23 pm

#3692481
Reply To: Index Backup
To answer the first question... NO.
To answer the implied question of how to make this faster, we need some more data. We need to know ...
1. The definition 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)
October 28, 2019 at 5:18 pm

#3692480
Reply To: Best Practice to Query SQL Server from Another SQL Server

To ask the direct question that MVDBA implied, how much data latency delay is allowed?
--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)

October 28, 2019 at 5:04 pm

#3692477
Reply To: set up data archiving

So, just out of curiosity, what did you end up doing here?
--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)

October 28, 2019 at 4:46 pm

#3692468
Reply To: Become a Technological Historian

Grant Fritchey wrote:
Eric M Russell wrote:
This is why we should comment our source code and version control checkins - so those who follow us can better understand why we did things the way...
--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)

October 28, 2019 at 2:17 pm

#3692373
Reply To: set datefirst question

David Burrows wrote:
Jeff Moden wrote:
P.S. I also strongly agree with Scott... there's no way that I'd rely on DateFirst settings never mind actually change them.
What is wrong with using DATEFIRST?
Why the strong...
--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)

October 28, 2019 at 2:03 pm

#3692371
Reply To: tempdb space issues

Thom A wrote:
vsamantha35 wrote:
Hi Thom, How to approach such people issues. This is been like a habbit for the dev team to send out email to dba team to tune as...
--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)

October 28, 2019 at 1:04 pm

#3692351
Reply To: Record counts from the table

Steve Collins wrote:
Jeff Moden wrote:
How often do you add documents/nodes to this hierarchy?
According to the OP there are approximately 25k rows in the table. If this represents 5 years of activity,...
--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)

October 27, 2019 at 10:14 pm

#3692257
Reply To: Record counts from the table

pdsqsql wrote:
Jeff,
I am completely agreed with you but this is a OPENTEXT application software so table design we don't have any control.
Honestly, I don't know how frequently we are adding...
--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)

October 27, 2019 at 10:08 pm

#3692256
Reply To: tempdb space issues

Thom A wrote:
The problem is the code that is "overly" using TempDB; you can't make TempDB use less space. Those that wrote the query need to fix it; if it's using...
--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)

October 27, 2019 at 10:07 pm

#3692255

Viewing 15 posts - 8,476 through 8,490 (of 59,091 total)