The Heap™ – Consultancy ©® - 2016-02-05 (page 1 of 2)

« first day (1858 days earlier) ← previous day next day → last day (3003 days later) »

12:14 AM

Does anyone see anything terribly wrong with this blog post? j.mp/20cTXnW (thanks in advance for looking!)

12:38 AM

@MaxVernon I'd probably use char(8) instead of varchar(8), but if varchar seems better for you, perhaps it would be a good idea to correct the storage size (varchar(n) takes two more bytes for the string size).

And I thought "column" was not just SQL Server parlance but SQL parlance. Probably not a big deal, though, since the site is specifically about SQL Server.

12:58 AM

Thnks, @Andry - I'll make the change to char(8) since that makes more sense!

7 hours later…

8:08 AM

@PaulWhite dba.stackexchange.com/posts/128314/revisions

@ypercubeᵀᴹ nice

Mornin' awesome Heapers

Morning @Phil who is no longer Bill

8:26 AM

@dezso am I wrong here?

The 5% rule-of-thumb is useful for queries that need to use both the secondary index and lookups into the table. If the index is covering all the columns, as in the question, why is the index beneficial only for less than 5%? All the info is right there in the index, even if a whole index scan is needed. — ypercubeᵀᴹ 59 secs ago

9:04 AM

> even index-only scans must visit the underlying table to figure out if the rows to be returned are still visible to the current transaction

Interesting. I need to read some more about Postgres' MVCC implementation.

Daniel Hutmacher

9:17 AM

@MaxVernon Looks good. I suppose there are situations where you would want to make the calculated column PERSISTENT and place an index on it - you know, for the users. :)

@ypercubeᵀᴹ with index-only scans, the row visibility has to be checked against the table (this information is not stored in the index itself)

I used to live with the same misconception for quite a while

@DanielHutmacher @MaxVernon I would also be worried - add a warning - that the column will rollover at 100M rows

@dezso Yes, I am aware of that.

(all that means that in some cases an index-only scan is more expensive than a seqscan)

But making an index on all columns is based on that assumption.

And still I'm not 100% that the check against the table has to be done always. Does it?

@DanielHutmacher I suppose there might be rare cases where you'd want to index it, but I can't see much value in persisting it as well.

Daniel Hutmacher

9:24 AM

@MaxVernon, also, can '00'+CONVERT(char(8)..) generate leading spaces between the zeroes and the char under some ANSI_PADDING or other settings? Not messing with you, it's just that I don't work much with char.

@dezso I mean that the row visibility check is not the same as a full table scan. Is it?

Daniel Hutmacher

@PaulWhite, I thought you had to make a column persistent in order to index it. The use case I had in mind was, for instance, a dimension table in a datawarehouse, where users look up a specific invoice number as opposed to the key column.

@ypercubeᵀᴹ what do you mean by secondary there?

@dezso Any index basically. (except the table, whatever that is, heap or clustered)

@ypercubeᵀᴹ postgresql.org/docs/9.5/static/release-9-2.html says

> Allow queries to retrieve data only from indexes, avoiding heap access (index-only scans)

9:29 AM

@DanielHutmacher No that's not true. An imprecise (but deterministic) expression must be persisted to be indexed. A precise and deterministic column does not need to be persisted to be indexed.

so yes, I guess (cannot find an authoritative source) it means that the visibility map is checked

→ 1 message moved to Trashcan

and I am absolutely not sure how it is implemented - if done row by row, that might still be relatively expensive

> This feature is often called index-only scans. Heap access can be skipped for heap pages containing only tuples that are visible to all sessions, as reported by the visibility map; so the benefit applies mainly to mostly-static data. The visibility map was made crash-safe as a necessary part of implementing this feature.

and, after all, I agree :D

thanks for helping my brain to boot up

9:32 AM

@dezso: I don't know the details either. But I assumed from that that reading the visibility map doe snot mean reading the table (heap).

Daniel Hutmacher

@PaulWhite Didn't know that, thanks! :)

CREATE TABLE dbo.InvoiceHeader
(
    InvoiceHeaderID integer NOT NULL
        CONSTRAINT PK_InvoiceHeader
        PRIMARY KEY CLUSTERED
        IDENTITY(1,1),
    InvoiceNumber AS RIGHT('00000000' + CONVERT(CHAR(8), InvoiceHeaderID), 8),
    InvoiceDate date NOT NULL
        CONSTRAINT DF_InvoiceHeader_InvoiceDate
        DEFAULT (GETDATE()),
    CustomerNumber integer NOT NULL
);

CREATE NONCLUSTERED INDEX IX_dbo_InvoiceHeader__InvoiceNumber
ON dbo.InvoiceHeader (InvoiceNumber);

@DanielHutmacher ^ For example (fixing Max's mad comma placing).

@ypercubeᵀᴹ exactly - I have to look up the stuff, but I seem to remember that when the full-page visibility is not the case (as in your quote), the heap must be visited

@PaulWhite How does that work, under the hood? The column is only persisted in the index but not in the table?

@ypercubeᵀᴹ Exactly.

9:33 AM

@dezso I remember a question in the site about a query, let me see if I can find it

@dezso I'm going to read up on all this when I get time, just for my own interest, and to compare it with SQL Server's version store implementation.

@ypercubeᵀᴹ I had a discussion on it with jjanes, IIRC

@PaulWhite you should possibly start a blog about PostgreSQL ;)

@dezso Nah, not a real database.

you are just jealous

because we had the json features first ;)

Ooo yeah JSON is so awesome. It's like POWER (xml, xml). I love it.

Postgres might make a good hobby I suppose.

9:40 AM

Have you realized this question is about PostgreSQL? — dezso 58 secs ago

@PaulWhite is this NAA or not?

technically, it answers the question, but it is just soooooo wrong

@dezso VLQ. It is an answer, just a wrong one, as you say. That's the test for NAA.

@PaulWhite I still cannot grasp why an answer using a different RDBMS is still an answer

2 mins ago, by dezso

technically, it answers the question, but it is just soooooo wrong

^ clues ^

> it answers the question

@PaulWhite technically is a word used to say 'no'

:D

@dezso I took it to mean "technically".

9:47 AM

in my view, an answer answers the question if and only if it at least the keywords match the system

@dezso Then your view does not match the SE view, and your NAA flags will be declined :)

At least, by me :)

Daniel Hutmacher

@PaulWhite Interesting! Care to guess how this query plan would look? SELECT MIN(InvoiceNumber), MAX(InvoiceNumber) FROM dbo.InvoiceHeader;

user image

Isn't exactly this what the OP described above? — dezso 8 secs ago

@DanielHutmacher That was my guess yes.

Daniel Hutmacher

I would have guessed a single datastream with a Stream Aggregate.

9:49 AM

Please post the EXPLAIN (ANALYZE, BUFFERS) output, both without the index and with it. EXPLAIN only shows the planner estimates, which might be very different from reality. — dezso 4 mins ago

people...

@DanielHutmacher Nah that would mean reading every row. Better to read one row from each end of the index and cross join.

@PaulWhite nah, I'm not flagging these anymore, just DVing

(and have a very good excuse for not even thinking about being a mod ;)

@dezso That is a good option in many cases. Or flag as Other... and explain what you think should happen and why.

Daniel Hutmacher

@PaulWhite Yeah, I'm going to turn my brain on now and be quiet for a minute. :D

@DanielHutmacher Don't get me wrong: it's not obvious at all. You're not being dumb.

9:52 AM

@PaulWhite what happens if I write 'this is crap because RDBMS, should be deleted'?

Daniel Hutmacher

@PaulWhite Certainly no offense taken. It just feels very obvious when you explain it.

@dezso I would mark that as helpful, and perhaps mention VLQ would have been OK as well.

Other... flags are always an option if you need to explain a bit more about the reason something needs moderator attention.

@PaulWhite I don't seem to be able to flag as VLQ

at least on certain posts

is it disabled by age?

Daniel Hutmacher

@PaulWhite @MaxVernon, just tried it: using InvoiceNumber AS RIGHT('00000000' + CONVERT(CHAR(8), InvoiceHeaderID), 8) produces a padded string, to which the zeroes are added to the left (of the padding) and then the zeroes are trimmed away by the RIGHT() function. InvoiceHeaderID=10 generates InvoiceNumber=` 10`.

@DanielHutmacher @MaxVernon Ha ha so varchar was the right choice. Well spotted.

@dezso Not as far as I know. Example post?

Daniel Hutmacher

10:02 AM

SELECT RIGHT('00000000'+CAST(123 AS char(8)), 8)    -- No zero-padding
SELECT RIGHT('00000000'+CAST(123 AS varchar(8)), 8) -- Works
SELECT RIGHT('00000000'+CAST(123 AS char(20)), 8)   -- Blank
SELECT RIGHT('00000000'+CAST(123 AS char(4)), 8)    -- Works (for i<10000)

@DanielHutmacher BTW:

SELECT
    MIN(IH.InvoiceNumber),
    MAX(IH.InvoiceNumber)
FROM dbo.InvoiceHeader AS IH
WHERE
    IH.InvoiceNumber IS NOT NULL
GROUP BY ();

Daniel Hutmacher

What the..

user image

Daniel Hutmacher

Yep, both the Filters and Stream Aggregates are gone (not that I could tell what they did in the first place). Neat!

sqlblog.com/blogs/paul_white/archive/2012/03/12/…

Daniel Hutmacher

10:05 AM

That'll be today's lunch reading!

Grouping by the empty set just really appeals to me as a concept.

Daniel Hutmacher

Hahaha, just adding GROUP BY () removes the Stream Aggregate operator. That's just.. strange.

:)

Enjoy your lunch.

6

A: Which data type should I use to store a 11 digit number

I would suggest storing the number as a BIGINT, and simply displaying the number the way you want it. DECLARE @Num BIGINT; SET @Num = 2421402015; SELECT CONVERT(VARCHAR(11), REPLICATE('0', 11 - LEN(@Num))) + CONVERT(VARCHAR(11), @Num); As pointed out by Aaron Bertrand in his comment, it...

Strange Max used varchar in his answer, but changed to char for the blog post.

@PaulWhite My fault.

10 hours ago, by Andriy M

@MaxVernon I'd probably use char(8) instead of varchar(8), but if varchar seems better for you, perhaps it would be a good idea to correct the storage size (varchar(n) takes two more bytes for the string size).

@DanielHutmacher @MaxVernon @dezso ^^^ FYI.

@AndriyM Aha! Thanks. Storage size isn't really much of a concern if you're not storing the data, right? ;)

13

A: Let's justify the usefulness of the "very low quality" flag on answers

One of the reasons we're so strict about VLQ is that it's being used for Audits. It's still useful to keep around for answers, but it has a very high threshold (as you point out) it has to meet to being marked 'helpful' by a moderator. Should it be this way? Yes and no. We need a way to alert...

10:23 AM

@PaulWhite My point about the storage size was only meant to correct a mistake :)

@dezso Regarding VLQ flags ^^^

@AndriyM What mistake? Sorry, I'm not following you.

Use smaller words and speak slower :)

@PaulWhite In the first revision of his blog post Max used varchar(8) and he said there that it would take 8 bytes (vs 4 bytes for int). So I told him, if he meant to stick with varchar(8) (instead of my not entirely thought out suggestion to change it to char(8)), it would be better to correct the bit about the storage size.

@AndriyM Ah, thank you. I didn't read back far enough.

10:40 AM

@MaxVernon Sorry, Max, apparently I've let you down with my suggestion about char(8). I should have taken into account its implications on the result of your computed column expression. My bad.

Besides, turns out RIGHT() changes a char argument to varchar, anyway. I guess if my computed expression's outermost function is RIGHT and I want the result to be char, I should add type conversion after calling RIGHT.

11:05 AM

3

A: How to get the timestamp column in only milliseconds from PostgreSQL?

--EDIT-- I've discovered this (see below) is basically wrong. See How do I get the current unix timestamp from PostgreSQL? for the source of my confusion... --END EDIT-- Posting as an answer because it won't work as a comment. testbed: create role stack; grant stack to dba; create schema aut...

and the other surviving posts there

@PaulWhite what do you mean? 'Enjoy your lunch'?

1 hour ago, by Daniel Hutmacher

That'll be today's lunch reading!

@dezso Apparently VLQ is not available if the post has a positive score.

@PaulWhite that explains a lot, yes

Documented in the Flag Posts privilege.

> 5. Very low quality (i.e. no amount of editing can salvage the post) (only posts scoring 0 or less)

I imagine Jack would be upset if you flagged that VLQ :)

@PaulWhite he? never

otherwise, I was to check if I can VLQ flag something, and that post was open

@PaulWhite not too fast, but the bug report is there:

0

Q: Badge tracker stuck?

I still have some work to do before reaching the PostgreSQL gold badge, so I chose it as the one for tracking. Unfortunately, it seems to be stuck. See the screenshot below: I am not posting about anything else than Postgres (except comments), don't get many upvotes on answers on other topic...

bug badges badge-tracking

11:25 AM

Cool.

Stupid feed bot.

11:49 AM

PS, I love the XML approach to comma-separated parameter values. — Daniel Hutmacher 4 mins ago

Conclusive proof @DanielHutmacher has gone mad.

Daniel Hutmacher

@PaulWhite Not a recent development, I'm afraid. :)

:-D

12:39 PM

from the side bar

@AshleyNunn if you feel like you need one of these, you might wanna start going to meetings. — DickieBoy yesterday

@TomV MUST. NOT. WRITE. SARCASTIC. ANSWER

@Phil Why not?

ConcernedOfTunbridgeWells

1:07 PM

Seen on the interwebs today.
How not to do an infographic.

user image

And now for some eyebleach

i.imgur.com/PD78HIJ.gifv

@ConcernedOfTunbridgeWells What is that supposed to be informative about?

ConcernedOfTunbridgeWells

@TomV Relative size of the economy by region

Nothing to do with goatse.

1:22 PM

@DanielHutmacher that's a really good question. Will investigate.

@DanielHutmacher d'oh! I guess I should've tried that first - lesson learnt! :-)

1:47 PM

@ConcernedOfTunbridgeWells that's most unfortunate. make it stop!

:-)

+1, @billinkc for dba.stackexchange.com/a/128368/10832 although the "GIVE IT A TRY!!!" needs to be larger.

I've never heard of a trigger that wasn't disabled not firing. I don't do a lot with SSIS, but what difference can that make to a trigger.

Also iPhone app doesn't seem to support a way to copy a direct link to a comment

@AaronBertrand presumably you're aware the link in your previous comment is incorrect.

2:08 PM

Just some text that should make the horrible image move out of sight
one more

there

That

isn't

a

bad

idea

Damn this monitor being big

@MaxVernon Thanks. I mostly looked at it to see if you can disable triggers as you can elsewhere

Well, that and I had an opportunity to troll

@billinkc I love it.

@MaxVernon well that's even weirder, I hit copy on the headline of this question:

Not about records storage but - the MEMORY engine (used for smaller temporary tables during query execution) does not support variable length so it has to allocate equivalent to CHAR(5000) if your query needs to store such column in a temp table - the table gets big fast and then spills to disk (transforming to temporary MyISAM) which can make your query slower. — jkavalik 7 hours ago

2:23 PM

hey @DanielHutmacher - thanks for looking at my blog post from yesterday - I appreciate the input!

Daniel Hutmacher

@MaxVernon No problem, I learned a thing or two in the process! :)

@AaronBertrand that sounds like craziness. The more I hear about MySQL the more I love that I'm not being forced to use it.

2:38 PM

at risk of poking the tag-edit-Gods, I've created the sp-askbrent tag and updated the wiki for it.

I fear @AaronBertrand's head is going to explode on this

@MaxVernon I was just reading that question

I've added a tag for sp_AskBrent — Max Vernon 9 mins ago

Daniel Hutmacher

@MaxVernon I think the OP beat him to it. :)

@MaxVernon Seems slightly backwards to me to create the tag and wiki before Brent replies to that. Unless you think the tag will be useful to the community at large? My understanding of sp-blitz and sp-blitzindex is that they primarily exist because BOU use it to identify support questions.

@PaulWhite I dunno - I saw a question about the proc, and thought why not create the tag for it.

hence my "risk of poking the tag-edit-Gods" comment ;-)

> [ Just what i was looking for! Thank you – Tony Gallone 1 min ago ](dba.stackexchange.com/questions/128405/…)

2:48 PM

@MaxVernon Oh well. I'll leave the wiki reject/approval to others until/unless Brent expresses an opinion.

@PaulWhite I'm not upset either way -it's not like I'm invested in the tag edit :-) or BOU, for that matter

@MaxVernon Sorry, I assumed because you asked in here you had put some extra thought into it. if it's just a standard tag creation, I'm not going to worry about it.

@PaulWhite no, I just wanted to "heads-up" you.

Ok.

@PaulWhite "mad"? eh? I call creating an index named "i" mad! lol!

2:55 PM

@MaxVernon Fixed it for you. I don't use i as an index name in production. Or mad comment placement for that matter.

2

@PaulWhite I'm loving this, btw

this empty set thing is so very strange. just not obvious at all.

Yep. Scalar aggregation was not well-defined at the beginning.

Wow, great attitude

@aaron betrand tl;dr — Tony Gallone 23 secs ago

This is the kind of person you hope effs something up so bad they get fired

3:11 PM

@AaronBertrand OP is more of a dickhead than me, and that takes effort

5

Clickety

3:25 PM

@TonyGallone - you may want to read "How to win friends and influence enemies" by Dale Carnegie. Or on the other hand, "tl;dr" — Max Vernon 1 min ago

user image

^^^ for posterity before @PaulWhite cleans up

my apologies to @JamesAnderson - my screen didn't have enough room for the first comment!

3:39 PM

Of course you can - just as you can build any command dynamically in bash, you can also do a psql -h whereever -U whoever -c "SELECT magic_function($THIS, $THAT)" and change the two bash variables as you wish. However, the suggestions above about the general approach should be considered, I think. — dezso Nov 26 '15 at 9:21

@dezso That question would be better IMO if that were an answer.

@MaxVernon I didn't remove any comments there.

@PaulWhite ahhh, I was expecting you would at some point.

I cleaned up. Meanwhile getting berated in e-mail because I refuse to believe that 10.51.2500.0 is materially different from 10.50.2500.0.

@AaronBertrand fun fun

@MaxVernon Haha no worries.

So if he comes back with the question: Why do I have so many VLFs, do we help or tl;dr?

3:57 PM

@JamesAnderson I'm thinking he's going to have quite a few issues with that. VLFs are a real pain in the ass if you don't know about them. I wonder how I know that. facepalm.

@MaxVernon I would hate to see the log files at the first place I worked. You live and learn

This is why I have posted the message to get some ideas on what might be happening. The one thing I notice is a taxing of network and disk when this validation running. — user1013388 1 min ago

I should just ask for an account on their network, probably be faster

Classy

user image

jeez

@AaronBertrand wow. some people's kids.

@AaronBertrand I hate how the .51 version numbers make it practically impossible to update to SP2.

4:08 PM

Wait, that's sarcasm, right?

yah, although you do have to find the correct SP2 binaries... and that can be confusing for the uninitiated.

i didn't know

GDR vs QFE

I liked your post on dealing with the leading 0 problem btw

@AaronBertrand He's from Leeds. I'd expect nothing less...

4:16 PM

thanks, @JamesLupolt I appreciate it

(no offence to anyone else here from Leeds...)

@MarkSinkinson lol, if you're from Leeds that's a compliment.

@PaulWhite I already prepared myself to answer there

totally forgot it since November

> This account is temporarily suspended to cool down. The suspension period ends in 7 days.

uk.linkedin.com/in/tony-gallone-288424a7

ripped a bunch of old CDs onto my pc yesterday. It's my way of giving the finger to the man.

4:23 PM

Such a young pup

feeling sorry for Claritas.

"So when you Think I.T. Think Clearly, Think Claritas."

was this too harsh?

@bazJaz sorry, I'm disengaging from this conversation, we are going in circles. "You are missing a table", "how do I add it?", "I don't know how your tables relate between each other", "here is my code", "it fails for the same reason, you are missing a table", "how do I add it?" — Lamak 4 mins ago

There's a hole in the bucket, dear bazJaz, dear bazJaz

@Lamak No.

Daniel Hutmacher

@Lamak I.. never mind. :)

4:31 PM

@PaulWhite good, I was starting to get frustrated

@Lamak when? or if?

@Lamak, okey, when problem was solved I am show sql code. Thx — bazJaz 5 mins ago

your guess is as good as mine :-)

please point me to a post (the best one) that describes why RBAR is usually a bad idea

@Lamak @AaronBertrand I'm in an OK mood

@bazJaz please stop wasting everybody's time and include full table definitions, all of your query and some sample data as insert statements. Please help us help you — Tom V 40 secs ago

@TomV I thought it was a good mood ;-)

4:40 PM

Good luck with that @TomV

@PaulWhite I won't let this turn into chat though

@TomV It's SO - I don't care :)

I do, I'm not ending up in chat with this one

:)

I don't care for the user or the question, but I do care about my sanity

4:43 PM

@TomV That's easy, just close that page :)

@AndriyM I guess it's the teacher in me trying to help an individual learn stuff, but it's not a question I will follow up on

those coaching certifications from way back when I played bball left an in-erasable mark i suppose

Yikes, Tableau's stock lost half its value today

uk.businessinsider.com/…

They were probably measuring the stock value with NOLOCK.

4

negative earnings per share and a N/A price to earnings, maybe they were extremely overvalued by the market

to be honest I don't see them selling anything around here

qlikview has some marketshare but tableau...

this isn't going anywhere either

That doesn't make much sense, so you have multiple records for the same itemid in your sellableitemversion table? What are you tracking in your availability table? versions or items? — Tom V 19 secs ago

This is my shocked face.

4:53 PM

I actually have a question about NOLOCK. Have a report that deadlocks once in a while - will a magical NOLOCK in the report query fix it?

@Phil Does the report need to be correct?

2

@Phil Most likely, yes. But the results may be different/inconsistent/flat-out wrong, corrupt - or the query may fail with an error - if the data can change while the query is running (which seems evident if you're getting deadlocks).

Snapshot isolation can be a better choice for reporting. Point-in-time view of the committed data.

RCSI if the reports are single statements.

@TomV That doesn't matter

@Phil An incorrect report is something for the application/development team? :)

I'd use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED to avoid looking like a n00b though.

5:01 PM

@dezso this is my fav.. not sure it's the best though

Master Database

0

Q: Tag for Ola Hallengren's scripts?

While I have enough rep to create a new tag, I figured this one was worth asking the community about first before creating it. There are plenty of questions regarding Ola Hallengren's solution for database maintenance. I was wondering if it makes sense to provide a tag ola-hallengren (or somethi...

feature-request retag-request

@OlaHallengren ^^^

I'm voting to close this question as off-topic because it has nothing to do with database administration — Tom V 16 secs ago

@TomV I think the OP is asking for a database configuration change that will make his problem go away.

listing htaccess or wp plugin as options?

anyway, dinner time, let democracy and voting decide on it :)

5:11 PM

> mitigated this by limiting the number of MySQL connection and it partially works,

That's fighting the symptom, not the problem

maybe the VtC reason is too harsh, but his issue isn't his database

I've got a self-hosted WordPress site, and I'd love to know how to setup MySQL for it so that the sites are as fast as possible, because right now they are dog slow.

even if I enable caching, etc in WordPress

@MaxVernon hmm, typed too soon, I haven't seen much issues when they manage it

but those were small sites for friends with extremely low traffic

@TomV @MaxVernon It definitely needs clarification if it is going to stay here. On hold pending that.

5:31 PM

@Marian thanks, it's the one I know, too

and being linked in (@PaulWhite)

0

A: PostgreSQL - is it possible to use a plpgsql function in a bash script?

As you were hinted in comments above, your RBAR approach might be very inefficient. Consider the suggestions there. Also, I am not going into details about the different approaches of UPSERT, as it is a very broad topic, especially when one wants to do concurrency-safe. PostgreSQL 9.5 helps a ...

@dezso Thanks.

Daniel Hutmacher

@MaxVernon I use wordpress.com (the free service plus a few paid add-ons, including "no ads") for my blog and it absolutely flies, plus, somebody else makes sure I have the most recent updates installed.

lol, I'm on the other end of that stick here:

wordpress.stackexchange.com/questions/216824/…

5:46 PM

404.

although, you'd need to be a 10k+ WordPress user to see it.

sorry

image incoming

user image

the link was to the last comment

@DanielHutmacher I was thinking of doing that but I can't stand the idea of putting my data in someone else's hands. I guess I have "trust issues".

funny though, because I did host stuff for lots of others over the years.

as a Canadian who likes the great outdoors, this is just weird:

9

Q: Why is it prohibited to sleep in a tent?

In many European countries like Germany, it's prohibited to sleep in the great outdoors with a tent. While I understand that downright camps are a problem due to littering, fire etc., I don't get why a tent is a problem. Like what's the difference anyway if one is sleeping in the open air and in...

Daniel Hutmacher

6:24 PM

@MaxVernon I usually reserve the (in my opinion pretty harsh) "google it" response for people who obviously have put no effort into researching their problem.

@DanielHutmacher yah, I'm pretty certain they see a ton'o'crap questions on WordPress Development

which might explain it

Daniel Hutmacher

@MaxVernon I guess. :)

If I come up with a good repeatable way of fixing it, I might undelete and self-answer.

@MaxVernon is the question or the answers weird?

@ypercubeᵀᴹ the fact that it would be illegal to sleep in a tent.

6:31 PM

@MaxVernon It's more of a gery area I think, at least in Greece.

And the answer depnds not only on the county but the location, too.

and if you don't get caught ;-)

I mean, you don't expect to go and raise a tent in the middle or Times Square in New York, can you?

in North America you can sleep in a tent anywhere on public property if you like.

you might get harrassed

Can you really raise a tent in the middle of Times Square without getting arrested?

but I don't think it's illegal

6:34 PM

Anyway, from my experience in Greek islands, it is usually allowed to camp near the seaside

but not in very busy locations.

that's how they did the Occupy Wall Street stuff

I tried it once in Paros, right 200-300m from the main harbour.

I was awaken around 6:00 by policemen or loacl county officers, not sure.

I wasn't arrested, no one was.

They just wanted the seaside empty of sleeping people or tents as it was the busiest seaside of the island.

Everywhere else on the island, no one would bother.

I'm guessing they might also had some pressure from local hotel owners.

here? google.com/maps/place/…

looks cool

It's nice. Usually very windy. Surfers paradise.

While this is all true, it does not really answer the question - why? Why do authorities want to prevent me from leaving no sign behind, but still sleeping in a forest, for example? — dezso 19 secs ago

6:47 PM

Keeps the gypsies away

@billinkc dem dam gypoes. urbandictionary.com/define.php?term=gypsy

^^^ probably not safe for work, btw

@dezso - this has to be about how the guid is encapsulated, no? dba.stackexchange.com/q/128431/10832

like does it need quotes around it or something?

or { and } ?

@PaulWhite your wording is much better than mine ;)

@dezso I believe most land is "owned" by somebody and thus you need permission, which you don't have by default (not saying it makes that much sense but I guess that's what's happening)

@MaxVernon single quotes. horse answered.

thank you!

7:06 PM

0

Q: Add autoincrement to existing PK

I created a table in a DB that already exists in another DB. It was initially populated with the old DB data. The table's PK had to receive the values that already exist on those records, so it couldn't be autoincrement. Now I need the new table to have its PK as autoincrement. But how can I do ...

sql-server primary-key auto-increment identity

Do we have a dup for this?

I found one in SO: stackoverflow.com/questions/1049210/…

but not here

@MaxVernon strange that it's not explicitly documented

@ypercubeᵀᴹ I posted a crap answer to a crap question but don't see how it needs more explanation and I didn't want to answer in a comment

@TomV it sounds to me like the OP wants to add the IDENTITY() property to an existing primary key column.

which isn't so easy

try it in the SSMS GUI interface, then "script it" to see what SSMS will do. It's not pretty.

dba.stackexchange.com/questions/114608/… has a good example of how to do that in reverse, i.e. removing the identity property. Adding the identity property can be accomplished the same way.

8

Q: Why is removing the Identity property on a column not supported

I have read that after SQL Server 2000, the ability to "un-identity" an identity column was removed. And that this was "By Design" (not just a missing feature). Here is an example I found on a blog. It involves updating the system tables. (And that ability was removed after SQL Server 2000.) I...

sql-server identity

@MaxVernon I read it as an existing table with imported data

7:18 PM

@PaulWhite great minds and all that!

but I didn't realise it would be that hard to add it afterwards, thanks

That might be the same link but I wanted to try copy paste in the new chat app

@TomV yes, but you think performant is a word :-)

@PaulWhite ahhh well all is forgiven then. ;-)

@MaxVernon performant is a word, it just means different things on both sides of the pond

It works, but is still painful. I had to open the post in a browser page to get the link. Couldn't seem to get it in the stack exchange app

7:21 PM

@TomV I'm just teasing.

@TomV So proud

@MaxVernon so am I

oh hey I just realized it's friday. nice.

yes and soccer is starting here, bbl

Friday - Rebecca Black - Official Music Video

7:22 PM

Saturday morning, Waitangi day here

Waitangi? Is that some kind of nasty ailment?

Does Canada have a national/founding day?

@PaulWhite yupo. Canada Day. Presumably its a similar idea?

Huh

wait, did you just lmgtfy me?

7:25 PM

No

ahhh still testing the app no doubt

It's a wiki shortcut that one boxes

ahhhh cooool

something you don't want to eat in public?

Waitangi Day (named after Waitangi, where the Treaty of Waitangi was signed) commemorates a significant day in the history of New Zealand. It is a public holiday held each year on 6 February to celebrate the signing of the Treaty of Waitangi, New Zealand's founding document, on that date in 1840. == History == The Treaty of Waitangi was signed on 6 February 1840, in a marquee in the grounds of James Busby's house (now known as the Treaty house) at Waitangi in the Bay of Islands. The Treaty made New Zealand a part of the British Empire, guaranteed Māori rights to their land and gave Māori the rights...

No idea why that didn't work before.

@MaxVernon So, no it's not.

I really need to visit NZ - you have such cool stuff.

Master Database

7:29 PM

0

Q: Do we need LaTex here?

I am quite new here, I noticed that there is not LaTex here in Database Administrators, is there any reason for that? or maybe it will be better if we could use LaTex. e.g to write stuff like that: Thanks

discussion feature-request

we don't need no stickin' latex!

Daniel Hutmacher

7:43 PM

@PaulWhite Happy Waitangi day! I actually think I've visited Waitangi - pretty far up on the North Island, with a huge red traditional Maori ship, if memory serves?

@DanielHutmacher Not been there myself - it's a trek from here!

@TomV Sorry Tom my comment wasn't meant to encourage you to delete your answer. By all means, reinstate it - you might be right. We might be misreading the question.

@MaxVernon Tom did the right thing by posting an answer. You posted a perfectly good answer in a comment. I've converted it to a CW answer. If you add your own proper answer, I'll delete it - unless other people have improved it in the meantime.

@PaulWhite I'm fine with it the way it is. I didn't post that as an answer since it felt a bit cheap to just answer with a link.

I contemplated closing it as a dupe with my gold hammer but it's not quite the same question as the one with Aaron's answer.

7:59 PM

@MaxVernon It's a perfectly adequate answer as it is IMO. Answers can be improved beyond adequate, of course. I decided the same way re: the dupe.

« first day (1858 days earlier) ← previous day next day → last day (3003 days later) »

Transcript for

Feb '165

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile