Showing posts with label SQL Server 2016. Show all posts
Showing posts with label SQL Server 2016. Show all posts
Monday, January 15, 2018

When uncompressing data, make sure to use the correct function

›
SQL Server has offered data compression for a while now, you could either use PAGE compression or ROW compression, you had no ability so s...
1 comment:
Tuesday, January 17, 2017

Using bigint with FORMATMESSAGE

›
SQL Server 2016 added the FORMATMESSAGE function.  According to Books On Line, FORMATMESSAGE constructs a message from an existing message...
1 comment:
Monday, January 16, 2017

Creating the Wide World Importers sample database v1.0

›
Before SQL Server 2005, we had the northwind and pubs sample database, these actually shipped with the product. If you did a SQL Server 2...
2 comments:
Thursday, December 29, 2016

The 15 most popular posts in 2016

›
Another year is almost over. As the last post of this year I decided to share with you the 15 most popular posts in 2016. I just used Googl...
Saturday, November 19, 2016

What we learned from the reddit SQL Server AMA thread on /r/sqlserver

›
The SQL Server AMA thread on reddit , has finished. I have put 8 most interesting answers here and then gave my take on it, the questions ...
Thursday, November 17, 2016

What's new in SQL Server 2016: CREATE OR ALTER

›
SQL Server 2016 Service Pack 1 added the CREATE OR REPLACE functionality, however in SQL Server, it is called CREATE OR ALTER.  Finally it...
2 comments:
Wednesday, November 16, 2016

Playing around with the new stuff in SQL Server vNext and SQL Server 2016 SP1

›
Earlier today Microsoft released the first CTP of the next version of SQL Server, I have a post about that here SQL Server 2016 SP1 release...
3 comments:

SQL Server 2016 SP1 released, SQL Server vNext available for download

›
Today Microsoft announced the CTP of the next version of SQL Server, you can download it here  https://www.microsoft.com/evalcenter/evaluat...
Saturday, November 12, 2016

What's new in SQL Server 2016: Truncate partitions

›
In my The best thing about the PASS summit for me is... post I said that I would do the following I will also do a series about new st...