The Heap™ – Consultancy ©®

ypercube

5:40 AM

OKAY it's working you're kinda kind guys I kiss you everywhere — bidezdzeiojdzehj yesterday

Paul White

6:26 AM

Awkward

gbn

7:09 AM

Morning all

@ConcernedOfTunbridgeWells Not bad. I'm not on the PC at weekends generally. I appear here because the heap is one of my start up pages

Marian

7:53 AM

good morning

@PaulWhite still writing? nothing new on the blog, yet :-)

Mikael Eriksson

8:29 AM

I could just fix the code for him but hey, it's Monday and if you ask for a "best way" of doing something I think you should provide something that actually works.

Ok, there is no way to not use a while loop but I still don't understand what you want the parameter to your SP to be. You are trying to fetch an int value from the XML but your text says you want the child element. What is it? Why do you have both @ChildItem and @childXML? Do you need both? Where do you populate @childXML? If you want the XML for a child instead of a value you should use .query() instead of .value(). — Mikael Eriksson 2 hours ago

dezso

swasheck is now SQL Server/Sybase Database Administrator at OppenheimerFunds

did I miss the announcement?

gbn

@dezso LinkedIn told me

Marian

@dezso I guess you missed it, it was starred few days ago

dezso

@gbn the same here - just as I'm a rare bird now on The Heap, I was wondering if swasheck himself told it to the public

@Marian ah OK

gbn

@dezso I'm here when at work

Out of work I'm AFK mostly. Just surf on the phone

ConcernedOfTunbridgeWells

9:04 AM

@gbn Well, you have good reason for that.

gbn

@ConcernedOfTunbridgeWells true

Friday was a public holiday, went to a quiet beach

ConcernedOfTunbridgeWells

@gbn Is there such a thing in Malta?

gbn

9:17 AM

@ConcernedOfTunbridgeWells off the beaten track, but yeah. No easy tourist access

Ġnejna Bay

Ġnejna Bay (pronounced ) is a popular tourist destination located about 1 kilometer from the village of Mġarr on the western coast of Malta. The beach surrounding the bay is mostly sandy. A secluded strip of shore under the steep cliff on the northern side of the bay is a popular nudist beach, although the practice is technically illegal in Malta and frowned upon by the conservative Catholic population. Ġnejna is notable for its striking clay slopes and limestone cliffs. These serve as the headlands for one of Malta's few remaining perennial freshwater springs, that runs through Wied il-...

Not popular with tourists, really

ConcernedOfTunbridgeWells

@gbn Looks nice. Bit of a hike up and down the hill, I guess.

gbn

@ConcernedOfTunbridgeWells bloody is. we got a lift

ypercube

Ha: A secluded strip of shore under the steep cliff on the northern side of the bay is a popular nudist beach, although the practice is technically illegal in Malta and frowned upon by the conservative Catholic population

ConcernedOfTunbridgeWells

@ypercube Mullets and nudists. Trying to erase... Need eyebleach.

bluefeet

10:30 AM

> SOLVED Yes, thanks to all of you. Really users.id,users.picture is the problem, when removed, everything goes smoothly

^^ but that isn't the issue

-1

Q: MySQL returns infinite number of values

I am trying to build a autocomplete input for suggesting users to page. I have a table called 'users' with fields 'id', 'fullname','username', 'picture', a table 'project_admin' with fields 'id','project_id', 'user_id4 and a table 'project_member' with fields : 'id','project_i...

ypercube

11:13 AM

@bluefeet Infinite = 10 ...

gbn

@ypercube At the limit of number of fingers. Are there higher numbers?

indago

0

Q: Full text search in postgresql on multiple tables

Problem: I have several tables that have related data. i want to have a search input box on the dashboard of the system that will search for anything(client,invoice,delivery note,...). Is it possible to have a FTS implementation in postgresql that will get the item searched and look in more than ...

full-text-search postgresql-9.1

Marian

11:51 AM

@gbn are you playing football for Malta's national team? :)

goal.com/en-my/match/92547/armenia-vs-malta/play-by-play

they had their first victory in 7 years (in official matches)

gbn

@Marian I'm too shit to play for Malta. Even too shit for Scotland

Marian

12:09 PM

@gbn well they aren't too far as I see :)

FreshPrinceOfSO

1:25 PM

First post this hour.

bluefeet

@FreshPrinceOfSO second post of this hour and one of the only posts I will probably have this week.

FreshPrinceOfSO

busy with work?

bluefeet

week long training

ConcernedOfTunbridgeWells

@Marian Damn. I was fully expecting to see a photo of someone on the Malta team with a luxuriant mullet.

Marian

@ConcernedOfTunbridgeWells :)) nah, I'll leave @gbn with his locals on the beach, no sharing is needed.

gbn

1:33 PM

@ConcernedOfTunbridgeWells More of a Swiss/German thing

FreshPrinceOfSO

week long training? sounds fun

ConcernedOfTunbridgeWells

@gbn Was looking for 'football player mullet' and found this gem instead.

bluefeet

2:01 PM

@FreshPrinceOfSO design patterns in c#, not so sure

Lamak

@bluefeet oh, was thinking like you were gonna start waking up at 1 AM and exercise harder :-).

bluefeet

@Lamak that would be more fun.

gbn

@mods... codereview.stackexchange.com/questions/27232/…

I can't be bothered to register there. Can we move it to her or SO please?

JNK

@gbn checking now

gbn

ta

Lamak

2:07 PM

So, a quick question for the SQL Server gurus. A coworker asked me how much he should expect the log of his database to grow if he wanted to create a clustered index on his ~ 260million rows table (30 GB). The table has no indexes as of yet. Any quick way to answer?

SQL Server 2008R2

gbn

@Lamak well, the table will be rebuilt in situ requiring 36GB free data space

Lamak

@gbn So, when I said that he should expect the around same space that the table is currently using, was kinda correct

gbn

Not sure about log space. It may just log the allocations of new space rather than actuakl row movements

Lamak

@gbn I get it

gbn

@Lamak yeah, the old rule of thumb was that the MDF should have (1.2 times largest table) free space for an index rebuild

the table could be bloated space wise too because of fragmentation

Lamak

2:12 PM

@gbn ok, thanks.

@gbn yeah, and should the extra space used by this rebuiling of the table reclamed back? (so to say)

gbn

@Lamak well, the "old" 30GB will be deallocated. SO yes

strictly speaking, if they are the type to shrink the DB so there is no free space, it will grow to hold this 36GB

the 30GB free will in somewhere "in the middle" of the MDF

logically that is. The MDF could be fragmented on disk

Lamak

@gbn Ok, that's good info, thank you very much

Marian

2:27 PM

@gbn your account isn't merged with the SO/DBA one :-)

gbn

@Marian this site is "free to play". No registration needed per se

I hope the Q migrates

billinkc

holy crap, no. Just NO

0

Q: What is full trust and how does it relate to SSIS packages

Could someone please tell me what full trust means? I am looking to add functionality to an SSIS package to convert html files to pdf and merge them together into one pdf file and the components that I am looking at Essential Objects PDF 2012 and ExpertPDF MergePDF both require full trust to run...

html web-services pdf ssis full-trust

Marian

@billinkc I have read that as full thrust..

Lamak

@Marian of course you have :-)

Zane

@billinkc looks as though SO is blocked this morning.

billinkc

2:33 PM

@Zane Probably the one time web filtering is valid. Place is a cesspit

gbn

Bugger me how to link accounts on codereview.se and the rest

ypercube

2:57 PM

@gbn Not sure if this helps: dba.stackexchange.com/contact/edit-logins

gbn

3:09 PM

I used the same OpenID. Can't merge. Email sent anyway

Zane

@billinkc you nver left a comment on that post. Also it's unblocked now.

billinkc

I didn't comment as I didn't want to trip the profanity filter.

Zane

I didn't evan know that was an option.

FreshPrinceOfSO

@bluefeet i would call in sick

Marian

3:26 PM

@MaxVernon hi there!

how's the job hunting going?

Mark Storey-Smith

@mrdenny Where does this "99% of IO in 64k blocks" notion arise from? Bob Dorr indicates otherwise, as does Wes Brown. Even if we were to ignore those two comprehensive articles, surely common sense dictates that you're going to see 8K IO on a platform that uses an 8K page size. — Mark Storey-Smith 16 secs ago

2

Fair?

Lamak

@MarkStorey-Smith fair

gbn

@MarkStorey-Smith yes. The phantom mod does tend to act like a biblical burning bush at times

5

Mark Storey-Smith

@gbn Like the locking one we had with him a long while back

Lamak

3:41 PM

@gbn "the phantom mod", how fiting