| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Development |
| Call Dates Effective Range - Hi Everyone, I have the data in the below form : Desired output: Here what I did is I made a range of dates of the same year in 1st image using the call date start date(in Select) and now I have the 1st date of the year starting to the day before the effective […] |
| Development - SQL Server 2014 |
| Need help on results output - Hi guys. I need help with query results output. I have the following table: create table MyTable(HH int,F int,T int,Val int) insert into MyTable (HH,F,T,Val) values(2,6,7,11), (2,6,10,1), (3,7,6,12), (3,6,7,17), (4,6,7,15) I need to show those F/T values on the same HH. Something like this HH F T VAL F T […] |
| SQL Server 2019 - Administration |
| SSRS configuration issue - cannot connect to SQL Server - I had some issues with a local (development computer) Report Server where the configuration manager, Report Builder apps, etc. would not connect to the SSRS. The service was running and the DB's were accessible through SSMS. After not getting any help I decided to uninstall SSRS and reinstall. During the install process, at the Database […] |
| SQL Server Transaction Replication Issue: BIT Columns Not Refreshing - Hello Everyone, I have a database that is being copied to six subscribers with several publications. I have noticed that sometimes, when updating the bit data typed column, the updates are not being sent to all subscribers. Out of six, five subs are working perfectly while one is not. I've also reviewed the schema options, […] |
| Cluster Timeout Settings to handle transient network outages - I have an Availability group with 2 replicas on the same subnet. We've been experiencing short network outages that last a few seconds and cause connections to timeout. This causes the AG to fail completely (not failover automatically) and we have to manually bring it back online since the DBs are marked "not synchronizing" on […] |
| Question about SQL Certs and DNS aliases - About 15 years ago we started creating DNS aliases for each database. This allowed us to move databases without needing to change client connections. We now use these aliases in all applications, reporting, ETLs, etc... When we upgrade SQL we create new servers and migrate the databases, using the aliases made this simple. We also […] |
| SQL Server 2019 - Development |
| SSIS Package runs on one server but getting an assembly component error on anoth - I posted this over on Stack Overflow and got bupkis and was hoping someone over here would be able to help me. I have an SSIS package that has been tested, and ran in Visual Studio 2019. It was originally created, tested, and ran in VS 2017 but when I started having the issue I […] |
| Integration Services |
| Developing with SSIS outside sql server - For 15 years I worked with tens of SSIS instances with various customers, always from a remote session. I am used to setting up an RDP to the SSIS server and then using Visual Studio / SSDT (as installed on server) to develop. At my current job I want to work with SSIS , but […] |
| Suggestions |
| I don't want to be a PITA here...but - Can someone explain to me why, when I post something, so many times the first attempt rejects me with 'Are you sure you wanted to do that?' and makes me submit my comment again and even then sometimes times out and makes me try a third time? And then sometimes it even puts my comment […] |
| SQL Server 2022 - Administration |
| Trying to add some specifications to existing audit log in sqlserver but not wor - Trying to add some specifications to existing audit log in sqlserver but not working 1. Already audit log is in disabled state in server level and in database level , audit log is disabled but cannot do audit add specifications in sql server when I tried to run the specifications its giving below error Msg […] |
| Password change effect in SSRS - Installed the SSRS and setup the unattended execution account. After setup SSRS, changed the domain account password in AD & apply the same password in Report server configuration manager for unattended execution account. But Getting the below error. The report server has encountered a configuration error. Login failed for the unattended execution account (rsserver configuration […] |
| SQL Server 2022 - Development |
| BUY WEED Online, WhatsApp +1(615)314-6286,CANADA ONLINE, free shipping. - https://lumpysfarms.com/ BUY WEED Online, WhatsApp +1(615)314-6286,CANADA ONLINE, free shipping. ORDER CANNABIS CANADA, BUY CANNABIS ONLINE USA, UK, EU EMAIL: larrykarius247@gmail.com Telegram: https://t.me/lumpysflowere WhatsApp: +1(615)314-6286 Website: https://lumpysfarms.com/ Order weed online , buy weed online, Buy cannabis online, Order cannabis online without a medical card from Lumpys a legit online dispensary in USA, online dispensary Ohio […] |
| Start SSMS Activity Monitor with Task State = (NonBlanks) - I've been searching for this and cannot find any mention or discussion on it yet. So, I'll try here where I seem to have the best results for help... I would like to have Activity Monitor start with the 'Task State' column having the '(NonBlanks)' filter selected by default [rather than (All)]. Does anyone know […] |
| Adding rows from Lookup where not in Data - I'm trying & failing to add all possible codes from a Codes table, where those codes are not present in the data. Here is a simplified set of data: DROP TABLE IF EXISTS #Codes CREATE TABLE #Codes([Standard] VARCHAR(4), Code VARCHAR(6)) INSERT INTO #Codes ([Standard], Code) VALUES ('STDA', 'Code1'), ('STDA', 'Code2'), ('STDA', 'Code3'), ('STDA', 'Code4'), ('STDA', […] |
| Text column is taking More time while Querying, Need to Replace DATALENGTH - select * from dbo.resolutions r where R.documentid = 828222222 and DATALENGTH(r.resolution_text) > 0 resolution_text Text column is taking More time while Querying, Need to Replace DATALENGTH, when i replace datalength condition as "r.resolution_text is not null" the above query is returning data |
