sql server 2008 related issues & queries in DbaXchanger

Troubleshooting Slow SQL which runs for milliseconds

 sql-server performance sql-server-2014 query-performance
Updated August 14, 2018 22:06 PM

HADR wait on servers without HA configured

 sql-server sql-server-2012 availability-groups
Updated August 14, 2018 22:06 PM

Add SQL Server Agent to existing SQL Installation

 sql-server sql-server-2016
Updated August 14, 2018 19:06 PM

Remote harden of transaction 'CREATE INDEX' - when moving an index to a different filegroup

 sql-server index sql-server-2016 transaction-log index-maintenance
Updated August 14, 2018 18:06 PM

Transaction log shipping

 sql-server sql sql-server-2008 transaction-log
Updated August 14, 2018 17:06 PM

Frequency of SQL DB Full and Differential backups

 sql-server backup
Updated August 14, 2018 17:06 PM

SQL Server 2016 SP2 CU2 Availability Group Online but Cluster Offline

 sql-server-2016 availability-groups clustering
Updated August 14, 2018 16:06 PM

What permissions does HAS_DBACCESS check?

 sql-server t-sql permissions
Updated August 14, 2018 14:06 PM

Find out recovery model changes

 sql sql-server-2014 backup dmv recovery-model
Updated August 14, 2018 14:06 PM

TSQL Validate Data between 2 large tables

 sql-server-2012 t-sql sql-server-2014 pt-table-checksum bigtable
Updated August 14, 2018 13:06 PM

switch TOP clause between percentage and rows by parameter

 sql-server t-sql sql-server-2005 dynamic-sql parameter
Updated August 14, 2018 07:06 AM

Optimise select distinct from large table

 sql-server-2012 t-sql optimization
Updated August 14, 2018 07:06 AM

SQL Server: Find out unused queries

 sql-server query
Updated August 14, 2018 07:06 AM

Cannot start sql server in antergos linux: Unit mssql-server.service has a bad unit file setting

 sql-server linux
Updated August 14, 2018 06:06 AM

JSON subquery using WITHOUT_ARRAY_WRAPPER returning odd data?

 sql-server subquery sql-server-2016 json
Updated August 14, 2018 04:06 AM

How to find the list of SQL Server jobs using PowerShell?

 sql-server jobs powershell
Updated August 14, 2018 02:06 AM

When to run sp_refresh_parameter_encryption while using Always Encrypted?

 sql-server-2016 encryption always-encrypted
Updated August 14, 2018 02:06 AM

File Extensions are missing from new SSMS 2012

 sql-server t-sql sql-server-2012
Updated August 14, 2018 00:06 AM

Why select query is waiting on HADR_SYNC_COMMIT?

 sql-server availability-groups
Updated August 13, 2018 20:06 PM

Session close unexpectedly destroying temporary table

 sql-server sql-server-2016
Updated August 13, 2018 18:06 PM

Sync point of SQL Server backup

 sql-server
Updated August 13, 2018 17:06 PM

Always On - Question Mark on the Primary and Other Secondary Replicas in the Object Explorer?

 sql-server availability-groups
Updated August 13, 2018 17:06 PM

Transaction replication from SQL Azure database to on-premise SQL server

 sql-server replication azure-sql-database sql-data-sync
Updated August 13, 2018 16:06 PM

sp_blitzCache Long Running Query Warning threshold

 sql-server sp-blitzcache
Updated August 13, 2018 16:06 PM

How to limit SQL Server sessions based on hostname?

 sql sql-server ssms
Updated August 13, 2018 15:06 PM

New SQL Server 2016 Ent only using 4GB of 768GB RAM

 sql-server-2016
Updated August 13, 2018 15:06 PM

Query over SSRS/RPC:Completed a lot slower than SSMS

 sql-server performance query-performance execution-plan
Updated August 13, 2018 15:06 PM

Why would a query in code be slower than a query in a SQL tool

 sql-server sql query-performance ssms
Updated August 13, 2018 15:06 PM

Foreign Key with a Constant

 sql-server database-design sql-server-2014 foreign-key constraint
Updated August 13, 2018 14:06 PM

Estimate transaction log size for single transaction

 sql-server transaction-log
Updated August 13, 2018 14:06 PM

Display table names in titles in SQL Server Management Studio

 sql-server ssms
Updated August 13, 2018 11:06 AM

Is Microsoft SQL Server 2016 fully ANSI SQL-92 compliant?

 sql-server sql-server-2016 sql-standard
Updated August 13, 2018 11:06 AM

SQL Server Agent stopped - Event ID 17052

 sql-server sql-server-2014 sql-server-agent
Updated August 13, 2018 11:06 AM

Clustered Index 'Seek predicate' and 'predicate' on the same column

 sql-server index
Updated August 13, 2018 09:06 AM

SQL Server 2017 Installation issues

 sql-server installation
Updated August 13, 2018 09:06 AM

Rolling sum / count / average over date interval- Msg 206 error [MS SQL]

 sql-server
Updated August 13, 2018 08:06 AM

utf8mb4 in SQL Server Express

 mysql collation sql-server-express character-set migration
Updated August 13, 2018 07:06 AM

Query with conditional JOIN running slow

 sql-server-2014 join execution-plan statistics union
Updated August 13, 2018 05:06 AM

sys.dm_hadr_database_replica_states, understanding the different *_time

 sql-server-2014 availability-groups
Updated August 13, 2018 03:06 AM

Web interface or tool for developers to run select query with out access database directly

 sql-server mysql database-design mysqldump
Updated August 12, 2018 17:06 PM

Clone SQL Server databases

 sql-server sql sql-server-2012 sql-server-2008
Updated August 12, 2018 14:06 PM

Select data from a table while update is running within a transaction in SQL Server

 sql-server locking transaction
Updated August 12, 2018 12:06 PM

how to shrink(and also reduce size on disk) a very big log file in SQL server 2016

 sql-server-2016 shrink log in-memory-database
Updated August 12, 2018 12:06 PM

Parent id and child id concept

 sql-server sql postgresql oracle mysql-5.5
Updated August 12, 2018 11:06 AM

Documenting where stored procs are called from

 sql-server-2012
Updated August 11, 2018 21:06 PM

How to use COALESCE with multiple rows and without preceding comma?

 sql-server sql t-sql
Updated August 11, 2018 14:06 PM

Improve T-SQL query

 sql-server performance query-performance optimization
Updated August 11, 2018 07:06 AM

AG Automatic Failover

 sql-server availability-groups high-availability disaster-recovery
Updated August 11, 2018 02:06 AM

Mirrored TDE DB Performance

 sql-server-2014 mirroring transparent-data-encryption
Updated August 10, 2018 20:06 PM

Expanding Data File with Log Shipping and Mirroring: SQL Server 2008 R2

 sql-server sql-server-2008 log-shipping
Updated August 10, 2018 18:06 PM
Showing Page 1 of 0

Query Search

Categories