The Heap™ – Consultancy ©®

6:35 AM

Teaser for you. What will happen with the following T-SQL? select 1except select 1

answered here

@ConcernedOfTunbridgeWells I think that should be good for me. Lucky I popped in. Didn't get any notification of the @. Think it only works in chat if you have been a recent participant in that room.

James Lupolt

7:14 AM

@Vérace Yes, I've read that. It has some good examples of when using a document model becomes painful. I think the FB engineers know what they're doing, but I haven't seen any explanation of how they ended up with the tech stack they have.

Vérace

7:43 AM

@JamesLupolt I don't doubt the competence of FB engineers - although Michael Stonebraker appears to think that they've set themselves up for a fate worse than death! Any comment on the other question about why not use PostgreSQL for FB?

@MartinSmith Totally forgot about e being valid in floats, was sure it would parse the second word as 1 except. Very nice, hvd deserves more credit for such a good example.

@PaulWhite sounds interesting

what happened to you during the night?

James Lupolt

@Vérace I don't use Postgres much and don't work with social media at all, so I'm probably the wrong person to ask.

8:30 AM

@AndriyM the funny thing is that this returns an empty set in PostgreSQL, a syntax error in MySQL and a complaint from Oracle that there is no FROM clause

@dezso I guess PG parsed it as ... 1 except ...

looks so

@Vérace he possibly thinks something completely different now, the speed he produces new views (and new products as a side effect) is quite high

(I mean, that 'interview' took place 4 years ago)

8:53 AM

0

Q: Priority search on columns

Description: We are using PostgreSQL 9.3 - Centos 6 x64 . We have a dtsc_search_data table as below: dtsc_search_data id ---- c1 ---- c2 ---- c3 1 ---- 1 ---- 1 ---- 1 2 ---- 1 ---- 2 ---- 2 3 ---- 1 ---- 1 ---- 3 We want to search on "c1, c2, c3" coloumns on dtsc_search_data...

postgresql

they want a solution with the lowest performance

I think I have some ideas

9:04 AM

@Vérace Seems more like a catchy title.

Is he trying to sell some new product?

yes, definitely

newSQL

VoltDB, specifically

and Vertica

@dezso Yes, that makes sense. Facebook is a big potential client.

9:39 AM

@MartinSmith oh my ...

James Lupolt

10:00 AM

@dezso He's earned a reputation as a troll (or at best, a provocateur)

Obviously a smart person though...

ConcernedOfTunbridgeWells

11:48 AM

I think my comment might be wrong.

And the "I already have" is not correct. The Primary Key constraint (and the required index) was created first, then the Unique index was added. — ypercube 1 min ago

Does SSSMS provide the same output for a table design, no matter what order the indexes/constraints were created/added?

12:12 PM

@MartinSmith Have sent SMS. Is your phone number still live?

@ypercube Apparently it does. If you run this:

USE tempdb;
GO
CREATE TABLE dbo.test (ID int IDENTITY NOT NULL, Value int);
GO
CREATE UNIQUE CLUSTERED INDEX UQ_1 ON dbo.test (ID);
GO
ALTER TABLE dbo.test ADD CONSTRAINT PK_test PRIMARY KEY NONCLUSTERED (ID);

then script the Create Table, you'll get this:

USE [tempdb]
GO

/****** Object:  Table [dbo].[test]    Script Date: 08/04/2015 15:12:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[test](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Value] [int] NULL,
 CONSTRAINT [PK_test] PRIMARY KEY NONCLUSTERED
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


USE [tempdb]
/****** Object:  Index [UQ_1]    Script Date: 08/04/2015 15:12:15 ******/

@AndriyM thnx

So it always includes the PK in the CREATE TABLE statement. Didn't know that myself.

@ypercube Does "convert the PK to use a clustered index" essentially mean they'd need to drop the constraint and recreate it with the CLUSTERED keyword (after dropping the current CI)?

12:29 PM

@AndriyM yes, I think so. I wasn't sure.

Not sure if the whole operation is feasible in one go (drop the CI, drop the PK and the non-CI and create a new CI PK).

Probably "create a new table with the new structure, copy data, then rename" would be faster, if the table is not huge and can be locked.

But there are so many people here that are more suitable to comment/suggest anything.

12:50 PM

@a_horse_with_no_name I have an existing table and so I cannot just drop the clustered index - the index stores my table. — sharptooth 4 mins ago

wha

is it different in azure somehow?

it is

social.msdn.microsoft.com/Forums/azure/en-US/…

Azure does not support heaps

yes, he just mentioned azure. Hadn't noticed the tag before.

You can surely change the CI in Azure though. Or you can't?

you can't change it without dropping/recreating

and you can't drop it

b/c NO HEAPS

suggestion from the msdn post was to make a new table and move the data

nasty

@JNK Yes. sp_rename

12:57 PM

you have to make a new table though

with the CI you want

What I suggested above.

yeah you're still right

I'm just surprised about limitations in azure

Vérace

2:13 PM

@dezso He sold Vertica to HP. As for VoltDB - getting all of FB's data into an in-memory database would be tricky! I don't see an exclusively in-memory shared-nothing architecture as being aimed at the FB's of this world.

@ypercube as mentioned by @dezso, VoltDB, but I don't think that it's aimed at FB.

@Vérace that wasn't my speculation :)

but you are right

that would need a biggish chunk of RAM

2:32 PM

CHECKDB found 0 allocation errors and 349 consistency errors in table 'SiteLog' (object ID 181575685).
CHECKDB found 0 allocation errors and 437 consistency errors in database 'Derp'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Derp).
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:2714; actual 0:0). It occurred during a read of page (1:2714) in database ID 10 at offset 0x00000001534000 in file 'I:\SQLData\Derp_Data.MDF'. Additional messages in the SQL Server error log or system event log may provide more …

I see dba.stackexchange.com/q/35107/2131

where the wisdom seems to be that the user was in dire straits. What in their question would lead the answers to come to such a conclusion

Mark Knopfler
John Illsley
Pick Withers
David Knopfler
Alan Clark
Hal Lindes
Terry Williams
Guy Fletcher
Jack Sonni
Chris White

3

PanosPlat is not listed

2:49 PM

@dezso You need more stars for that

Perhaps you should come to London for the drinkies.
We'll buy the beer.

@ypercube generous offer, but I am in Hungary at that time

@dezso I hate you (in the best way possible)

@ypercube but the occasion will come

@billinkc Espresso hate!

@dezso I hope some vampires find you

dezso is looking for a Dire Straits hit about vampires

3:05 PM

billinkc is looking for a fryer large enough for deszo

3:16 PM

HELLLLLLLOOOOOOO HEAPERS!

hi

it's that time of the quarter again when i ask you all to submit your random sql server trivia question(s) (and answer(s))

@swasheck Did you see Martin's select 1except select 1; ?

@ypercube no

9 hours ago, by Martin Smith

Teaser for you. What will happen with the following T-SQL? select 1except select 1

This variation is unny, too:

select 1except except select 1 ;

3:24 PM

yeah

sqlfiddle.com/#!6/9eecb7d/1052

So who else is doing fun and stupid things this week?

I decided to stop caffeine intake

I just had a Monster drink

some kind of energy drink

Oh, I have a four pack of the white beside me on the ground, I won't just succumb to death right away

but I'm so far four full days in

i blew out my right knee ... torn ACL, sprained LCL, MCL, PCL

3:31 PM

what was Thursday last week?

@swasheck oh good god man

@swasheck ayeeee. That must hurt

HAS EVERYONE VOTED? dba.stackexchange.com/election/4

4

it actually doesnt. just don't have full range of motion.

Q: 2015 Moderator Election Q&A - Questionnaire

@jcolebrand They haven't answered the questions yet!

7

In connection with the moderator elections, we are holding a Q&A thread for the candidates. Questions collected from an earlier thread have been compiled into this one, which shall now serve as the space for the candidates to provide their answers. Due to the lack of submission count, we have sel...

discussion featured election

Not all of them, at least.

Tim Stone

@jcolebrand I'd have to get more rep for that, that sounds like effort

3:37 PM

i've liked my interactions with grace in the past, but that first question really bothers me

@swasheck yeah, I mean, The Heap kinda does, many times jokingly, but the community treats them with "mild contempt and sometimes with open derision"?

agreed.

"How would you deal with a user who produced a steady stream of valuable answers, but tends to generate a large number of arguments/flags from comments" <---- We make them mods

2

how do you call that toy where there are 15 numbers (or pieces of a picture) on a 4*4 grid and you have to order them by pushing tiles or rows to the empty square?

The Tile Game is what my mac refers to it

3:48 PM

maybe u need do experiments to verify your thoughts, use "explain analyze verbose YOUR QUERY" ---纸上得来终觉浅，绝知此事要躬行 :) — Chris Tien 17 mins ago

this guys tells me that an index-only scan touches the heap

@swasheck @Lamak That question was by @Jack actually.

httpstatusdogs.com

^ Amuses me greatly

4:02 PM

@billinkc "moved permanently" is fantastic, as is "not modified"

@MaxVernon Not implemented appeals to my gallows humor

@Lamak Haha. I laughed out loud with that

@dezso The 15-puzzle

Can we close - (dba.stackexchange.com/q/108941/8783) as dupe of (dba.stackexchange.com/q/102275/8783) .. to me its a dupe .. the only reason I am asking is the former one is having an upvote of +1 and the later one is a downvote (-1) ?

A: 2015 Moderator Election Q&A - Question Collection

15 puzzle

The 15-puzzle (also called Gem Puzzle, Boss Puzzle, Game of Fifteen, Mystic Square and many others) is a sliding puzzle that consists of a frame of numbered square tiles in random order with one tile missing. The puzzle also exists in other sizes, particularly the smaller 8-puzzle. If the size is 3×3 tiles, the puzzle is called the 8-puzzle or 9-puzzle, and if 4×4 tiles, the puzzle is called the 15-puzzle or 16-puzzle named, respectively, for the number of tiles and the number of spaces. The object of the puzzle is to place the tiles in order (see diagram) by making sliding moves that use the empty...

Tim Stone

11

We allow questions about all sorts of databases, such as: Traditional RDBMSs; both commercial and open-source (e.g. SQL Server, Oracle, DB2, Postgres) Slightly non-traditional databases (e.g. MySQL) NoSQL and NewSQL databases and document stores (e.g. BDB, MongoDB) As a community, we sometime...

The questions were collected in a prior, er, question, in case you weren't aware. So you can blame @JackDouglas instead :P

Oh, wait, @AndriyM beat me to it.

Stalking of this room: -1

4:09 PM

I was just about to comment that you're well over your limit for comments in a month

Tim Stone

I have been excessively talkative.

I blame @jcolebrand.

2

@swasheck now you say!

too late to edit I guess

Shawn has answered it well I think though, in that sense it's served it's purpose

@JackDouglas He mentioned it before

19 hours ago, by swasheck

> MySQL is treated with mild contempt and NoSQL sometimes with open derision (though it is also widely recognised that both have their place). Is this a good thing? If not, how would you act as a moderator to encourage a different attitude in the community?

ah yes, we had a conversation then

@swasheck what is so bothersome?

4:15 PM

but I thought @swasheck was joking, not that he meant the question 'really bothers me'

the "mild contempt"?

@ypercube it turns out that guy was right in the end (which means I was wrong)

see rhaas.blogspot.de/2010/11/index-only-scans.html

@JackDouglas @ypercube ... bothersome in that i wouldnt know how to answer it because i dont believe it to be true. i guess in the heap it is true, but i dont consider chat to be "the site"

@swasheck you should have been more vocal about not liking that question then :P

@dezso you know he's a major contributor to postgres? "...works all over the code with major patches, patch review..."

4:18 PM

@bluefeet you just shoulded all over me

@swasheck by 'the community' I actualy meant 'the Heap', bad choice of words

@JackDouglas do you mean Robert? yes, of course

@JackDouglas no worries. it's totally fine and i understand where you're coming from, to a certain degree. i'm just not convinced that it's a problem to be solved in the chat arena.

@bluefeet you mean with a downvote or a comment or something? ;)

I referred to dba.stackexchange.com/a/108926/6219 with 'that guy'

4:20 PM

@swasheck neither am I if that's any consolation

@dezso ah, thanks

'vacuum more often' is often the answer :)

@swasheck but it is interesting to see how prospective mods react to the question

@JackDouglas no consolation needed --- just expressing a personal opinion. :)

@JackDouglas yes, we gather the questions based on how well they are received by the community. Some negative reaction would help

@JackDouglas that's fair

4:40 PM

@billinkc no doubt!

@Kin I'm thinking it might be better to close it as a dupe of dba.stackexchange.com/questions/15228/…

@MaxVernon true .. did not see that .. but I am voting it to close as dupe of dba.stackexchange.com/questions/15228/…

that one you suggested

there may be an even better one - give me a few minutes if you don't mind!

sure

I did the following search, and am looking at the results for a canonical target: duckduckgo.com/…

ahhhh, The Bertrand™ has a good answer here: dba.stackexchange.com/questions/21778/…

5:03 PM

Aaron has all search engines on his side ... All his answers are having a lot of excellent details ... I wish dba.se might allow or have a tool to download Q&A for specific users - Aaron, Paul, Remus ... and many more :-)

@Kin It is possible to filter questions and answers by the poster.

Q: How to install Sql Server 2000 on Windows 10(x64)?

oh my gosh ... just ... why

1

After upgrading Win8.1 to Win10, Sql Server 2000 does not work. I tried to re-install Win10, and installed Sql Server 2000, but the installation stopped at installing MDAC, it could not continue. Did anyone succeed on installing it?

sql-server windows-10

@TimStone who doesn't?

Mike Fal

@swasheck I know, right?

@Kin If you open e.g. Aaron's profile, you will see user:1186 in the search box at the top – that will let you look for Aaron's posts only. You can add search terms or other special keywords to make the search more specific.

5:13 PM

@AndriyM Thanks .. I am aware of that .. I was just thinking download as pdf .. that can be useful ! Just like we have MVP deep dives published as book.

5:39 PM

@swasheck Too localized?

"...is not relevant to most of our audience..."

Q: Why Does the Transaction Log Keep Growing or Run Out of Space?

92

This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this: In SQL Server - What are some reasons the transaction log grows so large? Why is my log file so big? What are some ways to prevent this prob...

sql-server transaction-log

I'm reading that (again) and I guess I never realized that taking a database was insufficient for clearing the transaction log? Am I really that dense (peanut gallery aside)?

That may be what I need to (re-)read right now too.

@billinkc "taking"?

You mean taking a backup? Taking it off-line?

"taking a database backup", perhaps

^^^

We manage half the client's databases so we have our jobs to backup the database and the tlogs. The rest they do with their auto cloud backup tool

As part of my database corruption research today, I noticed that the databases they maintain have logs equal to or greater than their data files

5:53 PM

It's amazing but that's the problem I'm facing too

The database backups are going on but sp_blitz is reporting the logs have not been backed up. wait stat on the log reuse wait description is LOG_BACKUP so yeah, looks like my assumption is wrong

6:04 PM

@swasheck close as "unlikely to ever help anyone, anywhere, other than the OP"!

@MaxVernon and even then you mean 'help' in the sense of giving them a footgun

@JackDouglas agreed. How could one possibly think that would be a good idea?

which bit, Windows 10 a week after launch or SQL Server 2000 15 years later?

W10 scares me

@JackDouglas LOL. Yeah, I have a Surface Pro, and I'm scared to death of installing WX on it.

I'm in the middle of another dalliance with OSX

it's actually working out quite well this time

6:15 PM

@JackDouglas there is certainly some appeal there. Anything built on Unix has got to have some good things. And Apple hardware is fantastic.

I was sold on the hardware years ago, but up until now I've mainly been running W7 on it

staingate is pretty much the only problem I've ever had with an Apple laptop

@JackDouglas that sure makes a machine easy to use!

@JackDouglas Huh, I just figured I sucked at cleaning my monitor

@JackDouglas jeez, never heard about it

my theory is that it's caused by sweat residue on the keys/trackpad - there is basically no clearence when the lid is closed

@billinkc do you use turps?

6:28 PM

Can a large size of a log file, itself, cause serious (or any) performance degradation? We are talking about a situation where it is known that there's plenty of unused space in the log, it's just that the size is big for some reason.

@JackDouglas Nah, just a moistened towel

@billinkc @JackDouglas meant for your monitor

2

You sonofa

@billinkc I assumed you were kidding, sorry. Do you mean your laptop screen or really a monitor? If the latter I don't think it's related...

Laptop screen. If I owned one of those big ol Apple monitors, it'd be subject to droolgate

6:45 PM

@billinkc I have 2 of them.

2 thunderbolts

Is this part of your onboarding with SE or did you already have them (and my jealousy)

onboarding. I got a new machine, desk, chair, etc

@MaxVernon mine's not that bad yet - hardly notice it unless the screen is off (which hardly matters)

@AndriyM you'll want to check if there are hundreds of thousands of virtual log files (VLFs); that may degrade performance.

Q: Copying audio files having length more than 5 minutes in SSIS

-1

We have a call recordings for a particular client loaded everyday on to our local server from third party FTP. Now client wants to send the recording files which are more than 5 minutes to their internal FTP.Is there a way in SSIS where i can select the audio files with more 5 minutes . Thanks...

ssis ssis-2012 ssis-2008

Peoples...

6:59 PM

thanks @ypercube for that comment! I thought I had, but clearly I didn't proof-read that very well if the first letter was a problem!

@MaxVernon Thank you! Now to read on VLFs...

@AndriyM I'd recommend starting at sqlskills.com/blogs/kimberly/…

does anyone know if T-SQL allows regex searches?

@MaxVernon Thanks, I'll do exactly that.

@MaxVernon does not

CLR is the way to go if you want true RegEx

@AndriyM i'd not be too concerned about log size if that's how large it needs to be. if you shrink it, you're going to incur the penalty of expansion (which will also affect VLF count)

7:18 PM

@swasheck So the size itself is not an issue then (with regard to performance), very well. As for the impact of log size growth (of which I learnt mainly thanks to being here and listening to clever people talk), that was the reason I put a stop to regular log shrinking that we used to do every week.

@AndriyM yeah. so you're probably going to have a lot of VLFs ... that will hurt restores, backups, and other log reuse (i believe) so you may want to look into handling that a la the tripp link. i'd not worry too much about how huge the log file is as long as it's as big as it needs to be. if it grows because of a deficiency in log management (backups, recovery model, etc.) then address the problem, not the symptom

@swasheck good advice. I think having an excessively large number of VLFs (assuming they are individually very small) would have a measurable impact on large transactions, or small transactions in a very busy system.

@AndriyM if you do truly need a large log, shrink it, then grow it back to the necessary size using a reasonably large growth size; that will reduce the VLF count by a lot.

this whole running for moderator thing is making me a lot more tolerant. I hope that is A Good Thing™

The problem for me is two-fold actually. I'm trying to understand why the logs are not truncated for space re-use (at least it seems they aren't), event though the DBs are in simple recovery and we backup them every night. And second, if it's a large VLF count, how to reduce the count.

active transactions?

A: Can I exchange partition between two table with partition with same name?

@AndriyM space will not be reused while there is a long-running-transaction, or if mirroring and the mirror is behind the server.

there are some other reasons that might be relevant. The full list is here: technet.microsoft.com/en-us/library/…

This also has an interesting edge-case: sqlskills.com/blogs/paul/…

@JackDouglas - any chance of a quick sanity check on this?

0

Have you seen this? https://community.oracle.com/thread/889338?start=0&tstart=0 It states you can only exchange partitions from a partitioned table to a non-partitioned table, or vice-versa. You'd likely need to temporarily exchange the partition into a temporary, non-partitioned, table, t...

Thanks @JackDouglas - I thought the use of "temporary" might be confusing.

7:39 PM

The DBs are not used at night (the working hours are something like 7am-7pm), but some applications are left open overnight. That's an avenue to explore.

Thanks Max Vernon. Could you please help me knowing why such functionality not there ? Please do not mind if my question is irreverent — Sameer Pradhan 23 mins ago

sigh

@MaxVernon the OPs use of the word 'backup' is confusing!

@JackDouglas yah, to say the least!

I wonder if Andriy is looking at the same system I'm looking at

8:01 PM

Well, mine is somewhere in California

And I don't want to look at it any more, to be honest, till the next Wednesday. A holiday is a holiday, after all.

8:25 PM

@ypercube zenx

zenx ?

There is no ypercube, only zenx

ah, the German influence on my pronunciation

8:40 PM

random pic of today:

try echo execute some_procedure(123,234) then echo "execute some_procedure(123,234)" and I think you will see why — Jack Douglas ♦ 2 mins ago

why don't people read (or post) the actual error message they get

syntax error near unexpected token `(' is pretty explicit

@JackDouglas people don't read anything

true

and have usually no clue how to debug even the simplest things

I like the way being a mod sometimes allows you to downvote a post twice even if you can't bring yourself to just delete it

8:47 PM

@AndriyM This will help you (blogs.msdn.com/b/blogdoezequiel/archive/2011/05/24/…). Also, that site has an excellent series - SQL Swiss Army Knife !

though tbh I'd prefer if all Heapers had that power

@ConcernedOfTunbridgeWells yep. Still on that number and got the text, thanks.

@JackDouglas how so? Do some close reasons still carry automatic downvotes from community?

@JackDouglas might be prudent (and actually helpful to future visitors) to add that error message into the question, no?

or just delete it, lol.

@MaxVernon connect item here for native Regex support. connect.microsoft.com/SQLServer/feedback/details/261342/… It is easy to deploy a homemade CLR function from SSDT but I've no idea why they haven't just added it as a built in function and we are stuck with the highly limited patindex syntax out the box.

@MartinSmith If it was Oracle, it would just be a (X thousand $) addon module

9:01 PM

@MartinSmith oh, and of course @AaronBertrand s comment on that connect item is priceless!

My new-and-improved wanna-be moderator comment language:

Ahhh thanks for clarifying that. Do you have a reference to that somewhere in the documentation or something? — Max Vernon 4 mins ago

@MaxVernon I didn't know you speak Oracle.

@ypercube I'm attempting to learn it. I figured I was right on that answer though, since switching a partition from one table to another table is probably not required very often.

> Posted by Microsoft on 20/08/2007 at 22:21: We are definitely going to consider adding this capability in the query language in a future release.

woah. I just upvoted a MongoDB question.

I guess they are still planning to do the consideration.

9:09 PM

@ypercube yah, that's classic, isn't it. 8 Years ago, and still planning.

@ypercube not in this case ;)

@JackDouglas I was trying to be funny. I know they have regex. And regex_replace

ah OK, sorry!

@ypercube I guess it definitely might be in SQL Server 2018 then.

@Kin Thanks!

9:18 PM

@MartinSmith if there is an auto-generated VLQ flag and you accept it, it gets a community user downvote and you can still add your own :)

@JackDouglas Ah, hadn't heard of that before.

@JackDouglas You VLQ flag and accept it just so you can DV twice?

mod fight. mod fight.

I'm not a mod @ypercube

:)

Aren't you on SO?

9:27 PM

Nope, I work for SE now which means no longer a mod

bluefeet♦ (moderator)

says your profile

diamond also means employee

current SO mods

ok, didn't know that

yup

you lost your mojo?

9:30 PM

I have a diamond on all sites now

@dezso i prefer mole to mojo

interesting read about StackOverflow (linked from the latest SO Blog):

medium.com/@johnslegers/…

@MaxVernon I'd suggest reading this as well - meta.stackoverflow.com/questions/298693/…

9:47 PM

I'd say a good way to prevent stupid people voting-to-close might be to make the Privileges for VtC scale up with the number of active users of the site. i.e. instead of 3,000 rep getting you VtC, it might be top 0.05% (on SO!)

@MaxVernon we wouldn't be able to keep up with the number of questions that SO gets daily

@bluefeet I thought the article smacked a little of someone with an "axe to burn". But he does have a slightly valid point.

I guess no matter how it goes, there's always going to be more noise than signal over there.

@MaxVernon part of the problem is most of his examples were fixed long ago and don't actually apply which Bill points out in his MSO answer

@bluefeet yah, reading that now.

@bluefeet that's an excellent article.

Since your question is about how to "echo" the number using php, I've voted to have your question moved over to StackOverflow, our site for professional and hobby programmers. — Max Vernon 28 secs ago

@swasheck I prefer molcajete

9:53 PM

well isnt that special. i'd like to try it

@swasheck It's delicious. If you would stop having children with birthdays on my SQLSaturday, I would take you to get some.

@mmarie i've stopped having children, but the ones that i've already had are intransigent re: birthdays

You don't have laws where you can give your children back? I know they exist in Nebraska. You just drop them off a t a church or fire station when you get tired of them.

Although I think a lady tried to drop her 13 year old off and they said that wasn't cool. So apparently you must get rid of them when they are younger.

that'd reflect poorly on the fact that we're trying to pick up another

No. You are just making room for a new one.

10:00 PM

yeowtch