2017 Standard Edition Listener limit - Is there a limit to the number of listeners that can be created using SQL Server Standard? I'm working with a...
Average number of records per hour per datetime range - Hi, I have a DB with PATIENT_ID, ARRIVAL_DATE, DEPARTURE_DATE, and DEPARTMENT. I need to find the average number of patients in...
Automation of refresh database from Prod to Dev using power shell script - Hi experts, Can someone please post a good power shell script to automate database refresh on Dev from Prod? Thanks.
Need to setup PULL subscription in a 2-node SQL 2016 Enterprise AlwaysOn Environment - These instructions did not work for me: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/replication-subscribers-and-always-on-availability-groups-sql-server Deployment included: Using an e
Data Copy for reporting purposes - Hi! @ present we have a reporting server which is for internal and external users..they run regular reports. - we keep the...
Memory Optimized FileGroups - In the SQL 2016 documentation it states that you must create a new filegroup called Memory_Optimized_Data ut when I open...
Help me with for Xml path() - Hi all, drop table #temp drop table #statistics create table #temp ( ID int, varchar(100), BATCH_NO int, Xml_name varchar(50)) ...
Count(*) with LIKE - I am working on converting an Excel formula to Excel. I have successfully moved two other Excel reports to SQL...
SSIS Permission issue with reading file from SharePoint page - I have an SSIS package that uses a script task WebRequest object to download a file from a Sharepoint page. ...
Backup of DB while it is configured with log shipping - I have a script which I use to take the backup of our DBs to the cloud. I am just...
Need Recommendations for Document Database - We're in the process of a data migration from one LOB tool to another over this weekend. Part of the...
Decimal place in SQL - I have a dumb question, I have values like 0054880, 0054885 0054890 and I need values like 5488.000,5488.500,5489.000 How can I do...
How to distinct values and adding row numbers while keeping original order? - How can i get a distinct list of the lcc_codes below removing null lcc_codes and with a row number while...
Enter maximum value on the basis of 2 independent tables. - Hi Folks, I stuck in a puzzle, please suggest a way to resolve this. I have 2 below Tables in my database. Tab_A...
Two tables that they have foreign keys pointing to each other - Hi, I have an unusual problem in that I have to remove records from two tables that they have foreign keys...
Upgrade - Planning to upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2 SP3. The database on the server are...
Missing the Control Flow tasks in the Toolbox - Hi! I am on the Control Flow tab. In my Toolbox, I only see Maintenance Plan Tasks and General. There is nothing...
Indenting wrapped text - This one is probably very simple, but I'm not sure. I am using SSRS 2005, and I already have a...
Creating a Hyper-V "template" for multiple production servers - Goal: To create a "template" of a VM (in Hyper-V) that could be "cloned" for multiple production servers. Problem: Renaming "Template"...
Migrated DB to 2016, having ODBC Access problem - Thanks in advance for any clues on this problem. I'm migrating several SQL Server databases from SQL2005 to SQL2016. One...
