Sqlserver-dba.com - SQL Server support and SQL Server Performance Tuning
    SQL Server DBA:Everything | DBA Scripts | Powershell Scripts | DBA checklists | SQL Antipattern |

Follow sqlserver-dba.com

Daily & Exclusive Content

Delivered by FeedBurner

SQLServer-DBA.com Links

Dba_db2_button

Recent Posts

Powered by TypePad

Full list of SQL Server articles posted


February 24, 2017 How to check SQL Server AlwaysOn High Availability is enabled

February 23, 2017 Powershell script to report SQL Error Log

February 22, 2017 How to backup the SQL Server SystemResource db – mssqlsystemresource

February 21, 2017 Help command in sql for undocumented commands

February 20, 2017 Resource database in SQL Server SystemResource db - mssqlsystemresource

February 17, 2017 How to shrink tempdb when Event ID 1101 Could not allocate a new page for database 'TEMPDB' because of insufficient disk space in filegroup 'DEFAULT'

February 15, 2017 SQL Memory usage query and cachestore_sqlcp

February 12, 2017 Guiding principles of wait time analysis

February 11, 2017 T SQL Antipatterns - SQL Antipattern #010

February 10, 2017 Windows Server 2012 empty recycle bin

February 07, 2017 Get cumulative update number for SQL Server Version

February 06, 2017 SQL Server uptime query

February 05, 2017 What is causing sql Cache Pressure

February 04, 2017 Ultimate GLOBALISATION guide

February 03, 2017 Helpful sql commands to manage SQL Agent Jobs

February 02, 2017 How to find of the QUOTED_IDENTIFIER used for stored procedure

January 31, 2017 How to get row count for every table in database

January 27, 2017 Skills required for rapid development

January 24, 2017 xp_cmdshell copy – access is denied

January 23, 2017 Will placing a large data column as an index INCLUDE impact sql query performance

January 22, 2017 Backup failures SQLVDI: Loc=CVDS::Close. Desc=Open devices!. ErrorCode=(0).

January 21, 2017 The future of the DBA profession

January 20, 2017 How to shrink SQL Server database transaction log file initial size

January 18, 2017 ASYNC_IO_COMPLETION during sql server backup

January 17, 2017 Microsoft ACE OLEDB 12.0 provider is not registered on the local machine

January 16, 2017 Notes on Performance Tuning very large databases for OLTP

January 15, 2017 Database Tuning Advisor Performance

January 14, 2017 Warren Buffett Billionaire Tips

January 13, 2017 Detach versus Offline

January 12, 2017 How to get FQDN of multiple servers with Powershell

January 11, 2017 How Busy is my SQL Server

January 10, 2017 Error 17836 Length specified in network packet payload did not match number of bytes read; the connection has been closed

January 09, 2017 ERROR 8623 The query processor ran out of internal resources and could not produce a query plan

January 08, 2017 FROM REDCAR TO RUST

January 07, 2017 How to check if a file exists with xp_fileexist

January 06, 2017 Difference between TCP and UDP network protocols

January 04, 2017 A 5 MB hard drive in 1956 needed a forklift

January 03, 2017 How to monitor Blocked Processes with SQL Alert and email sp_whoisActive report

January 01, 2017 The politics of Calais , border control and Brexit

December 30, 2016 Schrodinger’s backup - A warning for DBAs

December 29, 2016 10 most visited pages on sqlserver-dba.com for 2016

December 22, 2016 Privatisation can help upgrade public infrastructure

December 21, 2016 GRANT VIEW DEFINITION to script out tables

December 20, 2016 Limitations of xp_logininfo

December 09, 2016 SQL Server restart times using Powershell

November 30, 2016 Impact of Brexit on IT contractors

November 26, 2016 Using SQL Server Express in Production

November 25, 2016 Social Conformity and questioning authority

November 23, 2016 Display all files in a directory with master.sys.xp_dirtree

November 15, 2016 Powershell script - Get the SQL Server Instance status with Get-Service

November 15, 2016 Disadvantages of using sp_MSforeachdb

October 29, 2016 How to find Longest running queries in SQL Server

October 29, 2016 Global Population Growth, Box by Box Ted Talk

October 12, 2016 How can I tell if hyperthreading is on Windows 2012

September 20, 2016 How to schedule Powershell Script with Task Scheduler

September 06, 2016 Lots of NULL values can cause trouble

September 05, 2016 ALTER INDEX REBUILD clears sys.dm_db_index_usage_stats

September 02, 2016 7 mistakes DBAs make on CV or resume

September 02, 2016 5 ways globalisation has impacted IT

September 01, 2016 Is a LOG BACKUP allowed on a SIMPLE RECOVERY database

August 31, 2016 How to turn AUTO_SHRINK off

August 29, 2016 7 Essential Steps to Recover a Corrupt SQL Server Database

August 26, 2016 DBA vacancy at Travelers - UK based

July 22, 2016 Get Last Windows boot up time with Powershell

July 20, 2016 How to list Domain Controllers in a Domain with nltest

July 11, 2016 Hypothetical Indexes

July 05, 2016 Microsoft Enterprise Advantage Licensing on MPSA

July 04, 2016 Query to find non – sargable sql statements – SQL Antipattern #009

June 30, 2016 Set owner failed for database an exception occurred in smo - Msg 15110, Level 16, State 1, Line 1

June 29, 2016 BT and Oracle cloud link up

June 24, 2016 Danger of maintaining SQL backup copies in different locations

June 06, 2016 Trace flag 610 and High performance data loading

May 27, 2016 How to check my SQL permissions

May 25, 2016 Troubleshooting SQL Server Service Broker

May 21, 2016 Show me the wait stats

May 06, 2016 SQL Service hanging with Change Pending Error

April 15, 2016 Msg 8116 - Argument data type sql_variant is invalid for argument 1 of function

April 13, 2016 Powershell script – Function to return server disk capacity

April 12, 2016 How to reduce THREADPOOL wait type

April 05, 2016 Are you sleeping enough? Take the sleep test

April 04, 2016 Principle of Least Privilege

March 30, 2016 Forceseek table hint to the rescue

March 24, 2016 SQL Server Backup – Restore vs Detach – Attach : which method is faster?

March 23, 2016 How to monitor progress of Online Index Rebuild

March 22, 2016 How to monitor progress of Offline Index Rebuild

March 21, 2016 How to check SQL Server password policy

March 20, 2016 Increase speed of a NOT EQUAL operator and a workaround using a computed column

March 19, 2016 How to delete millions of rows in batches

March 18, 2016 How to create a table in another FILEGROUP using SELECT INTO

March 17, 2016 How to complete an INSERT in batches for large data sets

March 14, 2016 How to understand CXPACKET wait type resource description in Sys.dm_os_waiting_tasks

March 13, 2016 The 90 – 90 rule – SQL Antipattern #009

March 12, 2016 How to create a DBA skills matrix

March 11, 2016 How to audit DML statements based on server principal name

March 09, 2016 What is acceptable database server performance testing

March 08, 2016 New Database request checklist

March 07, 2016 Managing security for SQL restores

March 06, 2016 How to use xp_readerrorlog parameters to search SQL Error Logs

March 05, 2016 Lockard Principle and database theft

March 04, 2016 How to fix - Lock request timeout period exceedd Error 1222

March 03, 2016 How to use GO command for multiple execution of sql statements

March 02, 2016 How to add a sql table to a different FILEGROUP

March 01, 2016 Powershell script: Powershell equivalent of Linux top

February 29, 2016 Is AntiVirus Software required on a SQL Server

February 28, 2016 Premature optimization - SQL Antipattern #008

April 27, 2015 How to use ISO-8601 for date and datetime

April 25, 2015 New database or new instance

April 25, 2015 Inside Google Data Centers

April 24, 2015 Execute permission was denied on the object

April 21, 2015 Security audit for SQL public role

April 16, 2015 The Agile DBA

April 07, 2015 Implicit conversion of data types in the query engine

March 30, 2015 Powershell script to report SQL Database Status

March 21, 2015 Researching FlashCopy Manager for backup and restore management

March 12, 2015 Find high IO read and write SQL Queries and display query plan

March 04, 2015 Execute Sp_table_privileges on all SQL Server instance databases

February 25, 2015 How to check UAC – User Account Control is enabled or disabled

February 19, 2015 Connect to SQL Server using port number

February 16, 2015 Xp_cmdshell – the most dangerous extended stored procedure on the planet

February 12, 2015 DROP SCHEMA script for multiple sql database users

February 06, 2015 The transaction log for database is full due to ACTIVE_TRANSACTION

February 03, 2015 How to crack the SQL Login password from sys.syslogins

February 02, 2015 OFFLINE Database files not deleted when DROP DATABASE is executed

February 02, 2015 Detach and Offline for moving databases

January 27, 2015 How to List SQL logins and database user mappings

January 25, 2015 Index column order in Index Missing Feature

January 24, 2015 Query VMWare vCenter VCDB database for guest and host details

January 14, 2015 How to select tables in a schema using sysobjects

January 13, 2015 Msg 15138 - The database principal owns a schema in the database and cannot be dropped.

January 10, 2015 How to tune every query

January 07, 2015 The EXECUTE permission was denied on the object sp_enum_dtspackages

January 06, 2015 Script to change database owner to sa for all user databases

January 03, 2015 Ask the Duck Your Question

January 02, 2015 SQL Injection Defence

January 01, 2015 Hot trends in database server management for 2015

December 29, 2014 Top 10 most active posts for SQLServer-DBA.com in 2015

December 26, 2014 How to go from New DBA to Advanced DBA

December 25, 2014 Database Performance Tuning Jobs

December 25, 2014 Bad indentation in stored procedures

December 24, 2014 Drop sysadmin with ALTER SERVER ROLE and DROP MEMBER

December 23, 2014 Interview with Author on essential SQL

December 15, 2014 bcp - export and import data on SQL Server

December 10, 2014 List all NT group logins with Powershell

December 08, 2014 Century of the System and managing complexity

December 06, 2014 Failure inserting into the read-only column and SET IDENTITY_INSERT ON

December 03, 2014 Simple example of WHILE loop to iterate through sys databases

November 25, 2014 BULK INSERT and ROLLBACK

November 18, 2014 Read a script file into Powershell CommandText with get-content

November 14, 2014 How to manage the IS_GRANTABLE security risk

November 11, 2014 How to decide on the Primary Key

November 10, 2014 Encrypting data in SQL Server

November 09, 2014 Isolate top waits for server instance since last restart or statistics clear

November 07, 2014 How to list all CLR objects and associated procedures

November 03, 2014 List all SQL jobs in Job Activity Monitor with Sp_help_job

October 15, 2014 How to Script database role permissions and securables

October 13, 2014 Help Women At Risk in Bulgaria

October 09, 2014 Connect SQL Server 64 bit to odbc 32 bit

October 07, 2014 How to get the DNS API permissions in CLR assembly

October 04, 2014 Definition of a scalar value in a relational database

October 03, 2014 xp_cmdshell whoami – Determine which Windows Account is used

October 01, 2014 Where to maintain data integrity rules?

September 25, 2014 List enabled status of SQL Server Agent Jobs

September 23, 2014 How much free memory on the server?

September 22, 2014 How to find Active tables without a clustered index

September 20, 2014 Last known good backup – Assumption is the mother of all xxxx ups

September 17, 2014 How to choose Internet Explorer 64 bit version

September 16, 2014 Script to DROP CONSTRAINT and ADD CONSTRAINT for all CHECK CONSTRAINTS

September 15, 2014 Msg 5075 - The database collation cannot be changed if a schema-bound object depends on it

September 14, 2014 Full Recovery without Log Backups

September 13, 2014 Query Tuning cannot be taught over forums

September 10, 2014 Troubleshoot SDDDSM error messages

September 09, 2014 SQL Server DBA Checklists

September 07, 2014 Best of sqlserver-dba-com

September 06, 2014 How to List Task Scheduler Eventlog with messages using Powershell

September 05, 2014 Using the tcp: prefix for SQL Server connections : Force use of TCP protocol

September 04, 2014 Find the Root cause of a SQL Server Performance downgrade

September 03, 2014 Error 3621 - The statement has been terminated

September 01, 2014 Find database corruption with msdb.dbo.suspect_pages

September 01, 2014 SQL Server Memory: Any size page allocator replaces single and multi-page allocator

August 31, 2014 Delete a huge amount of data from a SQL Server table

August 29, 2014 Generate query results and attach to email using SQL Server Database Mail

August 29, 2014 How to output Query results to text file using bcp and queryout

August 27, 2014 How to start SQL Performance Tuning

August 27, 2014 DBA daily study habits

July 29, 2014 Msg 3257 :There is insufficient free space on disk volume during SQL Server Restore

July 15, 2014 Find SQL deprecated features with sys.dm_os_performance_counters

July 11, 2014 How to backup a single table with data in a database

July 10, 2014 Warning: Failure to calculate super-latch promotion threshold

July 04, 2014 Compatibility error when using MERGE. Incorrect syntax near 'MERGE'.

July 01, 2014 Perfmon SQL Server Deprecated Features Object

June 30, 2014 Troubleshoot high disk activity with STATISTICS IO

June 27, 2014 The specified DSN contains an architecture mismatch between the Driver and application

June 26, 2014 How to Export Active Directory Group Members with Powershell Get-ADGroupMember

June 23, 2014 Measuring SAN Performance with Avg Disk Transfer and disk bytes per second

June 19, 2014 How to Reduce the WRITE_COMPLETION wait type

June 17, 2014 How to identify the Primary Transaction Log file on a SQL Server

June 11, 2014 How To restore to lower SQL Server version

June 09, 2014 Business Objects versus SSRS

June 06, 2014 Export multiple Excel worksheets to a single SQL Server table

June 04, 2014 How to use sxstrace.exe – diagnose side-by-side errors

June 03, 2014 Predictability is the key to scalability

May 30, 2014 Difference between sys.objects and sysobjects

May 28, 2014 How to schedule a SQL Server Agent Job to execute once a year -(Annually)

May 27, 2014 Connect SQL Servers without using Linked Servers – OPENROWSET and OPENDATASOURCE

May 21, 2014 SQL Server RUNNABLE – SUSPENDED – RUNNING status model

May 19, 2014 How to drop a SQL column and find foreign keys with sp_fkeys

May 15, 2014 How to Predict SQL Server Performance

May 10, 2014 How to reduce DBMIRROR_EVENTS_QUEUE , DBMIRROR_SEND, DBMIRRORING_CMD, DBMIRROR_DBM_MUTEX wait types

May 08, 2014 Use Powershell Get-Hotfix to get all hotfixes on Windows server

May 06, 2014 How to get a list of software installed on a server using Powershell

April 30, 2014 How to install the Active Directory Module for Windows Powershell

April 28, 2014 Hide instance of SQL Server

April 26, 2014 Continual Improvement or kaizen

April 23, 2014 How to find SQL License type

April 20, 2014 Error 3266 : How to troubleshoot Error 3266 during a Restore

April 17, 2014 How to SET and check READ_COMMITTED_SNAPSHOT

April 16, 2014 What are your data needs?

April 09, 2014 List columns using INFORMATION_SCHEMA

March 25, 2014 Creating a Disaster Recovery Plan

March 24, 2014 Error 5171 – mdf is not a primary database file

March 21, 2014 Troubleshooting BACKUPTHREAD wait type

March 19, 2014 Troubleshooting Error: 18452, Severity: 14, State: 1

March 17, 2014 Troubleshooting PREEMPTIVE_OS_LOOKUPACCOUNTSID wait type

March 12, 2014 SQL 2012 datetime rounding issue

March 11, 2014 Non-sysadmin permissions to create or edit an SSIS package

March 07, 2014 DIRTY_PAGE_POLL and how to avoid it

March 04, 2014 Database server Sizing matters

February 26, 2014 Indexes - The downside

February 22, 2014 How to determine who deleted a SQL Server database

February 11, 2014 The Pencil question – Great interview question

February 06, 2014 Assume failure and Resiliency testing

February 03, 2014 Heaps - Tables without a clustered index

January 30, 2014 VLDB and Zeroing out

January 29, 2014 Compatibility Level

January 28, 2014 OLAP performance tuning

January 20, 2014 Regular SQL Server Backup Review

January 16, 2014 How write the a SQL Server agent Job status to the Windows Application log

January 14, 2014 Operations team and sql server permissions

January 09, 2014 TempDB - setting the initial size

January 07, 2014 SQL Schedulers disabled

January 06, 2014 Msg 229 Level 14 State 5 - SQL VIEW permissions and underlying tables

January 03, 2014 WITH RECOMPILE option and stored procedure

January 02, 2014 Elevated database permissions

January 01, 2014 Tuning expert makes SQL Server faster

January 01, 2014 2014 for Database Servers

December 30, 2013 Top 10 SQL Server articles for 2013

December 12, 2013 Sp_configure

December 06, 2013 No database backup

December 02, 2013 List Sysadmins – SQL Server security

November 26, 2013 Number of deadlocks since last SQL Server restart

November 23, 2013 Find sql queries matching wait types

November 11, 2013 SQL Server lab requirements

November 05, 2013 SQL Server Tuning method for a drop in throughput

October 10, 2013 DAC and Server is in single user mode – Error 18461

October 09, 2013 Find WorkingSet size with Powershell get-process

October 04, 2013 Troubleshooting SQL Transaction Log performance

October 02, 2013 Use SQL Materialized view to eliminate DISTINCT and speed up response time

September 23, 2013 SQL login is locked out – how to check status with T-SQL

September 18, 2013 SQL DATA FILE AUTOGROW performance troubleshooting

September 16, 2013 Error: 0x202b State 15 The SQL Network Interface library could not register the Service Principal Name for the SQL Server service

September 11, 2013 Find column data types using sys.types and sys.syscolumns

September 09, 2013 Monad Manifesto – required reading for Powerhell users

September 06, 2013 Last time Index was rebuilt

September 05, 2013 Nonclustered Index Seek Operator needs leftmost key in query

September 03, 2013 Full text rebuild option – and SQL Server performance

August 28, 2013 scan for startup procs Option – when to use

August 27, 2013 SQL Server papers every DBA should read

August 26, 2013 Powershell FAQ for the SQL Server DBA

August 22, 2013 View DTS packages with Powershell – DTS to SSIS planning

August 21, 2013 Msg 15173 - Login has granted one or more permission(s). Revoke the permission(s) before dropping the login.

August 19, 2013 I/O is frozen on database. No user action is required

August 14, 2013 Find who made a database name change with Object:Altered

August 03, 2013 SQL Server 2012 SSIS upgrade considerations

July 29, 2013 Calculate the Size of Index

July 24, 2013 Calculate sql row size

July 22, 2013 Troubleshoot Error 701 - There is insufficient system memory to run this query

July 19, 2013 How to create a clickable link in Powershell

July 17, 2013 Change the port for sql server service broker

July 12, 2013 How to Install SQL Server service pack silently

July 11, 2013 How to Configure static ports for SQL Server

July 09, 2013 Exception based reporting

July 08, 2013 TechEd Europe 2013 lessons learnt :SQL Server 2014,powershell,performance,automation

July 05, 2013 Keep it simple!

July 03, 2013 Find the permission path of a Windows logon with XP_LOGININFO

July 02, 2013 How to perform an in-place upgrade of Powershell

June 26, 2013 Encrypting sa passwords during SQL Server Installation

June 25, 2013 Expand your Powershell mind – Three key cmdlets

June 25, 2013 Expand your Powershell mind – Three key cmdlets

June 24, 2013 Manage SQL Agent jobs without sysadmin

June 21, 2013 Sushi , daily habit, productivity and DBA

June 19, 2013 String Replace in text file with Powershell

June 18, 2013 Forgotten sa password

June 17, 2013 Sql server installation is either corrupt or has been tampered with error getting instance id from name

June 12, 2013 Find Weak passwords in SQL Server

June 10, 2013 Event ID 55 : The file system structure on the disk is corrupt and unusable on volume

June 06, 2013 Career in DBA

June 05, 2013 Error 3254 – The volume on device BACKUP_PATH is empty

June 04, 2013 SQL auto close - Keep it turned off

May 31, 2013 Windows Pagefile size for dedicated SQL Servers

May 30, 2013 SQL Database Corruption

May 29, 2013 max server memory and sql server memory – why is total memory greater than max memory?

May 24, 2013 Shredding XML with Powershell and SQL Server

May 23, 2013 Task Manager not showing correct SQL Server memory usage

May 22, 2013 The value of training and How to convince your boss

May 17, 2013 SQL Error 1204 - cannot obtain a LOCK resource at this time

May 16, 2013 Multi-statement table valued function and inefficient Excecution Plan

May 15, 2013 SQL Server Export to Excel with Powershell

May 14, 2013 Who dropped the table in SQL Server

May 13, 2013 List sql database roles

May 11, 2013 SQL Execution Plan - Comparing Estimated Rows and Actual Rows

May 09, 2013 DCOM got error "Logon failure: unknown user name or bad password” Event 1004

May 08, 2013 SQL Server Triggers and Performance

May 07, 2013 SQLServerAgent could not be started (reason: Error creating a new session)

May 06, 2013 Performance Tuning - Save hundreds of hours

May 04, 2013 Amount of sql server processors with sys.dm_os_schedulers

May 02, 2013 Functions and WHERE clause and suboptimal query plans

May 01, 2013 Number of physical processors with Powershell – number of cores

April 29, 2013 Cross db ownership chaining and security holes

April 26, 2013 Top 5 habits of Performance Tuning Experts

April 25, 2013 CPU 100% - Check for Parallel Queries

April 24, 2013 List files in Creation Time order with Powershell

April 23, 2013 Index Rebuild without logging

April 22, 2013 SQL Lock Escalation FAQ

April 18, 2013 Blocked Process Report and how to read

April 17, 2013 SQL sp_executesql versus EXECUTE

April 13, 2013 Types of software testing

April 11, 2013 Backup database job with SQL Server Agent

April 08, 2013 Get rowcount of all sql tables

April 05, 2013 Data Execution Prevention

April 03, 2013 Manage Transaction Logs during Index Rebuild

April 02, 2013 SQL Database Size report using Powershell

April 01, 2013 MEMORYCLERK_SQLGENERAL and sql memory memory usage

March 30, 2013 SQL Backup and Restore to UNC

March 27, 2013 Memory objects allocated by SQL Server

March 25, 2013 Error 18456 - State 5 - SQL Login Failed

March 22, 2013 Sp_updatestats RESAMPLE option

March 19, 2013 DataFileType will be assumed to be widechar because the data file has a Unicode signature

March 18, 2013 DBA - Database Architect - Data Architect - What’s the difference ?

March 14, 2013 Troubleshooting Timeout error -2146232060

March 14, 2013 Database stuck RESTORING

March 13, 2013 Place data definition statements at top of stored procedure – DDL

March 12, 2013 Select all SQL Server Functions

March 11, 2013 SQL Server Performance – Favourite posts on sqlserver-dba.com

March 09, 2013 How to check for SQL ghost records?

March 08, 2013 SQL WAIT TYPE – DTC and how to reduce it

March 07, 2013 Monitor SQL Server TempDB usage

March 06, 2013 Select all SQL Server Views

March 05, 2013 Check if current logon is the database owner – SQL Server 2000 – 2005 – 2008 - 2012 - is_member

March 04, 2013 Log cannot be reused, see the log_reuse_wait_desc column in sys.databases – SQL Server Error 9002

March 01, 2013 SQL Server has good default values

March 01, 2013 One or more files do not match the primary file of the database – Error 5173

February 28, 2013 What events are captured in SQL Transaction Logs?

February 26, 2013 Database server : Monitoring versus reporting

February 25, 2013 SQL Server SINGLE – MULTI – RESTRICTED USER

February 23, 2013 Add an extra SQL Transaction log file – ALTER DATABASE ADD LOG

February 22, 2013 SQL SSIS Package development standards

February 20, 2013 SQL Performance tuning - Drilling into the problem

February 19, 2013 SQL Performance tuning - Asking the right question

February 16, 2013 List SQL Server DBCC commands using trace 2520 – documented and undocumented commands

February 16, 2013 How to identify a SQL Server guru

February 15, 2013 Database Security Countermeasures against hacker attacks

February 14, 2013 Drop Connections with ROLLBACK IMMEDIATE to allow a Detach database

February 13, 2013 Make a database read only – READ_ONLY

February 12, 2013 Powershell write to Word document

February 11, 2013 Difference between UNIQUE CONSTRAINT versus UNIQUE INDEX

February 09, 2013 Cannot execute as the database principal

February 08, 2013 Find the database owner name from the owner_sid - t-sql and suser_sname

February 08, 2013 Database backup does not cause blocking

February 06, 2013 Msg 5042 - The file cannot be removed because it is not empty and dbcc shrinkfile emptyfile

February 04, 2013 Modify sql transaction log file size - increase or decrease

February 04, 2013 Could not find prepared statement with handle – Msg 8179

February 02, 2013 SQL Server support levels

February 01, 2013 Difference between System DSN and User DSN

January 30, 2013 Find number of connection attempts since SQL Server start - @@connections

January 30, 2013 Off the shelf software and installation prerequisites

January 29, 2013 SQL Server – How to use READ_COMMITED_SNAPSHOT isolation level

January 28, 2013 SQL Server – I want to become a DBA. What should I first learn ?

January 25, 2013 SQL Server – Min Memory Per query and performance

January 25, 2013 SQL Server - Find Default Data location and Default Log Location

January 23, 2013 SQL Server – LCK_M_IS and how to reduce it - sql wait type

January 22, 2013 SQL Server - How much resource is a SQL database using - memory, disk, IOPS,CPU

January 22, 2013 SQL Server - Powershell - Get FQDN – Hostname and IP address

January 21, 2013 SQL Server – More processor speed or cpu cores

January 20, 2013 SQL Server - Error: 18456 – Login failed for user

January 19, 2013 SQL Server – SSMS query tuning – simulate the application

January 18, 2013 SQL Server - SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed

January 17, 2013 SQL Server - AppDomain is marked for unload due to memory pressure

January 15, 2013 SQL Server – SORT IN TEMPDB and Sort Warnings

January 14, 2013 SQL Server - Preallocate SQL Transaction Logs for large queries – Initial Size

January 14, 2013 SQL Server - Find last sql statement based on SPID

January 13, 2013 SQL Server – LATCH_EX AND how to reduce it

January 11, 2013 SQL Server -Error 3041 - Backup failed to complete the command BACKUP DATABASE WITH DIFFERENTIAL

January 11, 2013 SQL Server – Archiving data into a separate database

January 10, 2013 SQL Server – Monitor SQL Transaction Log AutoGrowth for performance issues

January 09, 2013 SQL Server – Optimize delete from table - delete in sql

January 07, 2013 SQL Server - Find last time STATISTICS updated - update statistics

January 07, 2013 SQL Server – Difference between restore RECOVERY and NORECOVERY

January 05, 2013 SQL Server - Working with Windows Services Examples and Powershell

January 04, 2013 SQL Server – Bitmap filtering and Bitmap indexing

January 04, 2013 SQL Server – Export Excel data to SQL Server with Powershell

January 02, 2013 SQL Server - BobMgrGetBuf Sort Big Output Buffer write not complete after 60 seconds

January 02, 2013 SQL Server - Search and Delete files from a text based list with Powershell

January 01, 2013 SQL Server – Find who made a database security change

December 20, 2012 SQL Server – Find sql server Locks

December 19, 2012 SQL Server - How to write remove-item results to text with powershell out-file

December 17, 2012 SQL Server – Troubleshoot open cursors with sys.dm_exec_cursors

December 17, 2012 SQL Server - sys.allocation_units

December 16, 2012 SQL Server - Powershell Get-ChildItem with examples

December 14, 2012 SQL Server – DBCC CHECKDB FAQ

December 14, 2012 SQL Server – Understand Key wait resource in Blocking

December 13, 2012 SQL Server – List of Triggers

December 11, 2012 SQL Server - Error 18470 : Login failed for user. The account is disabled

December 10, 2012 SQL Server - Inside the sql transaction logs with fn_dblog and current transaction_id

December 10, 2012 SQL Server – READUNCOMMITTED, NOLOCK and dirty reads

December 08, 2012 SQL Server – Pageiolatch_ex and how to reduce it

December 07, 2012 SQL Server – Tempdb move files to another drive

December 07, 2012 SQL Server – Hover mouse over "*" sql statement to view all columns

December 06, 2012 SQL Server – Concurrency Control – Optimistic and Pessimistic

December 04, 2012 SQL Server – Read sql transaction Logs with ::fn_dblog

December 03, 2012 SQL Server – Reading and Deleting SQL Server Error Log files

December 03, 2012 SQL Server – ALTER INDEX failed due to QUOTED IDENTIFIER set to OFF

December 01, 2012 SQL Server – Ctrl+Shift+N to Script Action

November 30, 2012 SQL Server – Predict the database backup size

November 29, 2012 SQL Server – Troubleshoot memory pressure with Default Trace and Server Memory Change event class

November 28, 2012 SQL Server – DBCC SQLPERF(netstats) and network activity

November 27, 2012 SQL Server – Calculate Database memory usage with sys.dm_os_buffer_descriptors

November 26, 2012 List current SQL Server tempdb statements

November 25, 2012 SQL Server - DBCC ERRORLOG or exec master..sp_cycle_errorlog

November 25, 2012 SQL Server – How to Protect against problems

November 24, 2012 SQL Server – Database Connectivity test with Powershell

November 22, 2012 SQL Server – Change @@servername - sp_dropserver and sp_addserver

November 22, 2012 SQL Server – Troubleshooting Internal Memory pressure – stolen pages and buffer count

November 20, 2012 SQL Server - Error 701 - There is insufficient system memory

November 19, 2012 SQL Server - Use sys.dm_tran_locks to find requests waiting for an exclusive lock

November 19, 2012 SQL Server - BULK INSERT with ERRORFILE

November 18, 2012 SQL Server – Troubleshoot DBCC SHRINKDATABASE slow performance

November 17, 2012 SQL Server – How to Predict the DBCC SHRINKDATABASE finish time

November 15, 2012 SQL Server – How to Ask for support and troubleshoot problems

November 14, 2012 SQL Server – Use DB_ID() and DB_NAME() to return current database ID and current database name

November 13, 2012 SQL Server - Send sql server agent job history through email notification

November 12, 2012 SQL Server - How to detect and troubleshoot blocking and deadlocks

November 12, 2012 SQL Server - How to find Open Transactions

November 10, 2012 SQL Server - How to improve Execution Plan Reuse

November 09, 2012 SQL Server – Performance Top Queries by Total CPU Time

November 08, 2012 How to troubleshoot a slow running query in SQL Server

November 07, 2012 SQL Server – Find high impact queries with sys.dm_exec_query_stats

November 06, 2012 SQL Server – LCK_M_X and how to reduce it

November 05, 2012 SQL Server – Write everything down during problem troubleshooting

November 05, 2012 SQL Server – Find tables with page locks using sys.dm_db_index_operational_stats

November 04, 2012 SQL Server - How to check Disk Latency

November 03, 2012 SQL Server – Moving a Non Clustered Index to another filegroup

November 02, 2012 SQL Server – How to remove a sql transaction log file on a database

November 01, 2012 SQL Server – Get sql table size and last updated for all tables

October 31, 2012 SQL Server – Find SQL Server tcp port with Powershell

October 30, 2012 SQL Server – LOGBUFFER and how to reduce it

October 29, 2012 SQL Server – 500th post on sqlserver-dba.com

October 26, 2012 SQL Server – Find current user and sysadmin

October 25, 2012 SQL Server - PREEMPTIVE_OS_WRITEFILEGATHER and how to reduce it

October 24, 2012 SQL Server – Perfstats guide

October 23, 2012 SQL Server – Find last time of update on a table

October 22, 2012 SQL Server - Clear list of server names on SQL Server Management Studio

October 20, 2012 SQL Server - Diary of a DBA – Num 14 – Trichotomy of control, Dry Runs, Silver Bullets

October 19, 2012 SQL Server – Check Data and Log files are on separate drives

October 18, 2012 SQL Server - Database Server Security Audit Process

October 16, 2012 SQL Server – Datetime date range , AS400 and OPENQUERY

October 15, 2012 SQL Server –Semicolon in sql

October 13, 2012 SQL Server – Erase Phantom System Health Records – reason 193

October 12, 2012 SQL Server – Find queries causing Lock Timeouts per second

October 11, 2012 SQL Server – Memory leak detection

October 10, 2012 SQL Server – MSDB Suspect pages table and bad pages

October 09, 2012 SQL Server – Troubleshooting the SQL Profiler trace Attention class event

October 08, 2012 SQL Server – Daily Health Check Script with Powershell

October 05, 2012 SQL Server – DBA tactics

October 04, 2012 SQL Server – Differential Base Information

October 03, 2012 SQL Server – DBA Scripts

October 02, 2012 SQL Server - List Files in Size Order with Powershell

October 01, 2012 SQL Server – DBA Skills Growth Areas

September 29, 2012 SQL Server - SQLCMD with screen output and output file

September 28, 2012 SQL Server - Diary of a DBA – Num 13 – Third party applications, Stored Procedure comments, Migration Planning and Stoicism

September 27, 2012 SQL Server – An existing connection was forcibly closed by the remote host

September 25, 2012 SQL Server – Create a comma delimited sql result set

September 24, 2012 SQL Server – Open comma delimited file with DOS batch file

September 21, 2012 SQL Server - How to setup ODBC for IBM AS/400

September 20, 2012 SQL Server – Backup file information needed for RESTORE SQL database

September 19, 2012 SQL Server – large value types out of row and performance

September 18, 2012 SQL Server - Find sql database users and Find database roles

September 17, 2012 SQL Server - Find the Database File Size and Log File Size

September 16, 2012 SQL Server – Differential Backup

September 15, 2012 SQL Server – Current queries executing on SQL Server

September 14, 2012 SQL Server - Arithmetic overflow error converting expression to data type int and COUNT_BIG

September 13, 2012 SQL Server - User Could Not Execute Stored Procedure sp_enable_sql_debug

September 12, 2012 SQL Server – Aggregate expression containing an Outer Reference

September 11, 2012 SQL Server - Security Risk Analysis and database security

September 10, 2012 SQL Server – Processor priority to Background services

September 09, 2012 SQL Server - Diary of a DBA – Num 12 – Time management, Server ownership


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer