The Heap™ – Consultancy ©® - 2017-06-28 (page 2 of 2)

« first day (2367 days earlier) ← previous day next day → last day (2798 days later) »

Kris Gruttemeyer

19:00

Definitely. I had to switch partition schemes for a client. Primary server log shipped across the country, I just rebuilt the indexes on the new PS WITH (ONLINE=ON, DROP_EXISTING=ON) and there was very little impact to the log. That's when I found out that CREATE INDEX is super efficiently logged and REBUILD is not

Joe Obbish

is that really how it works? that sounds like an implementation error by MS

oh, that's not minimal logging

sounds like that's reduced logging

Kris Gruttemeyer

@JoeObbish Which part, the CREATE vs REBUILD logging impact?

Joe Obbish

you can't get minimal logging with a recovery model of full

If the database is set to the simple or bulk-logged recovery model, some index DDL operations are minimally logged whether the operation is executed offline or online. The minimally logged index operations are as follows:

CREATE INDEX operations (including indexed views). ALTER INDEX REBUILD or DBCC DBREINDEX operations.

Kris Gruttemeyer

I misspoke, we put the DB in BULK_LOGGED before the PS move

That's what gave us the minimal impact to the log and log shipping

Joe Obbish

that makes more sense

never done anything with a recovery model of bulk logged

Kris Gruttemeyer

19:03

Drawback being that if something goes sideways during the process, you can't do point-in-time

This is the only case I've ever used bulk logged.

Max Vernon

@sp_BlitzErik - in your blog post about select vs set, do you actually mean the select doesn't assign a value in the 2nd sample because no rows are returned by the query?

You seem to say the @DatabaseName variable is not updated when the select returns a null.

Which seems incorrect to me.

Apologies if you've already beat that dead 🐎

Joe Obbish

imo that query doesn't mean anything

Philᵀᴹ

19:38

131

Q: Is it unethical for me to not tell my employer I’ve automated my job?

I currently work on a legacy system for a company. The system is really old - and although I was hired as a programmer, my job is pretty much glorified data entry. To summarise, I get a bunch of requirements, which is literally just lots of data for each month on spreadsheets and I have to config...

ethics

A good one

sp_BlitzErik

@MaxVernon tbh i don't remember what the issue was, or even how i fixed it. that post is pretty old.

Philᵀᴹ

@MaxVernon lock escalation used to be fun* in Sybase when you were dealing with OLTP and big tables (400Gb was big in 1999)

Tom V

@Philᵀᴹ Hey I found an offshore consultant who can do my work in the same time, you just keep paying me and I'll pay him OK?

Hmm, that doesn't seem like a good idea :)

It's pretty much equivalent to "they pay me to get the job done and it's done" though

EBrown

@Philᵀᴹ My favourite part of that is the "between the lines" text.

> "I want to know if it is unethical for me to do what I am doing." "Yeah, you're unethical as f___ dude." "Haha you're wrong stupid peasant I do this for my son it's not unethical you lost the battle."

Kermit

20:40

@Lamak BRAVOOOO!!!

Lamak

20:58

@Kermit thanks!

I was having a heart attack

McNets

@Lamak what have you done?

Lamak

@McNets absolutely nothing

McNets

@Lamak The best !

Lamak

@McNets it's just that Chile won against Portugal

McNets

Ahhhhh

hahaha CR7 has failed (...again ;P)

Sorry, maybe @Kermit is Portuguese?

sp_BlitzErik

21:04

@MikaelEriksson dear lord, that and is case sensitive.

Kermit

21:56

I am Polish

This place has changed in the three years I haven't been here

McNets

All change

McNets

22:18

Spam?

A: How to recover deleted records with minimal downtime?

I believe that for this case DB2 Recovery Expert should be the best option because. In the case of a dropped object or recovery of a specific point in time, you should use the Recovery option (the undo SQL is the Log Analysis option which only affect data and not the structure). Please check IBM'...

Q: I am using Db2 Recovery Expert and having error with adding Managed Databases

I have Db2 11.1 installed in my windows machine and created a Linux 32 bit in my virtualbox (unfortunately my intel doesn't allow me to change the virtualization method..anyway). I installed Recovery Expert 5.1 in this Linux box and was able to sucessfully configure my repository database (whic...

db2 recovery tools db2-luw