Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,446 through 8,460 (of 59,072 total)

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

MVDBA (Mike Vessey) wrote:
best of luck - if you have the chance, try both methods, ignore us all and go with the one that best suits you
Ditto dat!
--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 3:49 pm

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

ufrufr wrote:
Before and after backup log, can you run this command and post the result here?
dbcc sqlperf(logspace)
this command could return the physical and logical size of actual log. Sometime, 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 30, 2019 at 3:44 pm

#3693171
Reply To: Are the posted questions getting worse?
Sean Lange wrote:
Oh boy how I love vendor code. I am not exaggerating to say I just saw this.
```
try
{
OneLineOfCode;
try
{
AnotherLineOfCode;
try
{
ThirdLineOfCode;
}
catch(Exception ex) {}
}
catch(Exception ex) {}
}
catch(Exception ex) {}
```
It is bad enough...
--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:50 am

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

Thanks for the detailed information, Greg.
First, if the log file is getting too big for you on the database in question and it's only taking 20-30 minutes in the FULL...
--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:37 am

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

Viewing 15 posts - 8,446 through 8,460 (of 59,072 total)