|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Azure Monitor Storage | |
If I use the Azure Monitor service to gather metrics and then alert based on data, how long is the data stored in this service before I would need to archive it to another storage location? | |
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) |
Data Analytics Classification I If I am searching for the answers to question about why something happened, what type of data analytics activity am I performing? Answer: Diagnostic Analytics Explanation: Diagnostic analytics helps answer questions about why things happened. Ref: Explore Data Analytics - https://docs.microsoft.com/en-us/learn/modules/explore-concepts-of-data-analytics/4-explore |
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 - Administration |
Help with proper indexes - I am new to sql server and hav been researching indexes but I am still not sure on the best practice for indexes for one of my tables. The table currently has over 12 million rows and has a primary key that is just and auto id field. I have several fields we usually search […] |
SQL Server 2016 - Administration |
Installed SQL 2019 and trying to uninstall 2016 stuff and am unsuccessful. - I have 2 items left in Add remove programs: SQL 2016 and 2016 setup I have ran through the SQL 2016 uninstall several times but it does not allow me to remove SQL Client Connectivity SDK. I check it and then it goes to the Ready to Remove and Edition is blank and Action is […] |
Avg Disk Queue Length Issues - Hi All, We are running a production system with MS SQL2016 Std and for the past year or so things have been going well... Then all of as sudden about 1 month ago I started recieving complaints about Server Timeouts. I used Perfmon to analyze the Server and found that Avg Disk read and write […] |
SQL Server 2016 - Development and T-SQL |
Question About Deadlocks - Hi, my understanding of deadlocks is that 2 queries become deadlocked if query 1 locks table A and then wants a lock on table B while query 2 locks table B and then wants a lock on table A. We have had a deadlock where one of the queries only uses a single table, so […] |
SQL 2012 - General |
How to get rows that have sourctype 484456 only when group by GivenPartNumber_No - I work on sql server 2012 i need to get rows that have source type 484456 when group by two columns group by GivenPartNumber_Non and vcompanyid so i need to make select query display every group of rows by GivenPartNumber_Non and vcompanyid have source type 484456 only may be this group one row or 2rows […] |
DML STATEMENTS ON OLTP TRANSACTION - Hi Good morning. What is the better approach when applying DML statements on the OLTP transactions? when updating the rows in a table delete the rows and insert new rows or update the rows with a new column value. Please give your valuable advice. Thank you. |
SQL Server 2019 - Administration |
Using Availability groups with a named instance - Hello, I'm working on migrating from an existing multiple FCIs to Instances with availability groups. I'm attempting to keep the impact to my customers as small as possible so I'm wondering about connection strings with availability groups. Current Environment, multiple instances some as named instances in existing FCI SQL1 and SQL2\NamedInstance Proposed new environment. Physical […] |
Upgraded SQL 2008 to 2016 years ago and never removed 2008 correctly. - Upgraded SQL 2008 to 2016 years ago and never removed 2008 correctly and now on 2019 I am having issues uninstalling 2008. I removed the setup files by accident and now in the add remove programs is SQL 2008 but I can't get it uninstalled correctly. Is there a way to do this? Also, I […] |
Cannot add SQL Listener to Always On - Hi all Hope someone can assist with my issue. I have a two node cluster running SQL Server 2019 ENT Edition CU14 and the nodes are on different subnets. Always On has been added and working fine however I can't add the SQL Listener, keep getting the following error: "None of the IP addresses configured […] |
SQL Server 2019 - Development |
Sub Query with incorrect column name doesn't error - Hi, Is there a reason that the following query doesn't error? select * from sys.objects where parent_object_id not in (select parent_object_id from sys.columns) The column parent_object_id doesn't exist in the sys.columns table, yet the query runs without an error. If it's a "not in" query, then an empty resultset is returned, whereas if it's an […] |
Update records used in Group By - I have this query to create a summary of donations SELECT [DonorId], SUM([DonationAmount]) AS TotalDonation FROM [dbo].[Donation] GROUP BY [DonorId], [DonationYear] What I need to do is then create a single receipt for those records. The receipt creation process can be run at any time (not just at year end) What method should be used […] |
Amazon AWS and other cloud vendors |
Facing issue with Step Function - I want to run a function every 2 mins but I want to start those 2 mins only after the excution of that function is complete. I saw that this is a usecase of Step Function so when I created my workflow. Start -> Run ECS Task -> wait(2mins) and now I want to run […] |
General Cloud Computing Questions |
Noob questions about Cloud computing - What made it so prevalent? - We're seeing everything going to the cloud these days, from data storage to phone systems. I don't fully understand what technologies have made cloud computing so prevalent and easier to implement. Is it due to Internet bandwidth? Better software? |
Powershell |
create file from xcel layout - I have an xcel file that based upon Cells defined will be used to create an output file with a .txt extension. All of the columns in xcel file are defined as "TEXT". The key to building the output file is based upon the xcel file definition. Xcel file example: A B […] |
Analysis Services |
Today my SSAS server died and I lost 500 DBs but I still have all DB files - The title sounds like a name to a new anime, and it's my daily life. All of a sudden, today after an update of Symantec Antivirus on the server (no relation, this was just the most recent change event), my poor SSAS server with 500 databases refused to start. The config of the server is: […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |