sql-server

  1. What is a SQL Server "lop"?
  2. SQL Server replication - set PollingInterval in sp_addmergepushsubscription_agent
  3. One user for all database applications

  4. sp_blitz shows "Last good DBCC CHECKDB over 2 weeks old"

  5. Installing SQL Server using config.ini

  6. Join Tables of Varying Criteria in Order of Priority

  7. Getting errors when installing and using sp_blitz with `sqlcmd.exe`?

  8. How do I log into the Dedicated Admin Console (DAC) on Linux?

  9. Which component of SQL Server architecture handles the user login requests?
  10. Is there an sp_reset or the equivalent?

  11. SQL Regex String Matching of Two Words

  12. float to varchar with no trailing zeros

  13. bcp command Incorrect syntax near '�'. ä
  14. Are 'SELECT *' Sub-Queries inefficient?
  15. Linked server to Oracle doesn't use filters. Are there any performance changes in different versions of SQL Server?

  16. Date format incompatibility in linked server between SQL Server and Oracle

  17. How different clauses treat Null/Unknow in SQL Server 2012?

  18. SQL Server 2016 very slow snapshot generation

  19. metadata could not be determined because stored procedure contains dynamic SQL

  20. Improve Parameterized Query Performance
  21. List of IDs that have an assignement to ALL other Ids in another table
  22. best local database (for PC)

  23. Error during execution of sp_executesql SQL

  24. Can't install a OLE DB Provider for IBM DB2 ISeries on SQL Servers higher than 2008 version
  25. How do I cancel an app lock request in SQL Server?

  26. SQL Server Database Mirroring : strange client application behavior upon failover

  27. Improve reporting stored procedure execution time - tuning temporary tables?

  28. Use name of table as input in procedure and store the output of SELECT statement in output variable SQL

  29. How can I take backup of particular tables in SQL Server 2008 using T-SQL Script
  30. Why is there no predicate applied to the Index Scans?
  31. How do I know what requires DAC?
  32. Problem to read data from secondary when reorganizing clustered index

  33. Strategy for SSRS / Backup / Point in time recovery
  34. Multiple databases, one backup file

  35. Database File Locations and SSDs with RAID5

  36. Grouping Sessions using a DATETIME stamp which can Span across a DAY

  37. Sql server bulk insert remove text qualifier

  38. Can I extend SQL Server with C++ or C?
  39. Can I get shell access through SQL Server 2017 on Linux?

  40. Access view based on table in another database without account in that other database

  41. Iterating through a record set and selecting certain records

  42. SQL Server clears plan cache and execution stats periodically

  43. Select Permissions Across Multiple Schemas Within the Same Database
  44. I keep getting an error 10060 trying to connect object explorer in Visual Studio 2013 to an Azure Database

  45. Convert rfc822 to either a GMT DATETIME or Unix timestamp in SQL Server
  46. T-SQL MINUS operator

  47. Slow Linked Server INSERTs on SQL Server 2014

  48. How to load textfiles into SQL Server Database?

  49. SQL Server 2008 R2 DB grows overnight and slow

  50. Clients timing out with no apparent reason
  51. Is it possible to estabilish Dedicated Administrator Connection (DAC) using SSMS?
  52. DAC connection error

  53. No DAC connection could be established on the default port. Make sure DAC is enabled
  54. Why am I getting "Invalid object name 'sys.sysobjvalues'."

  55. Upgrading SQL Server with Integration Services
  56. Sample Sybase ASE 15.0.3 database

  57. Cannot Delete FileStream Group from Sql Server 2008

  58. Performance of XML to Table Function in Stored Procedures

  59. SQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog file

  60. Cross Cluster Migration 2012 to 2016

  61. Capitalize first letter with exceptions

  62. Does CREATE/DROP VIEW require a SCH-M Lock
  63. SQL Server Buffer Pool Extension in FullText Index Population
  64. table type parameter vs temp table vs table variable
  65. SQL AlwaysOn & System Center Configuration Manager TP 4 1601

  66. Approaches for handling nvarchar sources to data warehouse

  67. Common TVF in SQL server to get results from differnt schema

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

  69. Interpreting sys.dm_os_sys_memory

  70. TSQL LDAP query via Linked Server

  71. Sum every X rows with no common group by parent
  72. Display values from columns in one table, specified as values in another table column?

  73. How do I use SQL Server's "Hekaton"?

  74. How to Publish Checked-In changes only in Team Foundation Server 2013 to SQL Server?

  75. What is a "Partial Matching Index"?

  76. SQL Server doesn't send intermediate SSL certificates

  77. SQL Server not starting after SQL Server 2016 SP1 CU6
  78. Restore Database w Master Key and storing password in plain text
  79. How do you ensure accuracy of your query

  80. There is already an object error after database is dropped

  81. Mysterious conditional where clause index choices

  82. On SQL Server 2017 (Linux), where is the Resource Database persisted (located on disk)?

  83. Set permissions on a view

  84. How to insert default values to a table with not null columns?

  85. Extracting Data from multiple archive tables(SQL Server)
  86. Stored procedure deadlocking itself, how do I resolve it?

  87. Error with SQL stored procedure output type

  88. Log Shipping "out of sync" but none of the jobs are failing

  89. In 2-node cluster using failover with Dynamic Quorum, is Witness needed?

  90. Implementing audit trail ms sql using stored procedure

  91. Why does user not have access to database?

  92. Granting permission to the service account

  93. How to know which security updates to install?

  94. Unspecified error (MS Visual Database Tools) when creating a table using GUI

  95. Pulling SQL Server data into Excel

  96. Invalid Column Name Error after ALTER and UPDATE

  97. Hash Match inner join in simple query with in statement
  98. Migration of Always On Availability Group from old to new SAN within same data center

  99. Use Windows 2016 Storage Replica for SQL Server failover cluster instance

  100. SQL Replication Automatically Add table to Publisher