sql server 2008 related issues & queries in DbaXchanger

SQL Server(sym408)

 sql-server database-design
Updated April 21, 2019 18:06 PM

Find percent of associated items from multiple tables

 sql-server
Updated April 21, 2019 11:06 AM

Log for database tempdb is not available

 sql-server tempdb log
Updated April 21, 2019 08:06 AM

Finding all users with Acccess to a table in SQL server

 sql-server security
Updated April 20, 2019 16:06 PM

Configure CPU/IO affinity - SQL 2017 Standard

 sql-server sql-server-2017
Updated April 20, 2019 15:06 PM

Best method of creating constant value

 database-design sql-server-2016
Updated April 20, 2019 14:06 PM

Optimize MySql Self Cross Join and Grouping - Preorder Tree Traversal Algorithm

 sql-server mysql optimization tree
Updated April 20, 2019 13:06 PM

In memory table vs temporary table - benefits if temdb in already on ram disk

 sql-server sql-server-2016 tempdb in-memory-database
Updated April 20, 2019 08:06 AM

SQL Server: how to get statistics sizes?

 sql-server t-sql statistics
Updated April 19, 2019 21:06 PM

SSISDB Start and Stop time for each Package

 sql-server sql-server-2016 ssis
Updated April 19, 2019 20:06 PM

How to import blanks as nulls instead of zeros while importing txt using wizard

 sql-server sql-server-2012 import integer
Updated April 19, 2019 20:06 PM

Restore database from backup file of different version / edition

 sql-server compatibility-level
Updated April 19, 2019 20:06 PM

is it possible to trim the table output for a specific job?

 sql-server jobs scripting logs troubleshooting
Updated April 19, 2019 14:06 PM

Sync postgreSQL with SQL Server database- on data change event

 sql-server postgresql replication data-synchronization
Updated April 19, 2019 11:06 AM

SQL Server replication - Could not add new article to publication

 sql-server replication
Updated April 19, 2019 11:06 AM

Differences between CTE and subquery select tables

 sql-server t-sql subquery cte
Updated April 19, 2019 10:06 AM

Database recovery pending on external drive

 sql-server sql-server-2016
Updated April 19, 2019 09:06 AM

Create indexed view with fluctuating data behind

 sql-server view materialized-view
Updated April 19, 2019 08:06 AM

SQLServer - Multiple PIVOT on same column

 sql-server
Updated April 19, 2019 06:06 AM

SQL operators Doubt

 sql-server mysql
Updated April 18, 2019 23:06 PM

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

 sql-server query-performance performance-tuning parallelism scalar-function
Updated April 18, 2019 22:06 PM

pivot vs multiple columns

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

Tracking stored procedure usage

 sql-server sql-server-2008 statistics
Updated April 18, 2019 21:06 PM

My Temp db is full

 sql-server tempdb
Updated April 18, 2019 18:06 PM

Is it possible for SQL statements to execute concurrently within a single session in SQL Server?

 sql-server sql-server-2012
Updated April 18, 2019 18:06 PM

Multiple inserts using select row and variable combination with one SQL statement

 sql-server sql-server-2008 insert
Updated April 18, 2019 17:06 PM

Query takes 10+ minutes to execute

 sql-server t-sql
Updated April 18, 2019 17:06 PM

Merge Only Events that Start immediately after the Previous Event without any Gap

 sql-server gaps-and-islands date-math
Updated April 18, 2019 17:06 PM

SQL Job Agent Service Account - Access is denied to run Powershell

 sql-server-2008-r2
Updated April 18, 2019 17:06 PM

How can you have a Buffer cache hit ratio of 100% with PLE of 103?

 sql-server performance sql-server-2017 plan-cache
Updated April 18, 2019 17:06 PM

SQL Server database size didn't decrease after deleting large number of rows.

 sql-server sql-server-2005
Updated April 18, 2019 17:06 PM

What is the appropriate index architecture when forced to implement IsDeleted (soft deletes)?

 sql-server sql-server-2012 index
Updated April 18, 2019 15:06 PM

Why doesn't SQL Optimizer use my constraint?

 t-sql sql-server-2016
Updated April 18, 2019 15:06 PM

How to setup encryption on a column that joins two tables in two different databases

 sql-server-2012 encryption
Updated April 18, 2019 15:06 PM

Run Powershell Script From Agent As Administrator

 sql-server-2014 powershell windows-server-2012
Updated April 18, 2019 13:06 PM

Is there any way to find information of index fragmentation, Statistics information with the help of system tables in SQL Server

 sql-server sql-server-2012
Updated April 18, 2019 13:06 PM

I want to change to Dynamic SQL Query instead of CASE statement

 sql-server sql-server-2012 sql-server-2008 sql-server-2014 sql-server-2016
Updated April 18, 2019 11:06 AM

Shirking of Log file on Primary Server of Transaction Log shipping

 sql-server sql-server-2012 transaction-log high-availability log-shipping
Updated April 18, 2019 09:06 AM

SQL Server Internal Memory Error

 sql-server sql-server-2016 memory-optimized-tables
Updated April 18, 2019 09:06 AM

Can a user with readonly access change SQL server settings

 sql-server configuration users
Updated April 18, 2019 04:06 AM

If a VARCHAR(MAX) column is included in an index, is the entire value always stored in the index page(s)?

 sql-server varchar
Updated April 17, 2019 23:06 PM

SSIS script task - Execute Dataflow task based on variable value

 sql-server ssis
Updated April 17, 2019 20:06 PM

Removing large image files from production database

 sql-server filestream
Updated April 17, 2019 20:06 PM

Is there such thing as an Availability Group failover trigger?

 sql-server
Updated April 17, 2019 20:06 PM

LUN for Database / Instance

 sql-server storage metadata
Updated April 17, 2019 19:06 PM

SSIS Recordset Destination error

 sql-server ssis etl
Updated April 17, 2019 19:06 PM

Prevent 'Last' Trigger from firing unnecessarily

 sql-server-2008-r2 trigger
Updated April 17, 2019 18:06 PM

Store Procedure Parameter Name Auto Completion

 sql-server
Updated April 17, 2019 17:06 PM

Maintain a large OLTP SQL Database

 sql-server sql-server-2017 maintenance
Updated April 17, 2019 17:06 PM

CTE Query to CONCAT text (over 10,000 rows)

 sql-server sql-server-2012 query-performance cte recursive
Updated April 17, 2019 16:06 PM
Showing Page 1 of 0

Query Search

Categories