SQL Server comes with many tools to help optimize and tune performance, such as traces, extended events, execution plans, dynamic management views and more. In order to make the correct changes you need to know what tool to use...
This detailed report compiles input from 300 DBAs like you, comparing and contrasting their responses to pertinent questions such as: Are traditional database-management systems still dominant? Which tasks are being automated? And more...
You have a SQL Server stored procedure that has been performing fairly well, but suddenly its execution times skyrocket. After looking at the cached execution plan you see that the query is using all indexes as should be. What’s going on? Keep reading and
You want to run SQL commands with the sqlcmd tool on a Linux terminal, but you don't want to have to change to the tools folder for every terminal window you open. In this tip I will show you how to set the $PATH environment variable on Linux.
Cascading parameters is a very routine and basic requirement of any report. While using SSAS Multi-dimensional mode as the data source, MDX has to be used as the data source. Read this tip to learn how.
As per our business requirements, we are planning on archiving some historical data from large tables into a separate filegroup and make that filegroup read only. What are the options that are available for moving data in tables to a separate filegroup?
What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? How do they affect the data presented to the end user? When should you use the KeyColumn, the NameColumn, and 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.