SQL Server XML Questions You Were Too Shy To Ask: Sometimes, XML seems a bewildering convention that offers solutions to problems that the average database user doesn't have. To make things worse, XML experts generally lack the wherewithal to provide...

Migrating a Disk-Based Table to a Memory-Optimized Table in SQL Server: In-Memory OLTP, also known as Hekaton, can significantly improve the performance of OLTP (Online transaction processing) database applications. It improves throughput and reduces...

Should I Type * or 1 With the EXISTS Logical Operator : Let me take a moment and do some research to find out which option is the best when you want to use the EXISTS logical operator. We are talking about the Hypothetical example of using of the EXI...

SQL Server - Find Physical Location of Records - SQL Server database files are organized in 8KB (8192 bytes) chunks, called pages. When we create the first row in a table, SQL Server allocates an 8KB page to store that row. Similarly every row in eve...

A record, also known as a row, is the smallest storage structure in a SQL Server data file. Each row in a table is stored as an individual record on disk. Not only table data is stored as records, but also indexes, metadata, database boot structures...

SQL Server caches the executio plan of our queries, not only stored procedures, but also ad hoc queries. However, when our server activity is mostly ad hoc queries, we have the risk to be wasting memory with queries that will never be executed again.

Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow and Is my index getting used

5 Things You Must Do After Installing SQL Server : As with most things in life, doing things right with SQL Server from the very first step makes it much easier to manage in the future. In this article, we’ll look at five important things you shoul...

SQL Server Optimize for Ad Hoc Workloads : Optimize for Ad Hoc Workloads is a configuration option introduced with SQL Server 2008 that can be very helpful in cases where you have a large number of ad hoc queries with low or no possibility of reuse....

Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log:SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the l...

Move a TDE Protected Database to Another SQL Server: This topic describes how to to protect a database by using transparent data encryption (TDE), and then move the database to another instance of SQL Server by using SQL Server Management Studio or T...

Single Package Deployment in SQL Server Integration Services 2016 : SQL Server 2016 has some exciting enhancements to SQL Server Integration Services. In this article, we take a look at how the issue of single package deployment into an SSIS Catalog...

Here are a few things that are new in SQL Server 2016 Integration Services Part 1 ...AlwaysOn Support for SQL Server Integration Services, SQL Server Integration Services Incremental Deployment,SQL Server Integration Services Always Encrypted support...

Reconciling Data Across Systems Using a Reconciliation Hub - In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Di...

Most SQL Server Integration Services (SSIS) packages are created to extract data from one or more sources, transform that data, and load it into one or more destinations. Throughout this process, SSIS uses its own set of data types to move, manage, a...