Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Development |
Workaround maximum length for a nonclustered index in SQL Server - Hi, hope everyone is well. I need to create a unique nonclustered index but that key lenght is 17oo bytes. I know the work around is to create the index with include. My question is: would that index with unique be unique? Will an insert fail if it is breaking the logic of the unique […] |
SQL Server 2016 - Administration |
Availability Group Failover - Hi We have a Avaliabilty group setup with a 4 node (plus cloud witness) setup. Two of each nodes are in seperate dataceneters and HA partners. It hasn't been an issue until now but in the last 5 crazy days one node, has a couple of times, failed over to the other HA node. It […] |
Administration - SQL Server 2014 |
How is access (read,write) granted to NT user logins? - I have a user who is trying to edit a Crystal report. She is getting ODBC errors. When I investigate, I first log using her credentials. When I open OBBC32ad.exe and examine the System datasource, the database tied to this Crystal report is not listed in the drop down of Databases. If I log into […] |
Index Optimize - Based on my understanding during the index optimize it will not take the whole database down. However, there would be impact on the performance. Do you agree with this? If yes, would you schedule any jobs during the index maintenance? |
Development - SQL Server 2014 |
Search with Full Text Index vs "normal" search - Hello, i need your help because i am feeling bad with Full text index. I need to do a search for clients, so i have implemented a full text index on my table "b_utentes". My code is fine, is working very well. But, someone ask me to do a code without use of full text...ok, […] |
SQL 2012 - General |
Always on DB - Log huge and no free space - Hi, So I've got an Always on database that is 1.4TB in size, the Always on is working fine but the log file just keeps on growing, as of now is at 683GB in size with less than .1% free. We have regular log backups and I need to find out whats using all this […] |
How to separate value exist on temp table dynamically separated by comma ? - How to separate value exist on temp table dynamically separated by comma ? problem How to separate value exist on temp table dynamically separated by comma ? i work on sql server 2012 i need to separate field TeamName by comma teamname ,teamname+'Date' i need to loop to teamname filed in tmp table #Teams then […] |
SQL Server 2012 - T-SQL |
Adding another table to a query but only wanting the top 1 for each record - I currently have query that gives me the results i needs BUT i am needing to add a new table/column to the query. select name, state, id, (case when custapps.app = 'GLG' then 'GASB' else custapps.app end) as app, version, maddr, city, zip, customers.phone, contacts.sort, contacts.email, install_date, population, customers.notes, CASE databasetype WHEN 1 THEN 'Vision' […] |
Finding error in nested stored procedure - Hi, Hope everyone is keeping safe from covid-19. I need to find which particular procedure is giving an error in the nested stored procedure. Also, as the log table in the database does not have a separate column for error message, I am unable to go any further. The error I get is - String […] |
SQL Server 2019 - Administration |
Instance connect through SSMS needs the port - Hi all, I have a weird issue where my ssms cant connect to the instance on SQL Server 2019 if i haven't given the port number. Have tried several things and i couldnt get it to work. Any ideas what it could be? thanks R |
SQL Server 2019 - Development |
Masking part of a filename with a certain pattern - Hi there I have the following input string which represents the name of a file I have created SVPP_ROYA_00001_00021_7_of_7_20200326_101116.csv There are 7 files named in the target directory SVPP_ROYA_00001_00021_7_of_7_20200326_101116.csv Now this is time date stamped and could be 7_Of_7 of 3_of_3 etc Now I want to be able to identify the part in the […] |
SQL Server Newbies |
SQL Server – Transact SQL - varbintohexsubstring - Hello there, I need your appreciated help. My version is : Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 6.1 (Build 7601: Service Pack 1) I have problem with this transaction : return sys.fn_varbintohexsubstring(1,@pbinin,1,0) Because on Activity Monitor of SQL Server […] |
SSDT |
Expression with multiple IFs - I am trying to create an expression to derive a data column value based off two other data columns. In English If VARA is greater than three characters long an the first character is "1" then VARB = VARC + ".A" + the last two characters of VARA ELSE If VARA is greater than three […] |
Anything that is NOT about SQL! |
SQLWatch - Hi, I’m wondering if someone with knowledge/experience of SQLWatch could help me out with something. We have SQLWatch set up on 2 DEV servers and 1 Central monitoring server, its working fine and the data from the 2 DEV servers is coming over to the central server, I can see alerts are being recorded in […] |
T-SQL |
pulling multiple numbers out of a string - I need help pulling multiple number values out of a string field name is Details and here are some examples of the values DETAILS Maximum width is 13'2", maximum length is 30'. Minimum total size for all custom rugs is 25 sq/ft. Maximum width is 15', maximum length is 25'. Minimum total size for all […] |