MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter






























Microsoft SQL Server Articles, Tutorials, News, Tips & Tricks


2 Signs you need to Migrate to SharePoint 2016 and How to nail the upgrade?

Learn the pros and cons of migrating your SharePoint solution to SharePoint 2016 and essential steps that determine the success of your migration project.

Where can I find SQL Server Management Studio for SQL Server 2016?

After the successfully installation of SQL Server 2016, I have realized that SQL Server Management Studio 2016 (SSMS) is missing. In this tip we will discuss how to download and install SQL Server Management Studio for SQL Server 2016.

How to Download WideWorldImporters Sample Database for SQL Server 2016

Microsoft has introduced a new sample database WideWorldImporters specifically for SQL Server 2016. In this article we will explore how to download and restore SQL Server 2016 WideWorldImporters and WideWorldImportersDW Sample Database.

Download SQL Server 2016 Developer Edition for Free

Microsoft has announced the release of the Release to Manufacturing (RTM) version of SQL Server 2016 on June 1, 2016. The good news is that you can download SQL Server 2016 Developer Edition for Free. Different editions of SQL Server 2016 which are available are Enterprise, Standard, Web, Developer and Express Edition.

T-SQL Enhancements in SQL Server 2016 for Developers and DBAs

SQL Server 2016 introduces many new T-SQL features for Developers and Database Administrators. In this tutorial we will take a look at some of the new T-SQL enhancements in SQL Server 2016 along with relevant examples.

TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016

Starting SQL Server 2016, Microsoft has introduced a new clause TRUNCATE TABLE WITH PARTITIONS which can be used to truncate all rows available within a partition.

DROP IF EXISTS T-SQL Enhancement in SQL Server 2016

SQL Server 2016 introduces a new DROP IF EXISTS statement to DROP objects such as tables, columns, indexes, stored procedures, schemas, triggers and user-defined functions. DROP IF EXISTS statement can be used to check whether the object exists before it is dropped or removed from the database.

ALTER TABLE WITH (ONLINE = ON | OFF) T-SQL Enhancement in SQL Server 2016

SQL Server 2016 introduces an interesting T-SQL enhancement to improve performance and reduce downtime ALTER TABLE WITH (ONLINE = ON | OFF). This statement will help you alter data types, change column/table collation values, change nullability settings, change column length, and many other options while the table remains online for user connectivity.

MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP T-SQL Enhancement in SQL Server 2016

SQL Server 2016 brings MAXDOP settings, for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP command. Database Administrators can leverage MAXDOP settings to above mentioned DBCC commands to achieve Max Degree of Parallelism.


Trending SQL Server Tips on MyTechMantra.com

Top 10 Trending SQL Server Tips on MyTechMantra.com for SQL Server DBAs, Developers and BI Professionals

ALTER DATABASE SET AUTOGROW_SINGLE_FILE T-SQL Enhancement in SQL Server 2016

SQL Server 2016 introduces two new options to ALTER DATABASE statement which can be used to modify database files namely AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES. In the earlier versions of SQL Server to achieve similar functionality you could use the trace flag 1117. This would allow all the files of the database to auto grow at the same time if they are configured files to auto grow.

ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016

SQL Server 2016 introduces two new options to ALTER DATABASE statement which can be used to modify database files namely AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES. In the earlier versions of SQL Server to achieve similar functionality you could use the trace flag 1117. This would allow all the files of the database to auto grow at the same time if they are configured files to auto grow.

COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016

SQL Server 2016 introduces two new string functions namely STRING_SPLIT and STRING_ESCAPE..

STRING_SPLIT and STRING_ESCAPE T-SQL Enhancement in SQL Server 2016

SQL Server 2016 introduces two new system functions namely COMPRESS and DEOMPRESS.

FORMATMESSAGE T-SQL Enhancement in SQL Server 2016

FORMATMESSAGE statement is enhanced in SQL Server 2016 to accept a msg_string argument. In the previous versions this function was used to form a message from text located in sys.messages.

SERVERPROPERTY T-SQL Enhancement in SQL Server 2016

SERVERPROPERTY is an inbuilt function which gives you information about the server instance.

Why it is Important to Customize Model Database Default Settings in SQL Server

In this tip, we will take a look at few of the very importance customizations which a DBA must do for a Model System Database so that all the newly created databases on the SQL Server Instance have better configuration that the default database settings.

How to Start SQL Server with Minimal Configuration

There can be certain scenarios when SQL Server is not starting because of configuration problems. During such scenarios one need to start an instance of SQL Server by using minimal configuration. In this article we will take a look at steps which one needs to follow to start SQL Server with Minimal Configuration to troubleshoot SQL Server configuration issues.



Share this Article





Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips



Trending SQL Server Tips