Archives for SQL Server, Denali - Page 3
Data Security in SQL Server (and other databases)
If you have sensitive data ( HIPAA data), you need to consider both encryption as well as SALTING of your data at the database level. Encryption Prior to 2008, SQL…
Top 20 worst performing SQL Server queries
Top 20 worst performing queries --------------------------------- and thus you would see "similar" query text in the proc cache each with its separate compiled plans */ DECLARE @SQLString nvarchar(500) DECLARE @cnt…
Maintenance Plan for SQL Server 2014
These scripts are owned and developed by Ola Hallengren DatabaseBackup: SQL Server Backup DatabaseIntegrityCheck: SQL Server Integrity Check IndexOptimize: SQL Server Index and Statistics Maintenance Download Maintainance Script for…
SQL Server Database CPU Utilization and Memory Usage
Apart from Query Performance analysis and Schema Objects analysis (indices, statistics etc.), there are two important metrics that are usually sought out for a poorly performing SQL Server instance. These…
Overall Strategy for Monitoring SQL Server Performance
This is just a quick cliff’s notes on what to look for in terms of the Physical Design of the database. The four main categories of concern are : Memory…
Nasty Joins, Cartesian Joins
A Cartesian join is an (incorrect) join between two tables. Incorrect because the tables have not been joined in any relational street_address from authors a, location b where like ‘%varma%’…
Sql Server Enterprise versus Standard Editions
High Availability SQL Server Standard includes some features to enable high availability, but the Enterprise edition brings more. Features like database snapshots, mirrored backups and fast restore mean that when…
Using Database Tuning Advisor for individual queries
Often times, instead of tuning an entire database, we are interested in performance tuning a single offending query. This can be accomplished by applying the tuning wizard to a specific…
Moving large tables to a different Filegroup
Introduction If you have some tables that are taking over 10% of the table space in SQL Server (see this post for finding large tables), they are candidates for being…
Find Largest Tables in your SQL Server database
Introduction This script uses a temp table to store the results of the query. It sorts the results in descending order – showing the largest tables on top. CREATE TABLE…