The Heap™ – Consultancy ©®

7:10 AM

am I missing something or is this just a typo

dba.stackexchange.com/questions/tagged/ssql-server-2012

And I can't seem to figure out how to onebox the tag :)

@TomV edited the q. I think the tag will go away on itself, now that there is no question on it.

@ypercubeᵀᴹ That's what I was planning to but I saw Paul already edited it so I figured I might have missed something

@TomV Oh, didn't notice that the edit was Paul's!

Andriy M

Apparently there's a version called Super SQL Server 2012 that Paul is the exclusive owner of, and he must have forgotten that no-one else knew about it when creating the new tag.

dba.stackexchange.com/posts/133599/revisions

(^^^ Revisions link, now that the previous link does not show the question)

7:42 AM

@TomV I don't think you can. The closest is [ tag: xxx ] syntax i.e. ssql-server-2012

And yes, it will be deleted within 24 hours automatically now it has no questions.

@ypercubeᵀᴹ Oops! Ha ha ha.

8:03 AM

I was checking the new tags, I plan to abuse my new privilege

2 hours later…

Phil

10:11 AM

Review queue is big if anyone is bored

2 hours later…

Phil

12:19 PM

Quiet in here today

@Phil Has been all week

James Anderson

12:35 PM

Anyone going to Bits next week?

2 hours later…

3:04 PM

hey

Hay's for horses but grass is cheaper

lol

i'll take some grass

but i have a question

i'm looking to replace LIKE '%stuff%' with full text search on sql server 2014

@SteveG they aren't the same at all

it looks like Contains(columnName, '"stuffToSearchFor*"') only matches trailing wildcards

is there something else I can use to help increase the performance, or am i pretty much stuck with LIKE and it's full table scan?

@Lamak yeah FTS does a ton of stuff, but I was kind of hoping i could dumb it down to be a more performant LIKE, maybe i'm a fool, who knows

hello

Hello everyone, would you consider amazon.com/MySQL-Stored-Procedure-Programming-Harrison/dp/… as a good reference book for stored procedures?

3:10 PM

okay, well thanks

@SteveG thing to understand is that full text looks for words

well, the stuff i'm searching for are word like, as in they can be broken up by natural barriers like spaces and stuff

which is why i thought i could get away with it

but, maybe thats not always the case

I know Swasheck had good things to say about Lucene but that's certainly more than you're asking about

word like?

yeah, never mind that, what i said was completely wrong

Mark Sinkinson

3:15 PM

@hello You won't find any MySQL people in here

Well...not normally....

anyway,thanks for the help, have a good friday :D

@MarkSinkinson maybe he won't find people that use mysql here, but if we could think about "mysql" as an adjective, when saying "mysql people" @billinkc comes to mind

@SteveG just in case, Postgres has GIN and GIST indexes that can be used for text search - and can even be customised.

@hello judging form the comments only, seems like ok.

3:32 PM

@Lamak Son, don't make me blow up another volcano. I'll eventually get you

Q: Stack Overflow vs Database Adminstrators

@billinkc poor dudes, first they are named "volcano" and then they get to...well

did someone see this?

I was just about to ask a database related question (involving translations between SQL and MySQL) when I remembered that there's a whole site in the Stack Exchange network dedicated to databases! But then I thought to myself, "Hmm... Which site should I put my database question on?" So I check...

> So I checked out the hottest questions on Database Administrators and realized that these are questions that could have been easily (and successfully) asked on Stack Overflow

Phil

3:48 PM

"Ask on DBA.se, because we are awesome"

Mark Sinkinson

Our 'Hot Questions' section isn't particularly hot... More lukewarm...

they should take a look at the top questions instead

2 hours later…

6:08 PM

@Lamak ohhhh snap this is going to result in some sort of turf war.

I must not troll the kangaroo herder..

Too late!

Q: How to find the AD user that logged in to SQL Server using SQL Login

I'm trying not to insult the people who ask/answer on SO

Am I the only one who has no clue what this guy is asking?

Some users are logging into Database Servers locally and open SSMS and login to sql server using SQL Login to run sql queries. How to find the AD user that logged in to SQL Server using SQL Login on Local database server using SSMS.

audit logins

6:30 PM

@Zane Do you find the question to not show any research effort, be unclear, or not useful?

Because there's a button for that.

23 hours ago, by Paul White

I cannot stress how important votes on questions and answers are, both up and down.

@PaulWhite Well I had a beer or two at lunch so I wanted to make sure it wasn't just me.

6:49 PM

@Zane Fair enough. It's not just you :)

Are you OK? This is not a programming question. Contact webmaster of the site. — FLICKER 7 mins ago

bwahahahaha

"Are you ok?" Absolutely killed me.

poof

bluefeet

stomped by blue feet

Unfortunate that a brilliant comment had to suffer as well.

7:06 PM

@bluefeet Oh so the CMs are still alive then :)

bluefeet

@PaulWhite yeah we're around.

Not dead yet

4 hours later…