The Heap™ – Consultancy ©®

« first day (2094 days earlier) ← previous day next day → last day (2776 days later) »

2:27 AM

@AndriyM I am trying to find a conversation you and I had some time ago about casing data type names. I remember that it encouraged me to start using DECLARE @foo int instead of DECLARE @foo INT, in order to match what is in sys.types. On no system (binary database or binary instance) can I get that to fail, but I'm certain there was a case where it can (other than the obvious SELECT FROM sys.types WHERE name = N'INT').

Can you (or whoever that was with, if my memory is indeed that terrible) refresh my memory?

Aaron Bertrand

2:52 AM

(For background, I'm writing an #EntryLevel blog post about why I've started to be more careful and defensive in my code, and recently switched from INT to int etc.)

3 hours later…

Andriy M

5:25 AM

@AaronBertrand Don't remember it, although I do prefer int to INT. Will take a look anyway, my memory is far from ideal too.

Paul White

@AaronBertrand Might have been Erland on the MVP DL. That's from memory, I haven't checked the archive.

1 hour later…

Andriy M

6:38 AM

@AaronBertrand Incidentally, do you go DECLARE @var TABLE or DECLARE @var table? I've mostly used the former, but given the latter a brief try as well, as it seemed more consistent with DECLARE @var int. For some reason, it didn't feel right to me.

3 hours later…

James Anderson

9:51 AM

As stated in my answer here my knowledge on collations needs some attention but is this answer OK or should it be removed for some reason I am unaware of?

And here is the question dba.stackexchange.com/questions/150849/…

2 hours later…

Paul White

11:58 AM

@AndriyM I prefer DECLARE @var AS table. I'm inconsistent there because I don't use AS with other types.

Euphoria

hey everyone, I've just setup myself up with sqlexpress 2016 and I wanted to be able to connect to it via "localhost". There's not a lot of resources out there online, I was wondering if someone has done this recently and could point me in the right direction or to a resource they read to configure it.

Note* within sql server config manager - I enabled the tcp/ip protocol and then created an alias for Native client 11.0

Resolved: I wasn't setting the default port in the sql configuration manager, even though I had set it in the alias it wasn't set in the protocol properties under ip-addresses

Aaron Bertrand

12:39 PM

I use TABLE there. Slightly different context - that's not a "type" per se (e.g. there is no row in sys.types for local table variable) and I think it would drive me batty to see things like this in the same code:

DECLARE @foo table(id int); CREATE TABLE dbo.foo(id int);

@PaulWhite Thanks, I've searched the archives, not finding any success so far

Andriy M

@PaulWhite Ah yes, using AS in variable declarations (I mean in general, not just with tables) is another "exotic" thing for me. But then at first I hardly ever used AS at all, my switch to using (at least, trying to use) it consistently is relatively recent.

Aaron Bertrand

Totally just my personal convention but I only use AS for table aliases

I can't stand them for column aliases, and never found a reason to add them to variable declarations (it just seemed to make the front-loaded portion of the code bulkier)

Andriy M

@AaronBertrand But of course! No space before the opening bracket? Madness!

Aaron Bertrand

@AndriyM Well in my real code there would be a carriage return, not a space :-)

Max Vernon

1:05 PM

Max Vernon

1:22 PM

generated on hipsterlogogenerator.com by some filthy hipster

James Lupolt

1:43 PM

New Sybase update has a workload analysis and replay tool: help.sap.com/saphelp_ase1602/helpdata/en/ae/…

Also UDFs and table variables

Prepare that bankruptcy filing, Oracle and Microsoft

gbn

welcome to year 2000 Sybase!

did not know SAP owned them though

dezso

@gbn ah, you are still alive

Lamak

2:00 PM

@dezso well, at least he was until your comment

Andriy M

@Lamak Nothing suggested @dezso's comment could do any harm to him until your comment.

Lamak

good point

gbn

I have the window open for days, lurk, but then close ti and forget for months

or I am actually dead and I did not get the memo

Lamak

@gbn I mean, you no longer have a mullet, so what's the point anyway

gbn

I have a man bun now. It's all the rage

Lamak

2:11 PM

ah, nice, good to know

gbn

it's what the young people do, trying to keep up

Lamak

pfft, young people

Tom V

@ypercubeᵀᴹ The plan has been added, proceed at your own risk though. Maybe we should reopen the question only to close it again as tip of the iceberg

billinkc

2:33 PM

@gbn Manbun? That's so 2015. The new rage is the HeHive

gbn

2:45 PM

I'll discuss with Mrs gbn

Phil

3:10 PM

@gbn Yeah, SAP HANA is based on the Sybase codebase, I think

ypercubeᵀᴹ

@JamesLupolt Ah, that's why Oracle is adding CTEs to MySQL. that explains it

billinkc

4:06 PM

Aaron or Paul you on this MVP skype call?

dezso

4:34 PM

I'd rather look into devs testing on this DB or similar. Turn on logging all statements, and the next time this occurs, find the culprit. — dezso 1 min ago

Mr. Occam at work, maybe

dezso

4:55 PM

@PaulWhite thanks for the edit, I missed this bit

Paul White

@dezso np

@billinkc Nope

billinkc

Managed to get a dialin number. It's meh

Paul White

@billinkc Thanks that's good to know.

Lamak

@billinkc obviously...if you managed to get a number

billinkc

@Lamak You wouldn't believe how many girls misremembered their numbers when I was younger...

Lamak

5:01 PM

I think I would believe it

bluefeet

@billinkc 867-5309

Paul White

I found that as well! You'd think they'd practice more.

billinkc

Indeed

Tom V

5:37 PM

@billinkc You had no cellphones back then I presume? You just say "I'll let yours ring twice so you have my number too"

billinkc

@TomV Coconuts connected by strings

Tom V

@billinkc I was expecting smoke signals so that's not too bad

2 hours later…

swasheck

7:36 PM

so what exactly is the "fix" for this? support.microsoft.com/en-us/kb/3181444

are they propagating stats now?

Lamak

@swasheck I assume so

swasheck

me too

but you know what they say about assuming

you make an ass out of you and @billinkc

Lamak

@swasheck ah, that saying

swasheck

and its corollary ... "why do we care? @billinkc does a good enough job making an ass of himself!"

(started that thought differently)

Lamak

@swasheck I agree with the sentiment, but I'm not sure if I would ever say that @billinkc does a good job at anything

ypercubeᵀᴹ

7:42 PM

Q: How does the Booze-Rat fuel its defensive mechanism?

Of all the creatures in Hatjörn's dominion, there is none as peculiar as the Murinae Spirita, the mean booze-rat. A vermin so resilient that has developed the most wondrous means of defence and thus survival. Excerpt from Hjårdan Animaliæ Welcome to the Most Ingenious Questions You Never ...

Lamak

@ypercubeᵀᴹ did you post that because we were talking about @billinkc?

I mean, booze-rat sounds like a cool nickname for him

ypercubeᵀᴹ

@Lamak maybe subconsciously

ypercubeᵀᴹ

8:02 PM

Q: Can Customs make me go back to return my electronic equipment or is it a scam?

My fiance just returned home from Nigeria and he has been detained 4 days at Reagan International airport because he returned with electronic sonar hardware he used for his job. Customs has detained him at Reagan International Airport because he only has $2000 of the full $4500 they are requiring...

usa customs-and-immigration us-citizens paperwork scams

@Lamak don't ask me who I was thinking of ;)

dezso

Friend thank you. I changed the memory sticks from the server, and it is looking like pretty good now, but i am still testing it. Thanks! — 777Anon 1 hour ago

Now that is highly unlikely to have such an effect

ypercubeᵀᴹ

@dezso Why?

The problem is surely weird.

Faulty hardware, especially memory, might be a reasonable explanation

dezso

@ypercubeᵀᴹ cannot imagine how a bad memory module has no other effect than index corruption

ypercubeᵀᴹ

@dezso It may have caused other problems, too.

But for queries returning inconsistent results, faulty memory sounds like a good explanation.

Lamak

@ypercubeᵀᴹ lol

dezso

8:11 PM

@ypercubeᵀᴹ well, right, just they did not seem to be relevant

ypercubeᵀᴹ

But of course it might have causes other issues, too. Which they haven't noticed.

Taking all their backups and restoring in anothe rmachine and then comparing them, might reveal further corruption.

3 hours later…

A_V

11:37 PM

hello

anyone could hop in and give me a quick heads with what I'm missing on that convert function ?

got a char(24) field that contains date values in text

trying to convert it like such to datetime :
SELECT convert(datetime,The_COLUMN,121)

data looks like such : 2016-09-27 15:50:20.100

Andriy M

@A_V What's the issue?

A_V

trying to convert datetime and I'm failing

according to that documentation w3schools.com/sql/func_convert.asp

converting with "style" 121 should work fine right ?

Andriy M

Failing in what way? Your code works for me, for instance

A_V

Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.

Andriy M

data.stackexchange.com/dba/query/546146

A_V

11:46 PM

wahaat that's a thing

Andriy M

updated the link

That's a demo script illustrating that your code works

A_V

yeah that's the thing... it should be working fine

Andriy M

Perhaps the actual strings in the column contain some rogue characters that break the conversion?

mariomenjr

Hi!

which would be the best Universal DB client out there?

A_V

I just copy-pasted the data from the column into the query window and did this:
select CONVERT(datetime,'2016-09-27 15:50:15.093',121)
it works loll

@mariomenjr by universal DB client you mean a program that lets you log into a database and explore objects ?

though, if I replace the column name it still fails me

mariomenjr

11:52 PM

@A_V yes, like Workbench.. or something very similar to it... that allows me to connect to different servers...

oh! and that admits dark theme!

I don't to burn my eyes lol

A_V

no idea really, I think you're always better off using clients designed for a specific DBMS

using TOAD for oracleDB and SSMS for SQLSERVER suits me

mariomenjr

well... thanks :)

Andriy M

@A_V yyyy-mm-dd hh:mm:ss.zzz is 23 characters. Your column is char(24). Maybe it's the last character?

« first day (2094 days earlier) ← previous day next day → last day (2776 days later) »

all rooms

Transcript for

Sep27

Sep '1628

Sep29

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