Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Availability Group database went into 'Restoring' state - Dear Friends, Please advise why would one of my Availability Group databases go into 'Restoring' state. Thanks in advance. |
Administration - SQL Server 2014 |
Display columns from multiple rows in single - Hello, Im looking for assistance. I have this query and need to display the results in a single row. select System, CONVERT(varchar(12), DATEADD(minute, DATEDIFF(minute, [Run Start Time], [Run end Time]), 0), 114) As 'Total hours' FROM [dbo].[Prod_ShiftSummary] where office = 'Dallas' and [Run end Time] >= DATEADD(day, -7, GETDATE()) and oven = 6 group by […] |
SQL Server 2019 - Administration |
Reset launchpad service to use default account - I have an issue with SQL Server Launchpad service. Initially it wouldn't start (configured to use "NT Service\MSSQLLaunchpad$") but on changing it to the domain account which runs the SQL Server service it starts without issue. I'd like to change it back to the default to see if it still works after doing so but […] |
Can't Restore DB - hi everyone I need to get a copy of a stored proc from backup b/c the one I am using in my current instance of the db isn't correct. I am not able to restore the db. What am I doing wrong? The name of the db is OptionsDB and I want to keep the […] |
partitioning a huge table - Hi folks I would like to get your views about partitioning a huge table in sql server .Around on size of 100 gb.Beofre i present this idea to upper mnmgt i would like to have your inputs .I am of view that since there is only 1 dedicated disk for data files (mdf/ndf) there is […] |
SQL Server 2019 - Development |
How Can I Speed This Query Up? - Hi everyone My SQL query is close to 1000 lines with 17 separate calcs (ie sub-queries). The entire query takes almost 3 minutes to run. This is way too long. I figured out the problem area. It turns out that 70% of the time is spent on 2 subqueries. Each is the same except that […] |
puzzeled with "exec sp_cursor 180150007,40,1" - I've noticed in one of our applications a cursor uses operation 40 and that operation is very slow. This handles a table with 62 rows with images ( most < 500KB , but some (5) > 2MB ) MS Docs sp_cursor describe optype, but I cannot actually get my interpretation around as to why this […] |
Not wanting to use a Cursor, but... - Ok, need someone to talk me off the cursor ledge on this one. I have some train stop data that I need to accumulate the number of riders for, over a time when the train is heading in one direction, on a specific day. The data is all stored on a yearly basis, so I […] |
SQL Server 2008 - General |
how to determine if we can delete the index can be removed - In SQL Server database, there is a table InventDim with two indexes: Idx1 with index columns (DataAreaID, BatchID) and Idx2 with index columns (DataAreaID, BatchID, InventSizeID). Is it possible to drop Idx1 if Idx2 already exists and covers all the columns in Idx1? thanks a lot! |
how to determine if we can delete the index can be removed - In SQL Server database, there is a table InventDim with two indexes: Idx1 with index columns (DataAreaID, BatchID) and Idx2 with index columns (DataAreaID, BatchID, InventSizeID). Is it possible to drop Idx1 if Idx2 already exists and covers all the columns in Idx1? |
how to determine if we can delete the index can be removed - The table InventDim has some indexes, we create one index idx1 which has index column f1 and f2, and creating index idx2 which has index column f1、f2 and f3, index column sequence of idx1 is same with idx2, means the index columns of idx1 totally are included in idx2 and the sequence of index column […] |
SQL Azure - Administration |
Azure Datawarehouse or SQL Pools and profiler equivalent... - I added the Profiler module to AZure Data Studio in our ("Microsoft Azure SQL Data Warehouse ) env to monitor performance memory / disk, etc just as I've done with SSMS profiler for years.. I know I 've used it before on another Azure product, but for this I get: "An exception occurred while executing […] |
Reporting Services |
Changing a datasource using T-SQL Script - I've been looking for a way to change multiple data sources for reports to a different data source. Is their a T-SQL Script that can accomplish this? |
Integration Services |
You have an error in your SQL syntax; check the manual that corresponds - I am having great trouble creating a data pipeline using MariaDB connector 3 with SSIS/Mysql connector 8. I can view the tables, but it gives me this error: "TITLE: Microsoft Visual Studio ------------------------------ ERROR [42000] [ma-3.1.18][10.4.24-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the […] |
SQL Server 2022 - Development |
SQL Website Development: A Comprehensive Guide to Building Dynamic Web Applicati - Introduction to SQL Website Development What is SQL? Importance of SQL in web development Understanding Dynamic Web Applications Definition and examples Benefits of dynamic web applications SQL Database Management Systems Introduction to DBMS Popular SQL DBMS options Setting Up the Environment Choosing a programming language Installing a web server and database Creating the Database Structure […] |