The Heap™ – Consultancy ©®

1:05 AM

I found a copy of an AVX book.

A: How do I install SQL-Server Tools if I can't use curl?

1:58 AM

Good news. SQL Server sucks even less today!

14.0.3038.14-2+ New versions of SQL Server (14.0.3038.14-2+) no longer conflict with libcurl3. Depends: libunwind8, libnuma1, libc6, adduser, libjemalloc1, libc++1, gdb, debconf, hostname, libssl1.0.0, openssl, python (>= 2.7.0), libgssapi-krb5-2, libsss-nss-idmap0, gawk, sed, libldap-2.4-2,...

kudos Micorosft.

5 hours later…

McNets

7:05 AM

Morning

7:19 AM

Morning

Marian

morning

1 hour later…

8:31 AM

good morning everyone

is there any way to know the input parameters of a sql server stored procedure

one way is by checking by source code

other way is right click on procedure and then click on execute

is there any other way?

Jack Douglas

@SpringLearner try and call it? dbfiddle.uk/…

Andriy M

@SpringLearner If it's a Transact-SQL procedure, you can get its definition using a number of methods: dbfiddle.uk/…

9:20 AM

@SpringLearner sp_help <procedure_name> (SQL Server)

A belated "Good Morning".

Thank you all for helping

@hot2use but if I am executing

exec sp_help [schemaName].[ProcedureName] then I am getting error

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'

@SpringLearner Use quotes like @AndriyM used in his fiddle

this shows how to call with the dbo schema

dbfiddle.uk/…

9:36 AM

Thank you very much Tom V

Its a so silly mistake

just wandering to know is there any shortcut to execute sp_help from SSMS

for example

I will simple select the procedure name and click some where and it shows me the input parameters

@SpringLearner sqlshack.com/…

A colleague did some thing in his machine while showing demo and I failed to understand what he did

@TomV thanks Again Tom. You are so nice

@SpringLearner without the schema

Just sp_help ProcedureName

Q: Is there any way to find out if any alteration is done to any table?

I missed quotes and so the error was appearing. As Tom suggested, I did that way and it success now

I am not sure if you guys have gone through my post

I am using SQL Server and a database has too many tables. I am preparing the list of tables which have been recently modified. Is there any way to find out which tables are modified? I am interested in knowing: if any datatypes are modified to any columns, new column is added, any colum...

sql-server

if not , Please have a look and answer if possible

English is not my native language and I apologize if I am making any english mistakes

example here:

dbfiddle.uk/…

9:43 AM

@hot2use thanks again

out of curiosity, why do you guys prefer to use dbfiddle instead of sqlfiddle

I have seen many answers in SO linked to sqlfiddle

Andriy M

@hot2use Great idea, sp_help is much better when you only need to know the parameters.

dbfiddle was created by one of us

cool

Q: A new fiddle for dba.se

SQLFiddle has been an essential tool and a great complement to dba.se for a very long time, but it has gone downhill a bit in the last year or two. I have also wondered for some time what a 'fiddle' designed specifically with dba.se and markdown in mind might look like, and over the last few day...

discussion

@AndriyM I find sp_help doesn't get enough appreciation, so I tend to provide hints when appropriate.

> Reports information about a database object (any object listed in the sys.sysobjects compatibility view), a user-defined data type, or a data type.

--> sp_help (Microsoft | Docs | SQL Server)

@SpringLearner it also has more recent versions of SQL Server, MySQL, Postgres

9:49 AM

not SQL Server 2019 CTP 2.0 yet though

hint, hint, ey?

Microsoft SQL Server 2019 Technical White Paper (pdf)

Andriy M

@SpringLearner Basically, I think dbfiddle.uk started when SQL Fiddle was down (and not for the first time). Jake Feasel did a really great job with SQL Fiddle, and it was because of his great job that whenever SQL Fiddle was down or didn't work well, it was a big deal. So Jack Douglas here started writing his own replacement, and we liked it, and it's easier to contact the creator if anything's wrong or needs improvement because he hangs around here often.

All those points combined may be the reason why dbfiddle.uk is now used more often (by many Heap regulars at least)

Thats a great job

10:18 AM

@PaulWhite PDW functionality is still conspicuous by its absence. They seem to be doing everything but - I wonder if there is a plan to fold it into the main product or if it's being quietly swept under the carpet.

@ConcernedOfTunbridgeWells wasn't it renamed to APS? I don't know much about it microsoft.com/en-us/sql-server/analytics-platform-system

@PaulWhite Possibly - As I understand it's only available through OEM channels that set up the hardware as well.

That sounds right

It's been around quite a while. I would have thought it might make its way into the mainstream product unless setting it up is a real faff.

Having said that, you can buy infiniband switches and HCAs off the shelf at commodity-ish prices now. I can't really see why building a hardware platform for something like PDW should be particularly onerous.

A bunch of 2U servers with 24 bay arrays plus an infiniband switch. If you want more storage per node put an external array on the node. Host-based RAID tends to be much faster per $ than SAN storage.

How hard can it be?

I think I'm starting to sound like @EvanCarroll

2 hours later…

12:38 PM

@PaulWhite lol wut

that's not a white paper, it's just marketing text.

So bizarre, Microsoft just jacks words because they sound cool.

Let's call an advertisement a "white paper"! People will read it if they think others regard as them as being smarter for it!!!11

On different machines the same ETL/OLAP project doesn't work or compile really often in Visual Studio. We're forced to do it once again from scratch practically every time. BTW for C# development I like using JetBrains Rider IDE without any problems, while VS is counter intuitive for me. Web development in VS Code also works fine but full Visual Studio always have some problems. — wokadakow 10 mins ago

I'm still not sure what problem he is looking to solve

1:27 PM

@TomV I wonder if his problem is that his configurations aren't working on the different machines due to paths, connection strings or some similar problem - perhaps a noddy lack of understanding of how to configure SSIS or SSAS for deployment.

1 hour later…

Q: How do I install SQL-Server Tools if I can't use curl?

2:41 PM

Isn't this a Linux question?

Attempting to install mssql-tools, I get $ sudo apt-get install mssql-tools Reading package lists... Done Building dependency tree... 50% Building dependency tree Reading state information... Done Package mssql-tools is not available, but is referred to by another package. This may mean...

sql-server installation sqlcmd

yes Evan probably forgot the tag

but if you mean - is it off-topic - then no

at least I don't think so anyway

3:00 PM

Neither do I

Ok put differently. If this were an installation issue on a Windows Server with a .NET Framework 3.5 missing error message, wouldn't we VAOT and point the user to Server Fault?

Also, I think I'm able to edit tags inline with the new layout

Or was I already able to do that before

Nevermind, I was able to do that, I guess I just don't use that feature and the button became more obvious now

@hot2use Depends, if the question revolves around "how to install .NET" probably yes, but if it's clearly an issue with the SQL Server installer having conflicting prerequisites for tools and engine maybe not

At least that would probably be how I vote, but the community as a whole may have a different opinion

Same.

3:41 PM

@hot2use It would be more like "SQL Server requires I uninstall .NET 3.5 and install 2.0"

1 hour later…

4:47 PM

@ypercubeᵀᴹ true

@TomV OK.

Thanks for your opinions

5:44 PM

What a day. I've been called 'so nice' and somebody thanked me for my opinion on the same day

I was on vacation for the last 2 weeks and it must have done me good

gonsalu

Hello

I'm reading the new features for SQL Server 2019; on the new UTF-8 support part it says "This reduction is because NCHAR(10) requires 22 bytes for storage, whereas CHAR(10) requires 12 bytes for the same Unicode string."

Shouldn't it be 20 bytes for nchar(10)?

@ypercubeᵀᴹ did you have something on null treatment of CROSS JOIN vs LEFT OUTER JOIN ON (true) or INNER JOIN ON (true)?

@EvanCarroll Not sure what you mean.

ah, nvm. I figured it out. the LEFT OUTER JOIN protects from the null set.

not on the null value.

yea, you corrected me once about this but wasn't sure if it was in chat just remmeber I was doing it wrong.

@EvanCarroll ah yes