Viewing 15 posts - 1 through 15 (of 20 total)
I asked a question - when JSON in SQL Server could be constrained by collection of JSON schemas in the same fashion how Microsoft implemented a typed XML data in...
December 1, 2018 at 4:26 am
June 18, 2018 at 8:11 am
Why ADO.NET on client side - SQL Server has OOB rich metadata functionality in information views
June 17, 2018 at 10:41 pm
April 4, 2018 at 5:05 am
My sincere apologies if I offended an author of the article. IMHO the fact that you can do something it does not mean that you have to do it. And...
December 17, 2017 at 9:16 pm
Complete LUNACY. I highly recommend you to read this first https://www.microsoft.com/en-us/research/wp-content/uploads/2006/04/tr-2006-45.pdfAre you aware of FILESTREAM capabilities (since SQL Server 2008).This IMHO would be much better approach than store BLOBs...
December 7, 2017 at 1:17 am
I agree that adding a GUID to a set of data that already contains a primary key does not make ANY sense (unless it used for replication) 😎
December 18, 2014 at 8:58 pm
bigint datatype occupies 8 bytes of storage
uniqueidentifier - twice more 16 bytes,
Therefore for each 1 million of records you got an overhead of extra 0.763 Mb for additional...
December 18, 2014 at 4:18 am
Guys what is wrong with Auto-incremental identity that exists for ages! Or with Sequence originally existed in Oracle and now ported to SQL Server. Why the itchy need to reinvent...
December 18, 2014 at 3:03 am
Plus Microsoft table designer in SSMS does not...
December 17, 2014 at 10:33 pm
My motto - DO NOT use GUIDs as a primary key and do not use them at all (unless they required for replication/synchronisation scenarios between 2 OCCASIONALLY CONNECTED databases). Did...
December 17, 2014 at 10:06 pm
Clients are ALWAYS right - as long as they are paying!
December 16, 2014 at 12:22 am
Manie, we all had our "CLIENT IS ALWAYS RIGHT" moments, even when client was 100% absolutely wrong.
How about user request to implement 5 different data interfaces for 5 different...
December 15, 2014 at 11:12 pm
Thank you for a very interesting article. 😎
February 6, 2014 at 2:52 pm
Please note that the size of value of the extended property (data type sql_variant, with a default of NULL) cannot be more than 7,500 bytes.
Even with such limitation you...
September 27, 2013 at 12:54 am