sql-server-2008

  1. How Do I Force Data From First Table to Display
  2. How to stop SQL Server Reporting Services from using 100% CPU

  3. How to include concatenated values in a dynamic pivot column value?

  4. Moving a very large (40 TB) DB from a 2008 server to a 2016 server

  5. Service Broker - DR
  6. SQL 2008/R2 Extended Events - Row Count
  7. Recover data from .mdf file, and no correct version of SQL Server
  8. SQL Server Configuration Manager: Error 0x800706be

  9. DB Permission: User can drop only their created db's?
  10. SQL Server Profiler: why the RPC Starting event does use an different decimal separator from SP Starting?
  11. Inserts/updates are extremely slow with Merge Replication in SQL Server 2008

  12. sqlcmd returning NUL instead of NULL for tinyint column

  13. Why is my database using Partitioning? ( I know it's not )

  14. Auditing - parameter values not being written to log
  15. Taking 36 hours to recover after restart

  16. grant permission
  17. A way to syncronize data in sql express

  18. Why does this CTE return the bulk of its results immediately, but then take several minutes to finish?

  19. Help with this query

  20. Two-step Replication between SQL 2008 and 2017

  21. why my split string functions are not working with large OBJECT_DEFINITION?

  22. Can sp_executesql be configured / used by default?

  23. How can I create a stored procedure of inheritance tables in SQL Server
  24. Get the records matching the combination of column values from a temporary table
  25. Migration of SQL 2000 to SQL 2008R2

  26. Make SqlClient default to ARITHABORT ON
  27. Cannot Delete FileStream Group from Sql Server 2008

  28. How do I count the number of columns in each table?
  29. Unexpected Shutdown affects SQL Server DB start at OS start up

  30. When is the SQL Server database ready to accept queries?
  31. Where to download Sql Server 2008 R2?

  32. SQL agent jobs hung state (SSIS jobs hung)

  33. How to manually invalidate a pull merge replication snapshot from the publisher

  34. SQL Server Failover Cluster setup shared drive issue

  35. How can I get Sql Server 2016 on a 32-bit server?

  36. How do I determine if a table exists in a SQL Server database in SQL Server 2008?

  37. Change SSIS package location

  38. Microsoft recommends using Rowversion over timestamp , but i can not find "rowversion" data type inside my sql server 2008 R2

  39. Suppress SQL Server Management Studio auto complete
  40. Best way to allow update exceptions on a cell level
  41. Error occur during Oracle and Sql Server Integration

  42. DBCC CHECKDB last good date
  43. SQLCMD Mode in SSMS and @@variable expansion

  44. Unable to remove additional tempdb file
  45. Are there any way to stop typing 'go' in sqlcmd?

  46. SQL Server 2008 - get current LOCK_ESCALATION on particular table
  47. SQL Server 2008 CPU Troubleshooting on 6 identical servers
  48. How do I shrink all files quickly for all databases?
  49. Sum purchased & sold quantities for all items on daily/weekly
  50. Generate a file or a script that can be used to reconstruct a database on a different PC
  51. Old SQL Server 2008 DB -> SQL Server 2016 Server Backup/Restore Stuck in "restoring"

  52. SQL SERVER ERROR missing family sequence number 2

  53. Full text catalog missing a keyword

  54. Dynamic select column name on the basis of a flag
  55. Syncing data between onprem and Azure SQL

  56. Declaring cursor to loop over some values in SQL Server 2008 R2
  57. Unzip files within the SQL Server

  58. When inserting the varchar value into the datetime field, it throws conversion error
  59. How can I determine which tables are causing the database to grow over time?
  60. Correlating hostname/IP to user
  61. Passing in the table into a stored procedure

  62. Should I use backup compression for databases where all data is already compressed?
  63. How can I reseed all identity columns?

  64. AVG function returns wrong average

  65. Is there a way to do a textual search through all stored procedures in a table?

  66. How to detect compatibility errors - SQL Server 2012

  67. Reading SQL Server 2008 transaction logs
  68. SQL Server 2008 SP1 to SQL Server 2008 R2 upgrade

  69. Specify Connection in Management Studio T-SQL Query

  70. Query to get blocking duration

  71. Output File Default Location using MultiServer Agent Jobs

  72. SQL current timestamp

  73. Max Degree of Parallelism for SQL Server 2008

  74. Test if any fields are NULL

  75. Why changes to Full-Text index don't apply automatically?

  76. Migration to databases Domain Users do not have access
  77. Find Job Calling Another Job
  78. Event 17058 - initerrlog: Could not open error log file (SQL Server)
  79. Stored procedure runs forever, but inner query runs fine

  80. Multiple Transaction Log files and performance impact
  81. Query is slow for certain users
  82. Is ROLLBACK a fast operation?

  83. What would be the most efficient way to check for null values in all columns for multiple tables?
  84. What are some efficient ways in using COUNT(*) with WHERE

  85. SQl code performance

  86. SQL Server 2012 Performance Test
  87. INNER JOIN making COUNT(*) slow
  88. Is there a way to truncate table that has foreign a key?
  89. View foreign key constraints so I can delete a table

  90. Find constraint disabled in SQL Server

  91. Unique Constraint with multiple null columns
  92. A query that lists all mapped users for a given login
  93. Grant a login of Sql server authentication the same permission of a Windows group login with Windows authentication?

  94. Mapping a Login to a User

  95. How to create database, and add user linked to login?

  96. How do I switch off SCHEMABINDING for a view without recreating it?

  97. sys.sysprocesses versus DMVs

  98. Sql Server - Best Practices for Growing Database Files

  99. Find the destination owner (schema) for replication on SQL Server
  100. How to reduce table partition timing for existing table in SQL Server