Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
The transaction log for database 'mydb' is full due to 'LOG_BACKUP' - I got an alert The transaction log for database 'mydb' is full due to 'LOG_BACKUP', it fills the log. And I checked the database is 32 GB, and set to grow 64 mg for data file and log file. Unlimited growth. I also do transaction log backup every 3 hours. and I see them successful. […] |
What do you like for third party database backup/restore for SQL server & Azure - Hi all, my company currently uses SQL server native tools to perform nightly backups. We are a small company and unfortunately do not have an actual DBA - our network admin and group of developers are working together on the backups. But we are looking into other vendors, such as RedGate's SQLBackupPro, Idera's SQL […] |
Disk space - I noticed the system volume information is consuming the disk space on database server log drive. Also found that shadow copy is disabled but maximum size is not configured to use limit. My understanding is that during the setup of server someone would have not configured properly to use limit. Do you agree with me? […] |
SQL Server 2017 - Development |
MDS multiple domain based attributes for one member - Hi SSC, I wonder if I can select multiple domain based attributes for one member record and if so, How would I do that? We have a SharePoint list which we would like to replace by MDS, the only issue I see right now is that there are multiple checkboxes for the same "which of […] |
Find the last occurrence of \ character and get the left of string. - How to find the last occurrence of '\' in the following string and get left part of it? DECLARE @V VARCHAR(max)='O:\Z\P_Metrics\Inbox\07-13-20200702_abc_enroll.csv' DECLARE @V1 VARCHAR(max)='O:\Z\P_Metrics\Inbox\07-14-20200702_abc_complete_enroll.csv' The Final output I need is O:\Z\P_Metrics\Inbox. Thanks in advance. |
Creating a Dimension with no Primary Key - Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and SSAS. The cubes were originally constructed in SQL 2000. It's been going well so far until I try to recreate a "Calculated Time" dimension that worked so well in the old build. The dimension table was linked to the fact table […] |
SQL Server 2016 - Development and T-SQL |
more effecient query - hi I have a simple query that needs better performance. I have added primary key into the temp table which helped, but here is the root of the problem below.. There has to be a cleaner and more efficient way to write this, any thoughts? Thanks INSERT INTO [dbo].[WeeklySalesReportTempTable] ([Location Code] ,[Profit2YrsAgo] ,[ProfitLastYear] ,[ProfitLYMTD] ,[ProfitMTD] […] |
Code signing a dll with certificate for use in SQL Server 2016 - I have a dll that will perform some webservice calls function. in order to use in SQLServer 2016 i would like to create a user called sqlex from a certificate. When I try to do this I get the below error: USE [master] GO /****** Object: Login [sqlRext] Script Date: 10/07/2020 12:06:30 ******/ CREATE LOGIN […] |
Administration - SQL Server 2014 |
Do changes User Defined Data Types get replicated by default in Tx Replication? - Just as the title says. I have a database that heavily uses UDDT's. We replicate it to a RDB for business intelligence, etc. We recently had a schema change that increased the length of a VARCHAR UDDT from 30 to 60. During deployment, we dropped the publication containing that article, applied the dacpac, and recreated […] |
Logshipping - i configured logshipping b/w two servers , when i checked the file location of secondary database , showing the primary databse file location , drives are not identical in both the servers. what is the reason for this or any issues? |
SQL Server 2019 - Administration |
Oracle linked server mixing up result values - Hi all, I am having a very strange issue with Oracle linked servers. The linked server is created based on the Oracle Ole DB provider. I can reproduce this issue on any SQL server instance. Whenever I retrieve somewhere around 500-600+ rows and large binary data is included the returned rows are mixed up: meaning […] |
SQL Server 2019 - Development |
Execute SSIS generates error "create_execution has too many arguments specified. - We recently upgraded our Dev server to SQL 2019. Since upgrading, whenever we run an SSIS package from the catalog we get an error "Msg 8144, Level 16, State 2, Procedure SSISDB.catalog.create_execution, Line 0 [Batch Start Line 0] Procedure or function create_execution has too many arguments specified." I scripted out the execution in our 2019 […] |
SPMail Not Working For All Users - Hello~ I'm sure there's a very simple solution, but it seems to be eluding me -- I have a db application (MS Access Front End/Azure SQL Back End) -- I have triggers written on certain tables (for example, if an error occurs, a record is added to an error log table) that send an email […] |
Integration Services |
Help needed in getting all AD users and groups - I have very limited knowledge with server management. I need to extract AD users and groups. Specifically, all AD users and groups. Questions I have: if this is going to be done through PowerShell, does the script need to run on the DC server? what privileges do I need to run the script? How will […] |
Administration |
How to analyze massive OLTP databases - I've just started a job and I'm responsible for administrating (will define later) a few massive OLTP databases. These are not direct transactional systems, but they are published directly by the main OLTP system (so they mirror the production tables). I am responsible for these tables. Precisely I need to accomplish the following: 1- Create […] |