Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
SQL Server 2017 Availability Groups - I could really use some sage words of wisdom from the SQL Server Central community on Availability Groups in SQL Server 2017. I’ve wanted to implement AG for a while now but a coming increase of 200x our current work and going to 24x7 operation with no maintenance window has pretty much forced them into […] |
SQL Server 2017 - Development |
one Rows in two Line in Result one line in one row - Hello, i have often the Problem that i must the information from 2 line (1 row) i need in 1 line Example: Select car,model,engine,details from cars ( |= stands for row) Honda| Civic| 1.6| deluxe Honda| Civic| 1.6| basic VW| Golf| 1.5| basic VW| Golf| 1.5| extra Dodge| Viper| 8.4| performance Dodge| Viper| 8.4| last_edition […] |
SQL Server 2016 - Administration |
Collation Error: 468 when trying to view login properties in SSMS - Hello experts, I was recently confronted with a dev SQL Server that had been installed with the SQL_Latin1_General_CP1_CI_AS when it requires SQL_Latin1_General_CP1_CS_AS. I tried the steps at the following link, which looks like they rebuilt the system and user databases using SQL_Latin1_General_CP1_CI_AS. Change SQL Server Collation – Back to Basics The recommended command was (using […] |
How to display non-English characters in SSMS ? - I have a table that contains English and non-English entries, particularly Russian. The column is defined as nvarchar. If I BCP it out and open in notepad, it clearly displays Russian characters. But not in SSMS. Is there any setting for this? My SSMS version is 13.0.16106.4. Thanks |
Is AG listener name being used in the apps...how to capture on the SQL side? - Due to the hurricane season around we have a requirement to have all the applications point out to using the AG listener name. However, we would like to identify if there are any connections that are coming through and hitting the actual SQL instance name instead of using the AG listener name...this would help us […] |
SQL Server 2016 - Development and T-SQL |
Merge not updating in explicit transaction - We have the following code in a stored procedure which has a merge statement and an update statement to a different table in an explicit transaction. The merge update does not update any data in the inventory.gtin table but the update statement below it works and data is updated in the import.file_data table when the […] |
SQL 2012 - General |
SQL 2012 Always-On issues? - Hey Eveyrone! We have a 2012R2 Always-On setup for our application. It does get very busy more so at the end of month, however, just recently, about 2 weeks ago a lot of our clients are getting timeouts when connecting to our web app. The application admin is blaming Always-On but after reviewing the wait […] |
SQL Server 2012 - T-SQL |
Filtering out based Start Date and End Date - Hello, I have query contains both start and end date, i would like to filter out data based on two dates. I need only 2019 and higher data either based on start or end date, if you can have a look examples. i need ID 1,2,3,6,7 and 4,5 is not required. I have tried using […] |
SQL Server 2019 - Administration |
moving one 500 GB DB from lower version to SQL Server 2019 - Hello Gurus, Task is to move a 500 GB DB from lower version ( source ) to a brand new server ( destination- SQL Server 2019 ) . Plan is to use logshipping. Take a full backup on Source , restore full backup on Destination with Standby / ReadOnly . Tlog backups will automatically be […] |
SQL Server 2019 - Development |
Week Ending Thursday, can some one tweek my code? - What I have missed from this code? I'm trying to show the DateTimeRaised field as a week ending Sunday and week ending Thursday. The FkIssueGroupID isn't unique but each row should have the same date. The MAX is being used to bring back a single row. Whilst the week ending value for Thursday is correct […] |
Find Space occupied by a Row - Hi All, Do we have any way to find out the space occupied by individual records in a table? My objective is to find out the space occupied by each record in a table where columns names can vary from int, float, varchar, nvarchar(max) etc. For example, in below table, where content of both the […] |
Invalid length parameter passed to the LEFT or SUBSTRING function. - HI, I am using the below query to fetch a data from SQL server. But the query returned Invalid length parameter passed to the LEFT or SUBSTRING function. error. Any help in solving the issue would be much appreciated. TIA. SUBSTRING(output_response_xml, LEN(LEFT(output_response_xml, CHARINDEX ('>Thank you', output_response_xml))) + 1, LEN(output_response_xml) - LEN(LEFT(output_response_xml, CHARINDEX ('>Thank you', output_response_xml))) […] |
syntax error on insert - Hi, I am brand new to SQL. I'm using postgres with PopSQL interface. I am trying to run the following basic code from a tutorial but it gives me a Failed Error: syntax error at or near "INSERT" Here is the code: CREATE TABLE people ( id INT, name VARCHAR(255), PRIMARY KEY(id) ) INSERT INTO people VALUES (1, 'Corey'); |
Reporting Services |
AccessibleTablix - I am following this article to turn on AccessibleTablix=true in RsReportServer.config in SSRS 2017, but cannot find the tag. Section 508 and SSRS Help please |
COVID-19 Pandemic |
Daily Coping 29 May 2020 - Today’s tip is today link your decisions and choices to your purpose in life. Daily Coping 29 May 2020 |