The Heap™ – Consultancy ©® - 2013-04-24 (page 3 of 3)

8:31 PM

@JNK maybe a mod?

nope

does anyone know something I don't know before I send it back, is what I'm asking

I'm about to reject it

@JNK nope

Q: SQL - Grouping results by custom 24 hour period

can you guys vote to reopen this for me?

1

I need to create an Oracle 11g SQL report showing daily productivity: how many units were shipped during a 24 hour period. Each period starts at 6am and finishes at 5:59am the next day. How could I group the results in such a way as to display this 24 hour period? I've tried grouping by day, but...

sql database query oracle rdbms

@JNK anything for you

ty

8:36 PM

@JNK not because it's you, but because I CAN!!!! (thanks to @Lamak)

@swasheck it's already proving to be a good decision

@Lamak What is that?

@FreshPrinceOfSO a guide

@Lamak for hitch hikers?

@FreshPrinceOfSO yes

8:48 PM

@swasheck slap this guy for me

You're free to decline advice about SQL best practices; don't tell me that it's not relevant to your question. — FreshPrinceOfSO 28 secs ago

@FreshPrinceOfSO do you work for baxter?

@swasheck They're a 10 minute drive from me

@FreshPrinceOfSO that's right ... i remember that. you didn't say you don't, though :)

@swasheck goo.gl/maps/XAt73

@FreshPrinceOfSO so you work for a CPA?

8:54 PM

@swasheck negative

@FreshPrinceOfSO i was just going to say ... i hope that baxter HQ is not rolling out product based on a mysql database ... i'd wretch in my chair if you did work for them

@swasheck where'd you get CPA?

bing.com/…

well bing is the problem

@swasheck Well, there's your problem.. You're using bing

8:56 PM

yeah

@FreshPrinceOfSO HIGHFIVE

@FreshPrinceOfSO but your blog clearly says

I work in the Human Resources Outsourcing industry as a database programmer coding primarily with VBA & SQL Server 2008.

@JNK HIGHFIVE

VBA? really?

You do access?

@JNK retract the highfive

8:57 PM

@JNK yeah i need to update that..

just asking, my company is always hiring sql/access developers

access folks are hard to find sometimes

I don't do the access piece myself

@swasheck aon hewitt

@JNK The VBA i deal with is in Excel

@swasheck aren't we connected on linkedin

gotcha

oh I need to connect to you guys

@FreshPrinceOfSO yeah ... but i dont always default to linkedin

@JNK mine is ultra creative

@JNK lnkd.in/Hzp9xY

9:00 PM

linkedin.com/in/swasheck

@FreshPrinceOfSO walgreens runs mysql???

@swasheck Ha. Enterprise uses Oracle.

oh FFS

@swasheck the metrics team had a workstation and had MySQL

I R dum

i need to update my shit on there too

9:02 PM

@FreshPrinceOfSO you all shared a workstation?

ok going home, gnight

@JNK ttyl

@MikeFal i am so smart ... s m r t ... i mean ... smart

@swasheck how do I see my link there?

I just spent 15 minutes trying to load the Powershell SQL snapins on a server where I don't have SQL installed at all.

9:03 PM

I want to connect to @JNK too

@Lamak www.linkedin.com/pub/jason-kyle/48/638/252/

linkedin -> view profile -> (teeny tiny link at the bottom of the profile header)

@swasheck Turned the workstation into a server

@MikeFal OH SNAP!

@swasheck I don't get a nice "www.linkedin.com/in/user"

I get an ugly: linkedin.com/profile/view?id=16858763&trk=tab_pro

9:04 PM

@Lamak It just hit me.. Lamak = Kamal

@Lamak bum deal. i dont know

@Lamak Felicitaciones!!!!!

@swasheck I do get this: linkedin.com/pub/kamal-valero/5/790/28b

@FreshPrinceOfSO yup

@swasheck thanks

@Lamak It's like I have a purpose in life

@FreshPrinceOfSO not anymore ... you just discovered it ... you may now die in peace

@swasheck I tried endorsing you for "Using Chatroom", but it wouldn't let me.

9:07 PM

@FreshPrinceOfSO it has that effect on people

@swasheck I didn't know preaching was a skill.

@FreshPrinceOfSO well i'm clearly unable to endorse you for "sense of humor"

@FreshPrinceOfSO it's not ...

@swasheck I'll submit a bug report

it's an art

@swasheck I preach on The Heap daily

9:09 PM

@FreshPrinceOfSO and you're a SO sidewalk prophet

@swasheck I feel blessed

@FreshPrinceOfSO did you sneeze, or something?

@swasheck Oh no. I correct people when they tell me "bless you"

@swasheck But I'm going to go road rage now

i have to do the microsoft shuffle ... i just installed updates

@swasheck enjoy. see you manananana

9:14 PM

Everyday he's shuffling

@FreshPrinceOfSO hasta la byebye

@MikeFal did you just call me sexy?

@swasheck Ummmm....no?

@MikeFal good

stupid metrotwit not giving me notifications

A: How can I verify that a full database restore reflects the exact source database in SQL Server?

10:23 PM

so i've been messing around with Remus' answer and i'm having trouble trying to quantify it

8

When you take the backup of database, the last LSN on the source will be X. If any activity will occur (including, say, an automated checkpoint), the source LSN will progress forward to X+n. If there is any activity that occurred on the source and was not captured on in the backup it would leave ...

nevermind

imma try one more thing

Awww yeah....dbareactions.tumblr.com/post/48804544214/…

10:39 PM

@swasheck I don't get it. Why not set database to read only, then take the backup? Problem solved.

@MarkStorey-Smith yeah ... i can do that ... i just need to be able to quantifiably confirm that there was zero data loss

so i was hoping to use LSN for to show that ... but that's not really working for me

@swasheck "its read only boss, it can't change"

@MarkStorey-Smith this is to satisfy the gubment

@swasheck "its read only" is likely to be understood more readily than a treatise on log sequence numbers :)

@MarkStorey-Smith very true ... but it's not quantifiable. also ... i can't even get the LSNs to match on a restore

10:42 PM

@swasheck Its very quantifiable, its binary, its read only or not

Its also very easy to demonstrate that its read only, by attempting to change it

Phil

Evening

@phil 'allo

@MarkStorey-Smith indeed

unfortunately ... not the requirement sigh

this is what they're actually asking for

declare c CURSOR fast_forward read_only FOR
select t.name
	from sys.tables t;

declare @sql varchar(4000);
declare @tablename varchar(50);

OPEN c
FETCH NEXT FROM c
	INTO @tablename
WHILE @@FETCH_STATUS = 0
	BEGIN
		set @sql = 'SELECT ''' + @tablename + ''' , rows = count(*) from ' + @tablename
		execute(@sql);
		FETCH NEXT FROM c
			INTO @tablename
	END
CLOSE c
DEALLOCATE c

but i really dont want to give that

@swasheck Doesn't prove anything other than that the number of rows are the same?

@MarkStorey-Smith do you see my predicament :) ... it's more conclusive to put it in read_only and back the thing up ... but they think that the rowcounts mean something ... nevermind that the row data could have changed entirely :S

10:54 PM

Yes but honestly, I'd deal with it differently. You are the expert, tell them the correct way to deal with the problem

@MarkStorey-Smith well thanks. i'm including documentation and screenshots of the sequence of events (with read_only), but i'll give them the precious row counts just to satisfy the bean counters

i'm off to drink on it ... erm ... think on it

@swasheck There is the concept of bombarding them with information so they'll leave you be.