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...
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...
@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)
@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.
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.
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. — wokadakow10 mins ago
I'm still not sure what problem he is looking to solve
@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.
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...
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
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."
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,...
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...
