sql server 2008 related issues & queries in DbaXchanger

Restoring more than one .bak files in a TSQL query

 sql-server backup restore
Updated February 16, 2019 13:06 PM

How to clear temp database content in sql server?

 sql-server sql-server-2016 tempdb temporary-tables
Updated February 16, 2019 07:06 AM

Avoiding a full re-initialization when making changes to transactional replication

 sql-server replication
Updated February 16, 2019 02:06 AM

Where clause in an inner join in SQL Server

 sql-server sql-server-2012
Updated February 15, 2019 23:06 PM

MSSQL DB Suspect with Memory table

 sql-server restore
Updated February 15, 2019 22:06 PM

Slowly Changing Dimension table Index Optimization

 sql-server sql-server-2016 performance-tuning data-warehouse
Updated February 15, 2019 22:06 PM

Replicating into a Percona XtraDB Cluster

 mysql percona-server xtrabackup xtradb-cluster
Updated February 15, 2019 21:06 PM

sql query to check if seconday database is removed availability group

 sql-server backup availability-groups
Updated February 15, 2019 21:06 PM

Resources for learning how to read query plans

 sql-server query-performance optimization execution-plan sql-server-2017
Updated February 15, 2019 20:06 PM

Different manifestations of the same logic yield very different execution times

 sql-server query-performance optimization execution-plan sql-server-2017
Updated February 15, 2019 20:06 PM

What is wrong with my RESTORE procedure?

 sql-server t-sql restore sql-server-2016
Updated February 15, 2019 19:06 PM

Listener IP not changing after failover

 sql-server-2014 availability-groups failover listener hadr
Updated February 15, 2019 18:06 PM

SQL to return preferred duplicate rows

 sql-server duplication teradata
Updated February 15, 2019 18:06 PM

Can't seem to repair a clustered index

 sql-server corruption dbcc-checkdb dbcc-checktable
Updated February 15, 2019 18:06 PM

CONVERT to datetime fails on Dynamic SQL - "Conversion failed when converting date and/or time from character string"

 sql-server-2012 dynamic-sql datetime
Updated February 15, 2019 18:06 PM

What do I need to check why log_reuse_wait_desc keeps coming back to REPLICATION

 sql-server transaction-log
Updated February 15, 2019 17:06 PM

Optimize SQL syntax with conditional WHERE clause

 sql-server
Updated February 15, 2019 17:06 PM

Unsigned Int datatypes

 sql-server datatypes
Updated February 15, 2019 16:06 PM

How to handle normalizing the concept of a grid, and also plan for data versioning?

 sql-server-2012 normalization denormalization data-versioning sp-blitzcache
Updated February 15, 2019 16:06 PM

SQL Server 2016 still uses mixed_extent_allocation in TempDB

 sql-server-2016 tempdb database-internals extended-events
Updated February 15, 2019 15:06 PM

CNAME alias from named SQL instance to default instance

 sql-server alias
Updated February 15, 2019 15:06 PM

meaning of ## in SQL Server Profiler trace data

 sql-server profiler
Updated February 15, 2019 14:06 PM

Transparent Data Encryption - Point clarification

 sql-server-2014 availability-groups encryption transparent-data-encryption
Updated February 15, 2019 13:06 PM

SSMA Selecting Specific Trigger

 sql-server trigger ssma
Updated February 15, 2019 13:06 PM

Replication Alternatives for Contained Databases

 sql-server replication contained-database
Updated February 15, 2019 10:06 AM

SQL Server: are backups between same major/minor version but different build compatible among them?

 sql-server backup restore
Updated February 15, 2019 09:06 AM

Ιndexed view after replication

 sql-server replication performance materialized-view
Updated February 15, 2019 09:06 AM

Start service error code 3417 with SQL Server 2012

 sql-server sql-server-2012
Updated February 15, 2019 09:06 AM

Convert ASCII Bytes from XML to VARCHAR

 sql-server xml varchar type-conversion
Updated February 15, 2019 09:06 AM

Does Lazy Writer spend resources on flushing out pages from the buffer pool?

 sql-server buffer-pool lazy-writer
Updated February 15, 2019 07:06 AM

Kimball Property Data Warehouse Modeling

 sql-server sql-server-2016 data-warehouse architecture
Updated February 15, 2019 07:06 AM

Showing the report date wise in SQL SERVER REPORTING SERVICES

 sql-server-2012
Updated February 15, 2019 07:06 AM

T-sql empty closing tage instead of self closing tag

 sql-server
Updated February 15, 2019 06:06 AM

In place migration from Sql server 2014 Express to 2016 RTM

 sql-server sql-server-2014 sql-server-2016 upgrade
Updated February 15, 2019 01:06 AM

SQL Throw with TableErrorLog

 sql-server sql-server-2017 error-handling raiserror
Updated February 15, 2019 01:06 AM

NULL Agent Timing Out

 sql-server replication
Updated February 15, 2019 00:06 AM

Creating login/user for Always on Environment

 sql-server sql-server-2014 sql-server-2016 availability-groups
Updated February 14, 2019 23:06 PM

Problem with Sql Query to MySql Query

 sql-server mysql query-performance query concat
Updated February 14, 2019 23:06 PM

User defined data types causing implicit conversions

 sql-server sql-server-2008-r2 type-conversion user-defined-type
Updated February 14, 2019 22:06 PM

Why Do My Nonclustered Indexes Use More Space When I Delete Rows?

 sql-server sql-server-2014 nonclustered-index
Updated February 14, 2019 22:06 PM

Ghost Cleanup process has high CPU usage in SQL Server 2012 SP1

 sql-server sql-server-2012 ghost-cleanup
Updated February 14, 2019 21:06 PM

SQL Server 2008 encrypted connection using multiple server names

 sql-server sql-server-2008-r2 configuration connectivity
Updated February 14, 2019 21:06 PM

Filter by using in for SQL Server

 sql-server sql-server-2012
Updated February 14, 2019 19:06 PM

Error in 'Master Database Restore' in SQL Server 2012 (Because of difference in SQL Server Build)

 sql-server sql-server-2012
Updated February 14, 2019 18:06 PM

What is the best way to calculate year over year inflation?

 sql-server sql-server-2008
Updated February 14, 2019 17:06 PM

Transactional Replication hangs when huge transactions flow

 sql-server sql-server-2014 transactional-replication
Updated February 14, 2019 16:06 PM

One way replication between 2 sql servers on different networks

 sql-server replication sql-server-2016
Updated February 14, 2019 16:06 PM

File Share Witness with 4 Node Cluster

 sql-server clustering high-availability failover hadr
Updated February 14, 2019 16:06 PM

Setting up a many-to-many relationship based off of two other many-to-many relationships

 sql-server database-design sql-server-2012 sql-server-2016 erd
Updated February 14, 2019 15:06 PM

FOR XML could not serialize the data for node 'col_definition'

 sql-server-2012 sp-blitz sp-blitzfirst
Updated February 14, 2019 15:06 PM
Showing Page 1 of 0

Query Search

Categories