The Heap™ – Consultancy ©®

« first day (768 days earlier) ← previous day next day → last day (4101 days later) »

12:04 AM

Interesting

Q: Statistics on number of users being post-banned?

I am interested in statistics on number of users getting post ban, for different SX sites. Is such information available? Is it possible to get such information from the Data Explorer? (Then it would be enough to show me how, I can make the SQL request myself.)

Mark Storey-Smith

Evening chappers

2 hours later…

rfusca

2:32 AM

@ConcernedOfTunbridgeWells lol, you literally can't go in without a kid

1 hour later…

Guillochon

3:50 AM

Ugh, now it just locked with 100% cpu...I wish I knew what was going on

1 hour later…

SQL Kiwi

5:19 AM

Uh oh

Q: SSMS produces error if query returns too many rows

We are having an issue with a server that we linked to our sql server 2012 instance. The server that we linked through an odbc or oledb connection is Pervasive SQL. Selecting from the linked server this way works as long as the result set is small: select * from linked_server.database..mytable...

sql-server database-design sql-server-2012 database-administration

Артём continues to have fun with his Pervasive linked server.

3 hours later…

ypercube

8:49 AM

The activity log (tab: Posts) shows more than 10 questions in the last 3 days, in 3 sites, SO, DBA and SF: stackexchange.com/users/40617/?tab=activity

ErikE

9:46 AM

@rfusca I have used that technique, too (surrogate nulls to compare nullity) but I really don't like it. :)

1 hour later…

ConcernedOfTunbridgeWells

10:49 AM

@rfusca Damn. I'd be like 'You know, it'd be so much better without all those squalling brats. When's the 18+ session?'

ypercube

11:05 AM

@ConcernedOfTunbridgeWells I see a business opportunity here. Kids to let.

ConcernedOfTunbridgeWells

11:46 AM

@ypercube To be honest, I'd rather have the Lego without the kids.

2 hours later…

rfusca

1:28 PM

@ConcernedOfTunbridgeWells actually, every once and awhile they do 'adult night' sessions...with beer

bluefeet

@SQLKiwi This has been cross- posted on SO

Q: what would cause a linked server to return a limited amount of data?

sql sql-server tsql sql-server-2012

rfusca

@ErikE well then you could always make a generic function that takes two values values and does the null compare logic internally

1 hour later…

ConcernedOfTunbridgeWells

2:44 PM

@rfusca Sounds more like it :D

Actually, I live just up the road from the Windsor Legoland. Maybe I should see if they do 'grown up' sessions :D

Phil

Legoland = AWESOME

2 hours later…

rfusca

4:40 PM

@ConcernedOfTunbridgeWells we didn't get to go to the lego place. they were sold out for the day. We went to World of Coke instead

ConcernedOfTunbridgeWells

4:50 PM

@rfusca Hunter S Thompson would be proud.

rfusca

@ConcernedOfTunbridgeWells eh?

ConcernedOfTunbridgeWells

5:12 PM

@rfusca Double entendre on 'Coke'

ypercube

5:32 PM

jcolebrand tweeted: traceroute 216.81.59.173

3 hours later…

ErikE

8:09 PM

@rfusca Yeah, that's going to be performant. :) Using a UDF is an even worse solution!

@ypercube Nice! :)

SQL Kiwi

@bluefeet Yes I saw (@ypercube mentioned it too)

Mark Storey-Smith

8:41 PM

Evening gents

Simon Righarts

8:56 PM

Mornin' lads

ConcernedOfTunbridgeWells

@MarkStorey-Smith Hello

@SimonRigharts Evening

ErikE

9:35 PM

@ypercube By the way, you get better results if you increase the hops! tracert -h 60 216.81.59.173 in DOS and traceroute -m 60 216.81.59.173 in unix.