sql-server-2008-r2

  1. SSIS ETLs deadlocking

  2. SSIS Excel source not mapping all columns

  3. Improve Parameterized Query Performance
  4. SQL Server Database Mirroring : strange client application behavior upon failover
  5. Improve reporting stored procedure execution time - tuning temporary tables?

  6. How can I take backup of particular tables in SQL Server 2008 using T-SQL Script

  7. Select Permissions Across Multiple Schemas Within the Same Database
  8. Convert rfc822 to either a GMT DATETIME or Unix timestamp in SQL Server

  9. SQL Server 2008 R2 DB grows overnight and slow

  10. SQL Server - How is a row updated under the hood?

  11. SQL Server doesn't send intermediate SSL certificates
  12. Parent-Child Tree Hierarchical ORDER

  13. Move multiple databases from C: to D: at once

  14. Log all errors in queries
  15. sql server 2008 R2 SP3 update is not showing even after update was successful from RTM to SP3

  16. SQL Server table name starting with # in user database, not in tempdb, not a temp table

  17. Need FLOAT datatype with 2 digits after decimal point when importing from a CSV file

  18. Can't update "CO2" to "CO₂" in table row

  19. SQL Databases Linked to applications
  20. Performance issues after moving a database to SQL Server 2014

  21. Upgrading SQL Server 2008 R2 SP3

  22. Intellisense not working for one connection but works for others
  23. How to know if backup file is available before trying to restore
  24. SQL SERVER ERROR missing family sequence number 2

  25. Migrate replication from SQL Server 2008 R2 to SQL Server 2016 - Old to new hardware

  26. Application is hanging when database upgraded from SQL Server 2000 to SQL Server 2008 R2

  27. Creating Linked Server - Impersonation of Windows Authentication
  28. Report Builder does not connect for a remote reporting Server

  29. SSIS Excel export changes # to
  30. Why does dm_exec_procedure_stats return incorrect execution statistics on MS SQL2008R2?
  31. Indexed view doesn't exist on the subscriber

  32. Upgrade from SQL Server 2008 R2 SP2 to SQL Server 2014 Error
  33. A way to syncronize data in sql express
  34. Select without From SQL Server
  35. Full text catalog missing a keyword
  36. SQL Server Replication - setting up scheduler issue
  37. Why does the MS SQL Server change tracking table store all DML operations that occurred within the transactiton?

  38. TSQL Re-Enabling Contraints take a long time

  39. Setting up Mirroring in SQL Express Edition

  40. Query slower in Prod than Test

  41. SQL Server Configuration Manager returns remote procedure call failed
  42. test database server tries to log onto prod database server every minute

  43. How does "OtherServer" in SSDT database references work?

  44. Incrementing an integer every 150 rows

  45. Need Script to find SP Invoked in SQL

  46. Safely moving and creating new tempdb files

  47. SQL Server - Handling localization of strings in nested non-deterministic view stacks

  48. ODBC PHP issue to connect?

  49. Tracking down a transaction rollback

  50. Insert multiple values into stored procedure

  51. Grouping Subsets of Rows with Null Values within an Ordered Set
  52. How do I place leading zeros for numbers less than 10 without affecting those 10+?

  53. How to return a null from an empty XML tag in SQL server using Xpath only?
  54. Change Tracking across several Tables
  55. Intermittent errors sending email from SQL Server Database Mail
  56. Need to filter SQL database data by time interval (1 sec, 1Min, 10 Min,1Hour, 2Hour)

  57. Turn Rows Into Dynamic Number Of Columns

  58. Decode Base64 String Natively in SQL Server

  59. Tracking what all application connects to SQL server

  60. Difference between "Table-Incremental" and "Table-Update" for "Population Type" when scheduling Full Text Index Population
  61. Migrate logins tagged to specific databases users

  62. What happens to an SSIS package when I alter a table that is used as a destination?

  63. Regular Data Space Specification vs Text/Image Filegroup
  64. Update Top 1 Row In SQL Server

  65. Trying to restore 2008 backup to 2016

  66. Create Table Every X Rows
  67. Grouping by date range in a column

  68. How to be sure that a SQL Script is running with ANSI encoding?
  69. Trace to find "error messages"( SQL Server 2008 R2 )

  70. Linked Server Creation Error

  71. Implementing change data capture to Large environment database
  72. SQL Server Self Signed Cert - no private key?

  73. T-Sql - Issue setting SQL Agent Database Mail
  74. SQL Server 2008 R2 Backing Up Database takes too much time

  75. Best procedure to measure query optimization effects?

  76. SQL Server 2008 R2 "Ghost Memory"?

  77. SQL Server 2008 R2 - Weekly / Monthly Statistics
  78. How to find out the content differences between 2 SQL tables and produce sync SQL

  79. Truncate tables with dependent foreign key constraints

  80. How to reclaim unused space from clustered index table
  81. How does SQL Server choose an index key for a foreign key reference?

  82. How to copy a database using scripts only, no bak, no mdf, no ldf

  83. Export/import data from Excel into a table with queries

  84. Migrating from SQL Server 2008 R2 to SQL Server 2014

  85. Strategies for "checking out" records for processing
  86. How does SQL Server Startup?

  87. How to find out SQL Server options updated
  88. Back up Chain LSN

  89. How msdb.dbo.backupset works ( backup_size )

  90. Sql Server agent can not start

  91. How I can impersonate a login with securityadmin server role
  92. Audit Database Log On/Off
  93. Searching SSIS packages for the use of specific tables

  94. Find entries, meant to only be available on specific days, being set on incorrect days
  95. SQL Server Configuration Manager: Error 0x800706be
  96. How to remove old join operator and rewrite them with new queries in outer or inner joins

  97. how to count Id from a table where the the data in ranges?

  98. Manipulate SQL statement before execution on server
  99. Sorting multiple columns in a full outer join, possibly containing NULLs

  100. SQL Server 2000 Named Instance cannot connect remotely