sql server 2008 related issues & queries in DbaXchanger

How does a linked server based select statement works in SQL Server?

sql-server linked-server
Updated June 22, 2018 03:06 AM

SQL Transaction Log Shipping Status Primary Server not Shown on Secondary Monitoring Server

sql-server sql-server-2012 log-shipping
Updated June 22, 2018 00:06 AM

What is the best solution to catch and alert me to run a FULL backup to shrink the nightly DIFF when it grows too big?

sql-server t-sql backup alerts
Updated June 21, 2018 23:06 PM

Read Committed Snapshot Isolation vs Read Committed - pros and cons?

sql-server isolation-level
Updated June 21, 2018 23:06 PM

Portability of stored procedures between different vendors

sql-server stored-procedures migration aws cloud
Updated June 21, 2018 22:06 PM

Preserving existing logins during database refresh

sql-server sql-server-2014 logins
Updated June 21, 2018 21:06 PM

SQL Server Distributed Availability Group with Manual Seeding

sql-server sql-server-2017 distributed-availability-groups
Updated June 21, 2018 21:06 PM

ALTER DATABASE MODIFY FILEGROUP [myfilegroup] AUTOGROW_ALL_FILES

sql-server sql-server-2016
Updated June 21, 2018 19:06 PM

Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server

sql-server backup dbcc-checkdb process
Updated June 21, 2018 18:06 PM

SQL Read Committed Snapshot Isolation Remove All Writer/Read Contention

sql-server performance-tuning isolation-level
Updated June 21, 2018 17:06 PM

SQL 2012 master database corrputed

sql-server-2012
Updated June 21, 2018 16:06 PM

Why is CDC capture failing due to a missing dbo principal

sql-server sql sql-server-2008 change-data-capture
Updated June 21, 2018 16:06 PM

“SQL command” vs “Table or view” when importing entire tables

sql-server sql-server-2012 ssis ssis-2012
Updated June 21, 2018 15:06 PM

Execution time high for Query in sp_executesql

sql-server query-performance execution-plan dynamic-sql
Updated June 21, 2018 15:06 PM

Cannot find query in plan cache and query execution times different for different paramters

sql-server query-performance execution-plan performance-tuning plan-cache
Updated June 21, 2018 15:06 PM

SQL Server - materialised (indexed) view not working as expected

sql-server materialized-view
Updated June 21, 2018 15:06 PM

Using SQL Server Distributed AG with Primary and Forwarder Only

sql-server availability-groups high-availability sql-server-2017 distributed-availability-groups
Updated June 21, 2018 14:06 PM

The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys' (Error 229)

sql sql-server-2014 logins
Updated June 21, 2018 14:06 PM

List primary replicas and non-HA databases - excluding forwarder replicas

sql-server availability-groups dmv distributed-availability-groups
Updated June 21, 2018 13:06 PM

MSOLEDBSQL syntax when using OPENROWSET

sql-server
Updated June 21, 2018 13:06 PM

How to copy & paste "Missing Index" in "Execution plan" tab of SSMS?

sql-server ssms
Updated June 21, 2018 13:06 PM

Migrate SQL Server to Oracle 11G Offline

sql-server oracle
Updated June 21, 2018 13:06 PM

Get Table Defintion

sql-server sql-server-2014 table
Updated June 21, 2018 12:06 PM

SQL Server 2012 Visualization of Table relationships

sql-server-2012
Updated June 21, 2018 11:06 AM

SQL Cluster failover doesn't work after applying SQL Server 2016 Service Pack 2

sql-server-2016
Updated June 21, 2018 11:06 AM

Stored procedure with union Table from multiple DB taken Master.db

sql-server t-sql stored-procedures sql-server-2016
Updated June 21, 2018 10:06 AM

CONVERT_IMPLICIT when inserting a Geography datatype into a Geography datatype column on Temp Table

sql-server sql-server-2008-r2 tempdb spatial
Updated June 21, 2018 09:06 AM

Calculate Consumption from Reading Table

sql-server sql sql-server-2014 subquery ms-access-2010
Updated June 21, 2018 08:06 AM

how to avoid insertion of the two entries in database by two users which are working in same application with same database?

sql-server-2012
Updated June 21, 2018 07:06 AM

How they calculating "AssignmentBaseline0Work" in below query?

sql sql-server-2008
Updated June 21, 2018 06:06 AM

SQL Database Read Committed Snapshot Isolation for OLTP and Reports

sql-server performance-tuning isolation-level snapshot-isolation
Updated June 21, 2018 00:06 AM

EF Query as RPC - is it parameter sniffing?

sql-server query-performance entity-framework parameter-sniffing
Updated June 20, 2018 23:06 PM

Convert string numeric values with comma as decimal separator to NUMERIC(10, 2)

sql-server t-sql type-conversion string decimal
Updated June 20, 2018 22:06 PM

Read Only Access Except Stored Procedures in Specific Schema

sql-server permissions security
Updated June 20, 2018 21:06 PM

MS SQL Server: Replication Monitor Transactional Replication Publisher Log Reader Agent Latency Too High?

sql-server transactional-replication
Updated June 20, 2018 20:06 PM

Error 1456 when trying to SET a Witness using TSQL

sql-server mirroring
Updated June 20, 2018 20:06 PM

SQL Trigger Find Deleting Job Agent History

sql-server sql-server-2012 sql-server-agent
Updated June 20, 2018 18:06 PM

Create a unique constraint on a column based on distinct value from another column in the same table

sql-server sql sql-server-2014 constraint unique-key
Updated June 20, 2018 18:06 PM

How to connect to a SQL Server from another computer using SSMS with only hostname?

sql-server aws amazon-ec2
Updated June 20, 2018 18:06 PM

MS SQL Server: Transactional replication not working but no errors are present

sql-server oracle replication transactional-replication
Updated June 20, 2018 18:06 PM

Does cost of an Operation matter.?

sql-server query-performance performance-tuning clustered-index
Updated June 20, 2018 18:06 PM

Database subsetting a viable method of slicing a database?

sql-server
Updated June 20, 2018 17:06 PM

Merge multiple rows into fewest number of rows of distinct values

sql-server sql sql-server-2012 pivot
Updated June 20, 2018 16:06 PM

High IO on index, is there a more performant solution?

sql-server t-sql sql-server-2016 execution-plan
Updated June 20, 2018 15:06 PM

Poor UnionAggregate (CLR aggregate) performance - CPU cost hint?

sql-server aggregate spatial sql-clr
Updated June 20, 2018 15:06 PM

Keeping database in synch

sql-server migration data-synchronization
Updated June 20, 2018 14:06 PM

Automating Alerting on Blocking with Queues and Event Notifications

sql-server blocking event-notification queue
Updated June 20, 2018 12:06 PM

Auto generated query not working

sql-server
Updated June 20, 2018 12:06 PM

How can I reuse listener names when moving AO groups to new servers

sql-server-2012 sql-server-2016 availability-groups
Updated June 20, 2018 12:06 PM

SQL Maintenance script not running in command prompt

sql-server-2012 sql-server-express ola-hallengren
Updated June 20, 2018 10:06 AM

Showing Page 1 of 0