sql server 2008 related issues & queries in DbaXchanger

Parameter sniffing work arounds

 sql-server sql parameter-sniffing
Updated April 21, 2018 23:06 PM

SQL Server 2016 ALTER DATABASE SET ALLOW_SNAPSHOT_ISOLATION ON takes forever

 sql-server sql-server-2016
Updated April 21, 2018 16:06 PM

SQL Server 2012 Index Reorganize Logfile Growth

 sql-server
Updated April 21, 2018 14:06 PM

Finding rows with same id but different date

 sql-server sql-server-2012
Updated April 21, 2018 13:06 PM

Deadlock killing update statement when collided with select

 sql-server
Updated April 21, 2018 10:06 AM

Adding extra total column that sums all column values on each row

 sql sql-server-2014
Updated April 21, 2018 10:06 AM

SSIS compatibility

 sql-server ssis
Updated April 21, 2018 09:06 AM

Best way to remap database login to new database user and keep previous database user

 sql-server sql-server-2008-r2 authentication users
Updated April 21, 2018 01:06 AM

Severity 20 Error upon disconnecting Dedicated Administrator Connection

 sql-server
Updated April 20, 2018 22:06 PM

SQL Server instance running out of worker threads

 sql-server sql-server-2008-r2 sharepoint
Updated April 20, 2018 21:06 PM

Why is my query suddenly slower than it was yesterday?

 sql-server query-performance execution-plan parameter-sniffing
Updated April 20, 2018 21:06 PM

Cancelling the rebuilding of a partition with compression

 sql-server index sql-server-2017 compression rollback
Updated April 20, 2018 19:06 PM

Can database mirroring and AG be used in a single SQL Server instance

 sql-server-2012
Updated April 20, 2018 19:06 PM

No Implicit Conversion Between UNIQUEIDENTIFIER and VARCHAR After Removing a Persisted Computed Column

 sql-server
Updated April 20, 2018 18:06 PM

Creating a Persisted Computed Column with a function

 sql-server sql-server-2008 computed-column
Updated April 20, 2018 17:06 PM

Moved 'tempdb', now file 'tempdev2' does not exist

 sql-server sql-server-2008 sql-server-2008-r2 tempdb
Updated April 20, 2018 17:06 PM

How to resolve Error 7311 returned by a job running against a linked server?

 sql-server sql sql-server-2008-r2
Updated April 20, 2018 17:06 PM

Why do Statistic recommendations disappear from DB Tuning Advisor after implementing recommended indexes?

 sql-server sql-server-2008-r2 performance-tuning index-statistics
Updated April 20, 2018 15:06 PM

How to optimise a query where filtering is done on one table and sorting on another

 sql-server query-performance optimization data-warehouse
Updated April 20, 2018 15:06 PM

Improve performance of SUM query

 sql-server sql-server-2012
Updated April 20, 2018 15:06 PM

Does XP_API deprecation announcement mean that sp_executesql will not be supported in the future?

 sql-server sql-server-2008-r2 extended-events extended-stored-procedure
Updated April 20, 2018 15:06 PM

Automatic insertion of calculated values to another

 sql-server database-design sql-server-2012
Updated April 20, 2018 14:06 PM

SSMA for Access - Migration Assistant Wizard fails at link tables

 sql-server ms-access ssma
Updated April 20, 2018 14:06 PM

View SQL Server Agent jobs -> MSDB roles

 sql-server sql-server-2016 sql-server-agent jobs
Updated April 20, 2018 13:06 PM

Get-Parameter not fetching results

 sql-server powershell
Updated April 20, 2018 12:06 PM

PIVOT, Row_Number() returning multiple rows

 sql-server sql pivot
Updated April 20, 2018 12:06 PM

Insert statement on one table blocking delete on another unrelated table on sql server

 sql-server transaction blocking
Updated April 20, 2018 10:06 AM

Optimize Query UNION ALL

 sql-server sql t-sql optimization execution-plan
Updated April 20, 2018 09:06 AM

Optimize wildcard searching in a nVARCHAR(MAX) field

 sql index sql-server-2014 full-text-search
Updated April 20, 2018 09:06 AM

Bad performance using BETWEEN in JOIN

 sql-server sql t-sql query-performance
Updated April 20, 2018 07:06 AM

How to get data from two rows which has same data in all columns except one in MSSQL

 sql-server sql-server-2008
Updated April 20, 2018 05:06 AM

Database enters in recovery mode every time the Transaction Log is full

 sql-server sql-server-2012 transaction-log recovery-model
Updated April 20, 2018 01:06 AM

SQL Server Dynamic Ports are being set to different ports

 sql-server sql-server-2014 network
Updated April 19, 2018 23:06 PM

SQL Server 2008 R2 - Capture or be notified when an sql handle is ran

 sql-server sql-server-2008-r2
Updated April 19, 2018 21:06 PM

ComputerNamePhysicalNetBIOS and "Current Host Server" shows different machines

 sql-server sql-server-2008 sql-server-2008-r2 clustering failover
Updated April 19, 2018 20:06 PM

Comparing dates with different format than default

 sql-server sql c# date visual-studio-2010
Updated April 19, 2018 19:06 PM

allow user to enter date&time and save it db

 sql-server datetime c# visual-studio
Updated April 19, 2018 19:06 PM

Inserting fetched records into new table

 sql-server sql-server-2012
Updated April 19, 2018 14:06 PM

Connect to Oracle from SQL Server

 sql-server oracle t-sql
Updated April 19, 2018 13:06 PM

OPTION(RECOMPILE) vs OPTION(FAST n)

 sql-server optimization
Updated April 19, 2018 09:06 AM

Automatic insertion of calculated values to another table

 sql-server-2012
Updated April 19, 2018 09:06 AM

Design for a basic Double Entry account system

 sql-server sql
Updated April 19, 2018 03:06 AM

Is B-Tree restructured during deletion of data from SQL Server table with a clustered index?

 sql-server index optimization
Updated April 19, 2018 00:06 AM

Restore SQL Server DB encrypted by EKM - where's the asymmetric key?

 sql-server security encryption transparent-data-encryption hsm
Updated April 18, 2018 22:06 PM

Merge Replication Business Logic Handler Incorrect Encoding when connecting to SQL

 sql sql-server-2008-r2 merge-replication encoding
Updated April 18, 2018 22:06 PM

Ola Hallegren backup procedure 3009 backup msdb history error

 sql sql-server-2012
Updated April 18, 2018 21:06 PM

source control for SQL Agent Jobs

 sql-server sql-server-2008-r2 source-control
Updated April 18, 2018 21:06 PM

Regular data transfer from MSSQL to MySQL

 sql-server mysql database-design migration c#
Updated April 18, 2018 20:06 PM

How can I configure SQL Server Aliases on a SQL Server Client Machine

 sql-server sql-server-2016 configuration-manager
Updated April 18, 2018 17:06 PM

Which CLR Stored Proc is causing memory pressure leading to sqlservr.exe terminating unexpectedly?

 sql-server sql-clr
Updated April 18, 2018 17:06 PM
Showing Page 1 of 0

Query Search

Categories