SQL Server

SQL Server

Tips for using indexes in SQL Server 2016 (Part 1)

Tips for using indexes in SQL Server 2016 (Part 1) Consider creating the columnstore indexes on the memory-optimized tables. Beginning with SQL Server 2016, you can create a memory-optimized table with a columnstore index. You can use the ALTER TABLE ADD INDEX statement to add the columnstore index after the memory-optimized table is created. Create a clustered index for each […]

SQL Server

How do I get rid of my biggest time wasters?

How do I get rid of my biggest time wasters? Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. […]

SQL Server

Some useful SQL Server 2016 trace flags

Some useful SQL Server 2016 trace flags Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. There are 3 types of trace flags in SQL Server 2016: query trace flags global trace flags session trace flags Query trace flags are active for the context of a specific query. A global trace flag […]

SQL Server

Relational Database Management System (RDBMS) and Normalization Forms — Part 10

Lossless – Join Decomposition In this article so far normalization of a number of relations or tables has been done by means of decomposing them. Table or relation has been decomposed instinctively. At this point of time a better understanding for determining decompositions as instinct might not always be precise. Over here, an illustration is given as an instance for […]

SQL Server

What is the Difference Between Sales and Marketing?

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. A busy professional asks a question regarding sales and marketing: […]

SQL Server

Tips to use System Monitor with SQL Server 2016

Tips to use System Monitor with SQL Server 2016 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2016. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. To start System Monitor […]

SQL Server

Relational Database Management System (RDBMS) and Normalization Forms — Part 9

Third (3rd) Normal Form The second normal form (2NF) tables or relation that was recognized in the preceding section signify an important enhancement over first normal form (1NF) relation or tables. But, the tables still suffer from the similar kinds of irregularities as the first normal form (1NF) relation or tables even though for various causes related with transitive dependencies. […]

SQL Server

Tips for using SQL Server 2016 configuration options

Tips for using SQL Server 2016 configuration options In this article, you can find the description of some useful SQL Server 2016 configuration options with the examples how to make it by using the sp_configure system stored procedure. Note. Because setting up some SQL Server 2016 configuration options can degrade performance you should change these options very carefully and continue […]