Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
AlwaysOn AG versus FCI Licensing - AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) Checking to see the licensing cost for 2 and 3. Would there be licensing cost for secondary replica or the cost would be for secondary server only? Please advise? FCI is for HA scenarios. An AG synchronous secondary replica, co-located with the primary, is for […] |
Powershell for Automating SQL Server Restore. - Team, Has anybody written a Windows Powershell Script to Automate the SQL Server Restore process. I am looking for following Input Parameters:- DB Name Backup Path The script should be able to script out the Logins before starting the Restore process. I am looking for to Restore the Databases using it's most Recent Backup copy. […] |
Verifying Backup Integrity. - Team, If DBCC CHECKDB is successful; do we still need to perform Verify Backup Integrity while taking the DB Backups. As far as i believe; if DBCC CHECKDB is successful then it means that the Database is free from any sort of corruption. In that case; there shouldn't be a need to perform Verify Backup […] |
Updates are failing - Hi All, We are facing a roadblock in production server, hope experts can give some solution here. we are having a 900GB MS-CRM on premise database with replication in place. In every 6-8 hours interval DB is declining all updates from application, unable to find the exact reason. any updates to any table is giving […] |
FO cluster.... Sql browser behaviour - Apologies if this topic has been cleared away many times. I can't locate the specifics of this if so. A new Sql 2017 Ent FO cluster default instance (1433) named instance 1 (1434) named instance 2 (1435) named instance 3 (1436) named instance 4 (1437) named instance 5 (1438) I can connect to the default […] |
SQL Server 2017 - Development |
Stored Procedure broken out into views - So my end result, I want to use the dataset in Tableau. Right now, I have a stored procedure. DECLARE @name TABLE ( VALUE1 VALUE2 VALUE3 ) SELECT DIFFERENT VALUES AS VALUE1 VALUE2 VALUE3 INTO #A FROM DB1 WHERE ( MYPARAMETERS = -1) SELECT DIFFERENT VALUES AS VALUE1 VALUE2 VALUE3 INTO #B FROM […] |
Indexing for View Containing UNION - Basic outline is that I wish to ensure uniqueness of data within a table where some of the data can be considered as "shared". Sample data and code: - The intent is "C" is not an actual owner - that all the records with "C" as their owner are effectively shared for all other owners, […] |
SQL Server 2016 - Development and T-SQL |
Disappearing posts - Hi all I've tried to post an issue that got marked a SPAM (for no reason that I could see, although I did try to edit it to correct some typos). The forum will not allow me to post the question again as it's saying "Duplicate post" but I can't see it. The post […] |
date yyyy-dd-mm in SQL 2016? - Hello, Our new serer SQL 2016 on Windows 2019 is set to language British English. My login is set to British English. Then why is the count of records showing different when using this date format: >= 2018-08-01 It's giving records total from 8th January instead of 1st August. I am comparing the same query […] |
tsql help - Hi All, Need some help in preparing a restore cmd dynamically using metadata which is stored inside a table. We need to read the file locations from the metadata table and form the RESTORE commands. -- metadata table CREATE TABLE [dbo].[FilelocationsTBL]( [dbid] [smallint] NULL, [dbname] [nvarchar](128) NULL, [logicalname] [varchar](100) NOT NULL, [filename] [varchar](300) NOT NULL […] |
Development - SQL Server 2014 |
If we pass the DB name paramter should take the backup in the same server - Hi Team, Please help me on this below metioned code. Requirement: If we pass the DB name should take the Full or Diff or Tlog backups in deafult location where the data files existed in the same server. First it should check the DB size and drive space is avaialble then it create or disply […] |
bcp exporting to txt and wish to keep nulls - How to get end result where the word 'NULL' appears if value was NULL in source table? Getting WARNING: "Error = [Microsoft][ODBC Driver 11 for SQL Server]Warning: BCP import with a format file will convert empty strings in delimited columns to NULL." , yet wherever there were NULLS in source table there are blanks in txt file. […] |
SQL Server 2008 - General |
Duplicate Query Failing to return the correct count - Hi All, WITH TempTable ( DuplicateCount, CustomerID, ActivityID, [RelatedReferenceID], [RelatedReferenceType], [Due Date], [TableType], [Team Member], [TableStatus] ) AS ( SELECT ROW_NUMBER() OVER(PARTITION by CustomerID, ActivityID,[RelatedReferenceType], [Due Date] ORDER BY [Due Date]), CustomerID, ActivityID, [RelatedReferenceID], [RelatedReferenceType], [Due Date], [TableType], [Team Member], [tableStatus] AS DuplicateCount FROM Tbl_MyTable ) Select * from TempTable The problem here is that […] |
Reporting Services |
Linked Report Parameters Not updating when master is changed - Hi , as above we have a report say with a parameter which two options and a linked report. If on the main the design is changed so the parameter can accept multiple values , the linked report doesn't automatically allow the same. We have to relink the report. Is there a way […] |
Disaster Recovery |
Attaching Multiple MDF and having LDF regenerated - There are a bunch of posts for attaching a single MDF and having the LDF regenerated using sp_attach_single_file_db. Can anyone see anything wrong with this approach for doing the same thing with multiple MDFs? 1. Detach the database 2. Delete or move the log file to a new location so it will not be found. 3. […] |