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 […] |
SQL Server 2016 - Development and T-SQL |
LAST MAX 2 DATES - Hi Expert, I wanted to find out last max 2 dates from tabl but unable to do so i tried CREATE TABLE [dbo].[Table_1]( [div_id] [nchar](10) NULL, [customerid] [nchar](10) NULL, [div_status] [nchar](10) NULL, [logdate] [date] NULL ) ON [PRIMARY] GO Insert Data: INSERT INTO [dbo].[Table_1] ([div_id] ,[customerid] ,[div_status] ,[logdate]) VALUES ('495','-1','1','2021-02-14'), ('495','-1' ,'1','2021-02-14'), ('495','-1' ,'1','2021-02-14'), ('502' ,'-1', […] |
The step was retried the requested number of times (5) without succeeding. - We have one schedule job which is copying the backup to the offsite server through xcopy. This job successfully run for 4-5 days in a week and failed for 1-2 days due to following error. Executed as user: service_Account. The step was retried the requested number of times (5) without succeeding. The step failed. Sharing […] |
Administration - SQL Server 2014 |
Instance restart with -m flag, SQLCMD unable to connect - Hi I have a SQL Server 2014 Enterprise Edition instance running on Windows 2012 O/S where I do not have the 'sa' password. I inherited the server after the previous DBA left and I am not sysadmin on the server therefore I am not able to perform DBA tasks such as backup/restore DB, attach DB, […] |
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 […] |
SQL Server 2019 - Administration |
THANKS ! - I just wanted to post a general "THANKS" to all the helpful people here who go out of their way to help others. |
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 […] |
SQL Azure - Administration |
SQL MI - DB Snapshot Alternative - We are about to migrate our on-prem SQL boxes to Managed Instances and currently use database snapshots for various reasons. They are unsupported in MI and I wondered whether anyone had found a creative alternative? Thanks |
Reporting Services |
Header Expression based on Parameters values selected - Hi all, I am new to this blog and also new to SSRS and I am hoping this forum can help me. I have a report created with some parameters and based on the parameters, my report shows the end user what they selected. Example: Parameter 1 = Rptg_Level (user can select Customers, Groups, Regions, […] |
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: […] |