วีดีโอ

Install replication or you modify an existing instance to install replication features SQL Server Enterprise, Standard and Developer edition replication features supported select @@version If features not installed you can install and on existing instance..

Please check this content th-cam.com/video/C6qOvXPrt3k/w-d-xo.html

Database backup depends on the size of your business Critical/importance of data , frequency of data transaction , Database size etc.. 1.If database full recovery model Take full backup every day after business hours and T Log backup every 15 minutes. 2.If database is Simple recovery model Take every day full backup after business hours 3. If database very critical ,Size is more than 500 GB and full recovery model Full backup once week diff backup each day after business hrs. T Log backup every 15 minutes .. 4. If Database is sample mode and size more than 500 GB once a week full backup and every day diff backup So All depends on database size , available space , Importance of data and maximum acceptable data loss by business ...

Below example I joined two database columns into one results .. SELECT CONCAT( [Name],[GroupName],AHD.[ModifiedDate],AHE.[JobTitle]) AS Result from [AdventureWorks2016].[HumanResources].[Department] AHD Inner join [AdventureWorks2019].[HumanResources].[Employee] AHE ON AHD.[DepartmentID] = AHE.[BusinessEntityID]

Why did you laugh bro?

You're very welcome!

this video Remove all publication, subscriber & distributor in SQL Server use [master] exec sp_dropdistributor @no_checks = 1 GO above command will drop distribution and all publisher and subscription configuration ,you have to run Distributor server please let me know error details ..

Thanks ..SQL 22 added new ordinal column, SQL 22 now easily you can find the row number of each split string ..

Replication latency problem you will able to truncate only once transactions get replicated to Subscriber wait to get transactions replicated to subscriber. Check Log Reader Agent job must be enabled and ruining if any issues fixe the Log Reader Agent job. Do some investigation and try to find the table and pending transaction details if table not big size you can remove the article and add back to replication try to shrink the log. DBCC OPENTRAN to find the active transaction sp_replcmds -transactions marked for replication sys.dm_repl_traninfo -Returns information on each replicated or change data capture transaction sp_replmonitorsubscriptionpendingcmds -Returns information on the number of pending commands

I was aslo faced same problem but after taking log backup it worked for me

th-cam.com/video/JPA_xXzFp9A/w-d-xo.html

select top 50 percent * from table_name row number function to sequence the data th-cam.com/video/77o3ZgIAnpY/w-d-xo.html

nice question even i had in my mind

@@SQLServer-DBA Thank you sir

The temporary table starts with a hash symbol (#) Once you create temporary table name get save system database named tempdb, which can be accessed via the SQL Server Management Studio using System Databases > tempdb > Temporary Tables However, if you open another connection and try the query the temp table you will get error Invalid object name Reason temporary tables are only accessible within the session ========== If you create Global temporary tables starts with a double hash symbol (##) Global temporary tables accessible across connections --------------------- SQL Server drops a temporary table automatically when you close the connection --------------------------------------- Physical tables are stored Permanently

@@SQLServer-DBA beautifully explained

SQL Server Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment.

Thanks Done..

Sure thanks

Yes, soon

Thank you 👍

Glad you think so!

Thanks for liking