The database schema is like a solid foundation for a house, if you want an application that will scale, perform well and be able to support the application growth, then you need to have a strong database design. By the end of this session, you will have a
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
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APP
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.
We are constantly getting requests to produce reports that include data from SharePoint lists. We have just started using SQL Server Reporting Services (SSRS) 2008 R2 and see that there is a new Microsoft SQL Server Reporting Services SharePoint List Dat
I installed SQL Server 2014, but now the SSDT application used to develop BI solutions in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS) is missing. In this tip we cover how to instal
I am a BI developer and have been moved recently to a DBA role. Among the many tasks that I am responsible for, two major ones are: monitoring the SQL Server Agent Jobs running on a set of servers by creating a few standard SSRS reports and creating a Ref
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...
Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups in this