SQL Server

Pro Members SQL Server Standard Members

Troubleshooting problems with indexes in SQL Server 2008 R2

Troubleshooting problems with indexes in SQL Server 2008 R2 If you have problems with indexes in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 index bugs were fixed in SQL Server service packs, you should install the latest SQL Server...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

System Health Session Dashboard – Health Summary Report

System Health Session Dashboard – Health Summary Report In the last post of this series, I discussed about how to get information about errors reported by the System Health Session for SQL Server 2008 and above instances. Additionally, I demonstrated how connectivity and security errors are tracked using separate Extended Events in SQL Server 2012. In this post, we shall...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

How to Manage… Without Micromanaging

How to Manage… Without Micromanaging By Laura Lee Rose, author of TimePeace: Making peace with time Hello, this is Laura Lee Rose – Corporate Exit Strategist for the Blooming Entrepreneur – and I am a business and life coach that specializes in time management, project management and work-life balance strategies. As leaders and managers, we struggle with how to manage...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Spool Operators: Index spool and Window spool

Spool Operators: Index spool and Window spool In my previous article I talked about a few spool operators (Eager Spool, Lazy Spool and Rowcount Spool), now it’s time to talk about the remaining spool operators that the query optimizer uses to make our queries run faster. In this article I will talk about the Non Clustered Index Spool. Then I...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with views in SQL Server 2008 R2

Troubleshooting problems with views in SQL Server 2008 R2 If you have problems with views in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 views bugs were fixed in SQL Server service packs, you should install the latest SQL Server...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with bulk copy in SQL Server 2008 R2

Troubleshooting problems with bulk copy in SQL Server 2008 R2 If you have problems with bulk copy in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 bulk copy bugs were fixed in SQL Server service packs, you should install the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 cursors

Troubleshooting problems with SQL Server 2008 R2 cursors If you have problems with cursors in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 cursor bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Spool Operators: Eager Spool, Lazy Spool, Row Count Spool

Spool Operators: Eager Spool, Lazy Spool, Row Count Spool There are a lot of operators in the query execution plan that we generally overlook (I do this for those operators which I have no clue about). Sometimes these operators prove out to be pivotal in the performance of the query and we are forced to take good care of them....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 full-text search

Troubleshooting problems with SQL Server 2008 R2 full-text search If you have problems with SQL Server 2008 R2 full-text search, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 full-text search bugs were fixed in SQL Server service packs, you should install the latest SQL...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Keeping Your SQL Server HIPAA Compliant

Keeping Your SQL Server HIPAA Compliant By Juan Rogers, Product Manager for SQL Server Security and Compliance Solutions at Idera What is HIPAA/HITECH and how does it affect your data collection/management? What can organizations that are concerned with HIPAA compliance do to keep their SQL Server compliant? The Health Insurance Portability and Accountability Act of 1996 required the secretary of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register