Learn about the types of indexes that can be created and how to proactively choose the right indexes for your systems, and how to find missing and inefficient indexes on an existing instances of SQL Server.
This paper demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the basics and moving to advanced query tuning techniques.
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you p
One issue that I am often faced with is determining what service pack is installed on the SQL Server. Until recently the version of SQL Server that was installed was just a number, but now with the later service releases for SQL Server 2000 you can also
One of the issues I have is that the SQL Server Error Log is quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip "Simple way to find errors in SQL Server error log" you discussed a method of searching th
On June 5, 2006 MSSQLTips.com started with just one tip in an effort to offer solutions to real world SQL Server problems. Ten years later, we never expected MSSQLTips.com to grow into a global community of millions of SQL Server Professionals.
You need to create project files for a SSAS tabular database deployed on a SSAS Tabular Instance, but you don't have access to the project source for some reason. Creating an entire project from scratch that reflects the deployed database is not an option
Microsoft SQL Server Extended Events, a replacement for SQL Trace, provides a useful and very customizable framework for managing very technical, low-level event information about a SQL Server database and its instances. However...
In older versions of SQL Server a large amount of data changes needed to occur to trigger auto update statistics. In SQL Server 2016 this has been changed.
We are using SQL Server Reporting Services (SSRS) 2016. I'd like to create a key performance indicator (KPI) to track the status of my orders. I'd also like to show this KPI on any mobile device. Read this tip to learn how.
We need to programmatically validate our SQL Server database backups are not corrupted and that the backup can be successfully restored. We have limited storage and time so we are unable to actually restore the database. Are there any options to validate
In this free white paper, SQL expert, Joey D’Antoni discusses the costs associated with high availability and disaster protection in a SQL Server environment.
I need to load the results from a SQL Server T-SQL query to a Hadoop Distributed File System. How can I do this? How can I validate the data was loaded correctly?
In this tip I will present a simple, yet comprehensive example of workload processing that was optimized using SQL Server In-Memory OLTP which led to a performance boost up to 79x times faster processing over disk-based execution.
In this tip I will present a simple, yet comprehensive example of workload processing that was optimized using SQL Server In-Memory OLTP which led to a performance boost up to 79x times faster processing over disk-based execution.
Microsoft has recently released SQL server 2014 SP2 in which a new DBCC command - DBCC CLONEDATABASE is introduced. I found this command very useful and interesting too. In this tip we will explore the functionality of DBCC CLONEDATABASE.
This tip will explain the differences between the following COUNT function varieties: COUNT(*) vs. COUNT(1) vs. COUNT(column_name) to determine if there is a performance difference.
Learn how to use SQL Server 2016 Row Level Security to restrict access to data for specific users and for specific time periods as well as performance impacts.
Along with the new sample databases for SQL Server 2016, Microsoft also introduced new tools to mimic sample workloads to further explore the functionality. In this tip we will explore these sample workload tools.
You are about to deploy a critical change in your application databases. The code is enclosed in a transaction, but even when the code commits successfully there may be an issue which will require you to restore the database to the point before the change
I need to backup my local SQL Server databases and upload the backup files to Azure automatically. Can this be completed in SQL Server Integration Services (SSIS)? Is it also possible to delete the local backup after the file transfer has completed? Rea
