Jeff Moden

Forum Replies Created

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

Reply To: Plan cache filling up quickly - can we write better queries?

To be honest, I doubt that the stat you dropped had anything to do with the problem. I think that you may have just had a bad plan cached 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 30, 2019 at 5:11 am

#3692947
Reply To: Oops, I deleted that data

thisisfutile wrote:
One takeaway I had from your post is that you use tables in another DB and reference them in the main DB via synonym. We have a web server...
--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 30, 2019 at 1:12 am

#3692930
Reply To: Oops, I deleted that data

stelios21 wrote:
I like @"Jeff Moden"'s Rule 2:
wrote:
another auditable process we rigidly follow is that NO ONE IS ALLOWED TO DEPLOY THEIR OWN CODE TO PRODUCTION
I used to hate having...
--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 30, 2019 at 12:47 am

#3692929
Reply To: Rogue Software Changes

sean redmond wrote:
Yes sir, credit to you, Thunderball it is. I mis-remembered the name.
I like the early James Bond movies, although I haven't seen this one for quite a while.
Heh... "Thunderbird"...
--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:23 pm

#3692690
Reply To: Oops, I deleted that data

Just my 2 cents...
I've always done updates the way you've posted. As some have said, it's saved my keester more than once.
I also hammer (in a mentor/nice way) the method...
--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:10 pm

#3692686
Reply To: Very large t-log with backups

@greg...
You say it took 1.5 hours to rebuild the DATABASE. How many GB does the database contain and was that to REBUILD all of the indexes on all 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 29, 2019 at 2:27 am

#3692580
Reply To: Index Backup

Nita Reddy wrote:
Thanks just want to make sure what if index is created in a file group can we restore that only?
Even if we could, restoring an index will not defrag...
--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:52 am

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

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