restore Ssis database on same server

  If I want to restore database of SSIS catalog as yesterday's status on the same server overw…

Concurrency Control in SQL Server

Comments posted to this topic are about the item Concurrency Control in SQL Server

Defending Against Ransomware

Comments posted to this topic are about the item Defending Against Ransomware

Tempdb Default Size

Comments posted to this topic are about the item Tempdb Default Size

Normalization query challenge -- more an intellectual exercise than anything

Since I'm stuck at home with way too much time on my hands, I was looking at a really horrid databa…

Using result of previous function call in SQL Server... or any better idea

I use a recursive CTE ;WITH cte ( -- anchor UNION ALL -- recursive parte ) SELECT * INTO #Reser…

How to get column names in the row wise along with their values

replication error

we configured  transactional replication  with  account as sql user having sysadmin on sql , but wh…

Daily Coping 11 May 2020

Today’s tip is tell someone about why your favorite music means a lot to you. My thoughts: http://v…

Windows update on Virtual SQL Server 2016.

We have a Virtual Server with Windows Server 2012 & SQL 2016 installed on it. When we restart t…

nvarchar - int comparisions

I have an nvarchar column size which has values like 1200 MB How do I compare in a where clause : w…

Search All Tables for a specific Value & return the location

Hi Forum, I need to find a Value in a database and have seen some useful code to do this. The only …

Self join / row_number() partition number generation based multiple status

Thanks in Advance:) Whenever there is a change in Status or Comment for name_id then we need to con…

Postgresql JDBC Tutorial on Linux

Comments posted to this topic are about the item Postgresql JDBC Tutorial on Linux

The Rounding Calculation

Comments posted to this topic are about the item The Rounding Calculation