Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2016 - Administration |
| Index Creation for large table failed. - I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to perform the creation job. CREATE CLUSTERED INDEX [IX_Arc_tblFST_GSNID] ON [dbo].[tblFST] ( [GSN_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = ON, DATA_COMPRESSION=PAGE) ON [ps_tbl_arctbltnr]([TNR_Date]) However the creation […] |
| SQL Server 2016 - Development and T-SQL |
| Extracting Data from XML file - Hi all, I have a XML file which consists this type of data: 12345 1 ABC XYZ TEST TYPE TEST REFNUM 2016-11-30 TESTCOMMENT TEST DESIGN TEST NAT TEST TYPE EXACT 1964-07-17 […] |
| How To Enumerate Hierarchical Info on SP calls - NOTE: Forgive me if I am using the wrong terminology with regards to this. \ I am trying to get a list of all The SP's (Stored Procedures) that are called by an SP. For example let's say I have the following SP's: LF5_Job1, LF5_JOb2, LF5_CalcResFees, F5_CalcCommFees & LF5_PopulatFees The SP LF5_Job contains one 'EXECUTE' […] |
| Administration - SQL Server 2014 |
| DBCC CHECKDB - LATCH_EX - Hello. I posted previously about DBCC CHECKDB and Backups and changes are under review - thanks for feedback on here. This is related - but a very specific question about DBCC CHECKDB - here is what I am seeing. DBCC CHECKDB runs against Database A in SQL Instance A. On certain days of the month […] |
| SQL Server 2019 - Administration |
| What can set the recovery model of a database? - Hi I have had an incident where a database log has grown to a large size. Normally I would backup the logs however the recovery model has been set to SIMPLE. I am under the assumption that only a human can set this option. I have checked the logs and cannot find any alter database […] |
| Log File continue growing - Hello everyone, i read a lot about growing Log Files on this forum but can´t find a solution for my problem. I moved a database from one server to another, cause there were several performance problems on that old server. Since i moved the database the lfd file is continue growing. Database (mdf) file is […] |
| SQL Server 2019 - Development |
| how to get the max date in the table - I have a below table with the values cscode StartDate EndDate 0011 5/9/2022 10/1/2022 0011 6/17/2022 1/1/2023 0011 5/9/2022 10/1/2022 The date column is varchar. I need to take the latest mm/dd/yyyy using EndDate. For ex, in the above table I need to […] |
| Delete in ERREOR with an FK on the same table - Hello I do not know why my delete does not work despite I respect my FK constraint The FK constraint is based on the same table ALTER TABLE [dbo].[EVACUATION] WITH NOCHECK ADD CONSTRAINT [FK_EVA_DECH] FOREIGN KEY([COD_EXP_CHG], [COD_CEL_CHG], [NUM_DOS_CHG], [NUM_EVT_CHG]) REFERENCES [dbo].[EVACUATION] ([COD_EXP], [COD_CEL], [NUM_DOS], [NUM_EVT]) GO ALTER TABLE [dbo].[EVACUATION] CHECK CONSTRAINT [FK_EVA_DECH] GO Here is […] |
| SSIS Logging - Hi everyone I am having some issues with SSIS logging. I recall setting it up but I don't remember how I did it last time. It was an option in SSIS somewhere but I cannot seem to find it now. I took a look at sysssislog table and I see that it did log in […] |
| SQL Azure - Administration |
| SQL Managed Instance Accelerated Database Recovery - ADR feature is optional in Onpremise where as in SQL ManagedInstance, it is enabled by default. In the Below link performance comparison has been done by Niko Neugebauer. There's about 8% decrease in the performance for Insert/Update/Delete, when ADR is enabled. Accelerated Database Recovery so there will be atleast 8% performance degradation if we migrate […] |
| Query Oracle DB from Azure SQL - Folks, I'm investigating the possibility of migrating from Azure VM with SQL to Azure SQL Managed Instance but have hit a roadblock. We depend heavily on data from Oracle DB accessed through Linked Servers, both for queries and also direct imports to internal tables. My understanding is that Azure SQL does not support OLE […] |
| Powershell |
| How to Insert API data into database using Powershell - Hello, I am trying to teach myself how to INSERT data from an API into a SQL Server DB using PowerShell. For this exercise, I am using a public API which is: https://date.nager.at/api/v2/publicholidays/2020/US. What I would like to do is insert this into a table using a Stored Procedure. Below is my code. I think […] |
| Analysis Services |
| using PowerQuery with SSAS Tabular - I have a stupid question... I can do all the PowerQuery stuff in PowerBI, but can I move those transforms to SSAS Tabular somewhere, so that the transformations will be done and then just persist the results in my data warehouse/SSAS Tabular model? I know I can do this in PowerBI, but how do you […] |
| Strategies and Ideas |
| Injest user-provided Excel? - In today's episode of "Products that Should Exist (and maybe do)": Have you come across a solution (preferably a web-based portal) that allows an end user to upload an Excel file, digests the data, identifies tabular data, walks the user through column mapping to structured data, performs data validation, highlights invalid data, allows editing of […] |
| SQL Server 2022 - Development |
| Want to load data on a staging table. - In the past, I loaded data off excel, and it was difficult to manipulate in SQL. Someone suggested loading the data on a staging area next time to avoid hassles. Now, I have more of such similar data from excel to import to SQL server, and need to load on a staging table. I have […] |
