sqlserverstorageengine

265 Topics

DROP IF EXISTS - new thing in SQL Server 2016
First published on MSDN on Nov 03, 2015 In SQL Server 2016 CTP3 objects can DIE (DROP IF EXISTS)Do you like to write following conditional DROP statements:IF OBJECT_ID('dbo.
JovanPop
Mar 23, 2019 Place SQL Server Blog
163KViews
0likes
0Comments
Under the covers: GAM, SGAM, and PFS pages
First published on MSDN on Jul 08, 2006 (Been a week or so since the last post but I haven't burnt out with blogging yet - I was on vacation over the July 4th weekend and totally offline in and around a small town called Pullman in south-eastern Washington.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
55KViews
0likes
0Comments
How to use DBCC PAGE
First published on MSDN on Jun 10, 2006 Yes, finally I come clean and tell all.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
31KViews
1like
1Comment
Calling Http endpoints in T-SQL using CURL extension
First published on MSDN on Apr 17, 2018 SQL Server Database Engine don't have built-in functions that would enable you to send information to some API using http protocol.
JovanPop
Mar 24, 2019 Place SQL Server Blog
28KViews
2likes
2Comments
Import and analyze IIS Log files using SQL Server
First published on MSDN on Feb 10, 2017 IIS generates logs where are recorded many information about HTTP requests such as what Url was called, when the request happened, what is the origin, etc.
JovanPop
Mar 23, 2019 Place SQL Server Blog
20KViews
1like
0Comments
Loading GeoJSON data into SQL Server
First published on MSDN on Jan 05, 2016 GeoJSON is popular format for spatial data representation.
JovanPop
Mar 23, 2019 Place SQL Server Blog
19KViews
0likes
0Comments
Returning spatial data in GeoJSON format - Part 2
First published on MSDN on Jan 13, 2016 In the previous post Returning spatial data in GeoJSON format - Part 1, I have described how you can export Sql Server spatial data to GeoJSON.
JovanPop
Mar 23, 2019 Place SQL Server Blog
17KViews
0likes
3Comments
Returning child rows formatted as JSON in SQL Server queries
First published on MSDN on Oct 09, 2015 In this post I will talk about one annoying thing – how to return a result set containing one to many relationships between tables.
JovanPop
Mar 23, 2019 Place SQL Server Blog
16KViews
2likes
0Comments
Building SQL REST API back-end for Angular apps
First published on MSDN on Dec 18, 2017 JSON support in SQL Server/Azure SQL is designed to make integration between the relational database models and the modern single-page JavaScript apps easier than ever.
JovanPop
Mar 24, 2019 Place SQL Server Blog
14KViews
0likes
0Comments
Improving temp table and table variable performance using memory optimization
First published on MSDN on Mar 21, 2016 In-Memory OLTP is a technology introduced in SQL Server 2014 that can provide phenomenal (up to 30-fold) performance improvements for transactional workloads, and SQL Server 2016 improves the performance even further.
SQL-Server-Team
Mar 23, 2019 Place SQL Server Blog
13KViews
0likes
0Comments