sql server 2008 related issues & queries in DbaXchanger

Sub query to return same number of records and join

 sql-server
Updated October 19, 2018 14:06 PM

SQL Server - Bulk load blocking queries on heaps

 sql-server
Updated October 19, 2018 14:06 PM

Msg 8985, Level 16, State 1,Could not locate file 'MyTal_Log'

 sql-server sql-server-2017
Updated October 19, 2018 13:06 PM

How to copy selected table data from sql server to mysql on a daily basis?

 sql-server mysql migration etl copy
Updated October 19, 2018 13:06 PM

Computed column cannot be persisted because the column is non-deterministic

 sql-server sql-server-2012 computed-column
Updated October 19, 2018 11:06 AM

Can both primary and secondary servers be online simultaneously in Log Shipping?

 sql-server log-shipping primary-server
Updated October 19, 2018 10:06 AM

Cross-database chaining in SQL Server

 sql-server
Updated October 19, 2018 09:06 AM

Insert into a table selecting data from a sub query

 sql-server sql sql-server-2012 t-sql join
Updated October 19, 2018 07:06 AM

Newbie Clustered Index question - when to NUSE?

 sql-server index clustered-index
Updated October 19, 2018 05:06 AM

How can I permanently remove replication by script if I only have access to the subscriber?

 sql-server replication sql-server-2014
Updated October 19, 2018 00:06 AM

SQL Bulk Insert Performance: Bulk Logged or Simple Recovery Mode?

 sql-server database-design sql-server-2016 bulk-insert recovery-model
Updated October 18, 2018 23:06 PM

Isolation level of queries to system objects, object catalog views etc

 sql-server
Updated October 18, 2018 22:06 PM

Grouping on an expression (and possible HAVE)

 sql-server
Updated October 18, 2018 18:06 PM

Get data from a MDX linked server and use it on a FROM clause on SQL without OPENQUERY

 sql-server sql-server-2012
Updated October 18, 2018 18:06 PM

Best Way to Index Multiple Effective Date Columns

 sql-server t-sql index sql-server-2016 index-tuning
Updated October 18, 2018 17:06 PM

Slow Query with RESOURCE_SEMAPHORE wait info

 sql-server parallelism wait-types load
Updated October 18, 2018 17:06 PM

sparse column or DATA_COMPRESSION?

 sql-server query-performance sql-server-2016 compression sparse-column
Updated October 18, 2018 15:06 PM

Auto Service Restart During SQL Server 2016 Standard to Enterprise Upgrade?

 sql-server-2016 upgrade enterprise-edition
Updated October 18, 2018 15:06 PM

Trouble dealing with deadlock in a Dynamics NAV 2009 instance

 sql-server-2014 deadlock microsoft-dynamics
Updated October 18, 2018 15:06 PM

Really Small details about storage ( data size ) on columns

 sql-server-2008-r2
Updated October 18, 2018 15:06 PM

How can I get the last second of the last month as a default parameter value?

 sql-server-2008-r2 datetime ssrs-2008-r2
Updated October 18, 2018 15:06 PM

Encrypting table in SQL Server

 t-sql sql-server-2016 encryption
Updated October 18, 2018 14:06 PM

Unpivot avoid cartesian product on empty columns

 sql-server unpivot
Updated October 18, 2018 13:06 PM

Sql server 200 r2 auditing

 sql-server
Updated October 18, 2018 11:06 AM

Long running SQL Server Query, eats up a lot of resource

 sql-server index query-performance query cte
Updated October 18, 2018 11:06 AM

How to get information about query plans that are out of cache?

 sql-server execution-plan
Updated October 18, 2018 10:06 AM

How can I get SQL to do the sensible thing without resorting to a query hint?

 sql-server sql-server-2008 index query-performance
Updated October 18, 2018 09:06 AM

Slow response time showing in resource management for MDF file - known issue on ESX?

 sql-server vmware disk-structures
Updated October 18, 2018 08:06 AM

Hash Functions and SQL Server Unique Index Collision rates

 sql-server index sql-server-2016 security hashing
Updated October 18, 2018 07:06 AM

Should Clustered Columnstore Index be the default standard now for Data warehouse?

 sql-server database-design sql-server-2016 performance-tuning columnstore
Updated October 18, 2018 03:06 AM

Distributor job in SQL Server replication

 sql-server replication
Updated October 17, 2018 22:06 PM

Remote Scan: What are some performance tuning techniques to improve a query when this operator is the bottleneck?

 sql-server sql-server-2008-r2 query-performance optimization performance-tuning
Updated October 17, 2018 21:06 PM

SSIS ETL or CDC - real time DWH reporting

 sql-server sql-server-2012 data-warehouse etl
Updated October 17, 2018 21:06 PM

Standard Process during a disaster

 sql-server-2012 clustering connectivity log-shipping disaster-recovery
Updated October 17, 2018 20:06 PM

why when I change a column from DATETIME to DATE, I can't see any storage improvement?

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

What is the algorithm behind Except statement

 sql-server sql-server-2016 performance-tuning hashing
Updated October 17, 2018 20:06 PM

Recreating Layers based on data already entered

 sql-server sql-server-2014 query structured-query-language
Updated October 17, 2018 19:06 PM

Why am I getting an error about truncation when running an SSIS job?

 sql-server sql-server-2012 ssis
Updated October 17, 2018 18:06 PM

Migrating VM SQL Server databases from Azure to RDS AWS

 sql sql-server-2012 amazon-rds azure
Updated October 17, 2018 18:06 PM

Database Log File Growth change does not reflect on secondary replica sys.master_files

 sql-server sql-server-2014 auto-growth
Updated October 17, 2018 17:06 PM

Unable to use plan guide with sp_execute

 sql-server-2017 plan-guides
Updated October 17, 2018 16:06 PM

sql server management studio enable encryption

 sql-server encryption
Updated October 17, 2018 16:06 PM

How many partitions should I make for my clustered columnstore index tables? Should I partition the rowstore tables also?

 sql-server sql-server-2016 partitioning columnstore
Updated October 17, 2018 15:06 PM

Can one of Windows failover cluster nodes run on Linux?

 sql-server linux clustering
Updated October 17, 2018 15:06 PM

Restore msdb from SQL Server 2008 R2 to SQL Server 2012 instance

 sql-server sql-server-2008-r2 sql-server-2012
Updated October 17, 2018 13:06 PM

Executing stored proc in a SQL Agent Job fails on secondaries within a High Availability group with a sys.fn_hadr_is_primary_replica guard

 stored-procedures sql-server-agent high-availability sql-server-2017
Updated October 17, 2018 12:06 PM

Concurrent backups in MS SQLServer 2008 R2

 sql-server backup concurrency
Updated October 17, 2018 11:06 AM

Reduce query time for higher offset in sql server

 sql-server query-performance
Updated October 17, 2018 08:06 AM

same ssrs report tow different names subscriptions

 sql-server sql sql-server-2012
Updated October 17, 2018 07:06 AM

Difference between OLTP and Inmon Data Warehouse

 sql-server database-design data-warehouse architecture
Updated October 17, 2018 05:06 AM
Showing Page 1 of 0

Query Search

Categories