|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Migration Assistant Issues | |
If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3) | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Enable a Disabled Index I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it? Answer: ALTER INDEX LoggerCI on dbo.Logger REBUILD Explanation: The ALTER INDEX command with REBUILD is used. Ref: Enabling Indexes and Constraints - https://learn.microsoft.com/en-us/sql/relational-databases/indexes/enable-indexes-and-constraints?view=sql-server-ver16 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Development |
Error 28054 related to master key root cause and solution required - I am getting the following error in SQL Server Error Log randomly on few days. I want to know the root cause for this error so that we can decide on applicable solution for this particular error. Service Broker needs to access the master key in the database. Error code:32. The master key has to […] |
How to attach Database created in higher version to lower version of SQL Server - I have attempted to attach a database created in a higher version of SQL Server to a lower version, but I encountered errors. I also tried the backup and restore method, which resulted in errors as well. According to the following link, I explored several options but was unsuccessful: https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/ 1. Generate Scripts Wizard in […] |
SQL Server 2016 - Administration |
application not connecting to secondary - Hi the application which has the connection string of the listener configured connects to node S01 but when failed over to S02 it does not connect there are no applicable error in the SQL logs and windows logs please let me know |
Development - SQL Server 2014 |
Query to return all data that has same site, section and date - I have a query Select Id, WOCode, Site, Section, CompletionDate from work orders where type = 'BRE'. I want to be able to return list of all WOCode that has same Site,Section and CompletionDate. The date field will be date only with no time |
SQL Server 2019 - Administration |
sql monitoring tool - Has anybody had any experience with Nagios as a SQLServer monitoring tool. What were the pros and cons you had faced while using it. Please advise. |
Failed restore database - Hi All , I have issue restoring small database . SQL version : SQL 2014 In the server , At first I took a backup of database ( bak file ) and compressed it . Then I copied ( standard copy ) to my local laptop from server , after that I copied back to […] |
SQL Server 2019 - Development |
max and min dates - Hi I am trying to get the first and last days for the following where date_next_compare is less than 28 but having more than that would mean the max date for that range. Sorry if isn't clear. I currently have this: I want to see two rows like below. I tried doing min and […] |
Pivot Mistake - Hi all, I have this query where I make a pivot to extract the data segmented by Hours: select ‘Amount’ as Amount, [0] ,[1] ,[2] ,[2] ,[3] ,[4] ,[5] ,[6] ,[7] ,[8] ,[9] ,[10] ,[11] ,[12] ,[13] ,[14] ,[15] ,[16] ,[17] ,[18] ,[19] ,[20] ,[21] ,[22] ,[23] from (select sum(efeneg) ‘Amount’,left(hormsg,2) ‘Time’,left(hormsg,2) ‘Time’,left(hormsg,2) ‘Time’. from […] |
open query via linked server to db2 is showing terrible performance - Hi this post is mostly about cross server concepts vs a query being sent to and run on the target server and then the data simply coming back over the network. but any feedback is appreciated. we have a sql server linked server thru which the db2 erp query (view) shown below is sent to […] |
General |
What is Azure Data Studio or GitHub asking me? - I have an Azure Data Studio question (or maybe it's a GitHub question, I'm not sure), but I couldn't find a forum here to ask it. So, please excuse my asking it here. I am busy writing a T-SQL script, using Azure Data Studio. I committed my changes locally, then I tried pushing them to […] |
How do data visualization consultants overcome the challenge of integrating? - Integrating multiple data sources is challenging due to differences in data formats, structures, and quality. Data visualization consultants must first establish data connections and ensure consistent data formatting. This often involves using ETL (Extract, Transform, Load) processes to clean and combine data. They must also handle data refreshes and ensure that integrated data is up-to-date. […] |
SQL Server 2022 - Administration |
SQLExternalMonitoring what is it in sp_who2 result - If I run sp_who2, one of item in the list is showing using program SQLExternalMonitoring , what is it? it uses quite a bit cpu and ram. 70 sleeping NT AUTHORITY\SYSTEM SNOCSMASQP01 . master AWAITING COMMAND 170846212 57458731 09/26 10:31:41 SQLExternalMonitoring 70 0 Thanks, |
Linked Server to SAP HANA database. - Greetings all. It's been a very long time, but I'm back. Does anyone have experience with setting up a linked server to a SAP HANA database? I have hanaclient-2.8.20-windows-x64 installed and a DSN created using the HDBODBC driver that comes with the client install. I am able to use the DSN to connect with generic […] |
SQL job & SSIS package excution - Hi SQL experts, We have installed SQL Server with 2022 and using this as SSIS server. SSIS DB is the only one database on this server. We deployed a SSIS package, which is scheduled to run every 1 hr through SQL agent job. The job is failing sometimes & running successfully other times. The job […] |
SQL Server 2022 - Development |
SQL Query Optimizer Supporting Parameterized Query and WHERE Clause Optimization - I am looking for a SQL query optimization tool that can enhance my query execution times. I have already tried EverSQL and SQL Tuning, but they are not meeting my requirements for the following reasons: 1. Parameterized Queries: Both tools seem to struggle with parameterized queries and do not optimize them correctly. 2. WHERE Clause […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |