| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2016 - Administration |
| Job History says running, but Job Activity says idle - Hello experts, I'm hoping to get help with a strange issue. I got a request to stop a long-running SQL Agent job. The client correctly sees that the job history says the job is running. But when I checked the Job Activity Monitor, it says the job is idle and last succeeded at such-and-such a […] |
| Change Data Capture - We performed a drop on one of our CDC Tables when we should have performed a sp_cdc_disable_table . Now when we try to create the CDC Table via sp_cdc_enable_table and specifying the @Capture_Instance name we get the following error: Could not create a capture instance because the capture instance name ' ' already exists in […] |
| SQL Agent Job Notification - Hi - I have maintenance plan that rebuilds indexes nightly on a specific database. In its related SQL Agent Job properties I have set to email when the job fails like so: But I'm getting notifications on Success as well. Any ideas? |
| SQL 2012 - General |
| 60 Second Rolling Avg With Different Starting Points - Hi, I have a table with columns: jobId, timeStamp (for duration per jobId) and tempData (see attachment). I have created a query that calculates 60 second rolling average by jobId. (you can see it at the end of the post) Where I am struggling is adding two additional rolling averages. Both of them would be […] |
| SQL Server 2019 - Administration |
| Using DNN (Distributed Network Name) for on-prem AOAG - Hi we have a hybrid SQL estate between om-prem and Azure. It's been suggested that we should configure our AOAG's with DNN's both in Azure and on-prem so everything is using the same solution. DNN's on Azure look to be a good solution but I can't see anything (apart from details of edition and CU […] |
| SQL Agent Job doesn't write output - Dear All, I have set up a consistency check job on an SQL server which runs well but doesn't write the output. thank you in advance. Best Regards....Arshad |
| SQL Server 2019 - Development |
| Sql stored procedure to select top 1 from multiple tables and update 1 table in - I have two tables in this format below; Table Transfer Id Stage Amount TransactionNumber bnumber Table User Id Bnumber FirstName FirstLastName My aim is to select top 1 from these tables based on criteria and then update that record in the Transfer table, all in one query. I have struggled and came up with the […] |
| SQL Query to fill in Null Column values based on closest date to a given date - Greetings, I am trying to fill in NULL values in a column (Advice) with the value from the closest date (higher or lower) with the same id. Hopefully my example will illustrate this. The table below has two id types (CustId and LeadId) and one will always be null if the other has a value. […] |
| multiple same dates - Hi Expert, Have 2 columns where column A which is id having multiple duplicate records this is my input records and output is mentioned below create table table1 (id varchar(20), b varchar(20), c date) insert into table1 values('-1','ww','2022-05-24'), ('-1', 'ff', '2022-05-24'), ('1', 'ee', '2022-05-25'), ('1' ,'ww', '2022-05-25'), ('2', 'ff', '2022-05-26'), ('4', 'ww', '2022-05-27'), ('4', 'ff', […] |
| Cant extract values from JSON Array - Hi there I am trying to extract values from a JSON array object but struggling so my code is as follows: DECLARE @JSON NVARCHAR(MAX) = '{ "ChannelIDs": [11,14,15,16], "SerialNumber": "939029", "ReadingStartDate": "2022-05-20T13:49:13", "ReadingEndDate": "2023-01-09T17:44:05", "Amount": 50, "SortOrder": "Ascending", "IncludeFirstDate": 1 }' SELECT device.ChannelIDs FROM OPENJSON(@JSON) WITH ( ChannelIDs NVARCHAR(MAX) '$.ChannelIDs' AS JSON ) AS device […] |
| SQL Azure - Administration |
| Stop and start an instance - Hi Colleagues, November 2022 Feature Wave for Azure SQL Managed Instance. Have you heard about it? This update brings an exciting feature. The possibility to turn off SQL-managed instances. However, it is only available for Dev/Test Subscriptions. This is good for me. I had the option available in my SQL-managed instance Azure portal not long […] |
| Amazon AWS and other cloud vendors |
| When does the AWS Free Tier ACTUALLY expire? - Hello. I keep reading that to check the expiration date for the AWS Free Tier, you need to check the first month that appears in your "Billing" section. Problem is, I signed up for AWS on the 28th of February of last year, which means I have a February 2022 bill. By that logic, January […] |
| Reporting Services |
| SSRS 2019 Intermittent Could not load folder contents Something went wrong. - A number of individual users are receiving the following error "Could not load folder contents Something went wrong. Please try again later." A reload just a few seconds later brings up the folder contents. This is happening multiple times a day. Ultimately the folder contents come up, but only after a reload of the browser. […] |
| General |
| What “paths” may I have as a future Python developer? - Hello! have been lurking in this sub for a while now. Am a 30 year old who’ve told himself that I’ll study programming for years and reading within this sub have encouraged me on a path towards finally studying Python. Am more than half-way through the introductory freecodecamp course with the book from py4e side […] |
| SQL Server 2022 - Development |
| Reporting periods - trying to find the best way to automate a report only the current reporting period. Each are 8 months long and start/end on certain dates. RP 1 : 07/01/2021 to 02/28/2022 RP2: 03/01/2022 to 10/31/2022 RP3: 11/01/2022 to 06/30/2023 RP4: 07/01/2023 to 02/28/2023 The only ID's and values that should show up are 142 and […] |
