Skip to content
DBA Fire
SQL Server, MySQL and WordPress Specialist
  • Contact Us
  • About Me
  • Resources

Category: Performance

Database/Performance

Cost Threshold For Parallelism – Best Practice and Recommendations

Posted on October 7, 2016 by Rob StGeorge / 1 Comment

Most DBA’s will make sure they are across the Maximum Degree of Parallelism setting in SQL Server. A setting often ignored though is Cost Threshold for Pa...

sql statistics
Database/Performance

SQL Server Update Statistics – Quick Tips & Examples

Posted on May 4, 2015 by Rob StGeorge / 0 Comment

An important part of obtaining sizzling database performance is ensuring statistics are up to date. Statistics that are up to date will ensure that queries will...

Database/Performance

SQL Server Plan Guide – How To Create One – And Why You Would Want To!

Posted on February 11, 2015 by Rob StGeorge / 0 Comment

I have to be honest with you, until I began studying for exam 70-461 (Querying Microsoft SQL Server 2012) I had little to do with SQL Server Plan Guides. It bec...

Database/Performance/SQL Quick Tips/Troubleshooting

Information to gather when troubleshooting performance of a query from a remote location

Posted on November 25, 2014 by Rob StGeorge / 0 Comment

This assumes you already know the basic layout/ SQL version of the remote location Exact details of issue (e.g 9 times out of ten it takes more than 30 seconds ...

Database/Performance

Most useful DMV’s SQL Server

Posted on November 24, 2014 by Rob StGeorge / 0 Comment

Its good to have a toolbox of useful DMV’s at hand for when a problem arises. Here are some of our most useful DMV’s that we end up using on a daily...

Database/Performance/SQL Quick Tips/T-SQL

How To Identify Duplicate Indexes in SQL Server

Posted on November 3, 2014 by Rob StGeorge / 0 Comment

Duplicate indexes can slow things down on a database. There is no need for them, so if you identify any get rid of them. T-SQL Script that identifies duplicate ...

Database/Performance/Troubleshooting

Implicit conversion causing index scan

Posted on August 18, 2014 by Rob StGeorge / 0 Comment

If when you are looking at a query plan and you see it doing an index scan along with an implicit conversion then the chances are that if you fix the implicit c...

Database/Performance

How to rebuild all the indexes on a single table – SQL Server

Posted on July 2, 2014 by Rob StGeorge / 0 Comment

If you have ever wanted to rebuild all the indexes on a table its pretty simple. I have had to do this sometimes when troubleshooting a situation and not wantin...

Database/Performance

How to know whether to rebuild or reorganize indexes plus a simple T-SQL only index rebuild script

Posted on June 9, 2014 by Rob StGeorge / 1 Comment

Simple query to show logical defragmentation You may find after a rebuild/reorg that some of the fragmentation values are the same or dont change much. However ...

Database/Performance

How to identify your top ten table “hotspots” – SQL Server

Posted on May 26, 2014 by Rob StGeorge / 1 Comment

Have you ever been asked to identify the most accessed and utilized tables in your database and wondered if there was a quick way to do it? This script which we...

Posts navigation

1 2 Next »

Most Helpful Articles

  • Convert Varchar Column to Nvarchar - Techniques and Best Practices
  • sp_executesql Stored Procedure Examples, Output and Return Values
  • How To Check Lock Escalation On A Table
  • SQL Server Varbinary Example - To and From A Flat File
  • What is the Difference Between + And Concat Function In SQL?
  • TSQL Email Verification - Easy Way To Check Addresses are Valid formats
  • Newid() vs Newsequentialid() - Performance Of, Differences Between and Examples
  • What Is The Difference Between a DBA (Database Administrator) and A SQL Developer
  • How To Change the Owner of Availability Group Endpoints
  • How To Create A Unique Constraint With Conditional Filter

Recent Posts

  • Google Sandbox Case Study
  • Exam 70-764 Study Notes – Configure data access and permissions – Users and Roles
  • Exam 70-764 Study Notes – Configure Encryption
  • How to fix a Replica Read Only DB Owner in an Availability Group
  • Do I need to Patch SQL Server for Meltdown and Spectre?

Sections

  • Cloud
  • Clustering
  • Configuration
  • CRM Integration
  • Data Science
  • Database
  • Database Mail
  • Dates
  • Disaster Recovery
  • Facebook
  • General
  • Google Analytics
  • Google Plus
  • IIS
  • Internet Marketing
  • iSCSI
  • Logshipping
  • Mirroring
  • Mobile
  • MySQL
  • off topic
  • Performance
  • Permissions
  • Recommended Resources
  • Replication
  • Server Core
  • Service Broker
  • Service Packs
  • Social Media Marketing
  • SQL 2012
  • SQL Quick Tips
  • SSIS
  • SSRS
  • T-SQL
  • Training Resources
  • Troubleshooting
  • Uncategorized
  • Views
  • Webhosting
  • Websites
  • WordPress

The owner of this website, dbafire.com, is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking dbafire.com Reviews to Amazon properties including, but not limited to, amazon.com, endless.com, myhabit.com, smallparts.com, or amazonwireless.com. The site is also a member of other affiliate programs.

© 2018 DBA Fire
Powered by WordPress | Theme: Graphy by Themegraphy