How to add DB2 as a linked server in SQL
Here I am trying to add new linked server in SQL
November 2020
Restore database in SQL Server TSQL Statement
Here I am trying to explain how we find backup files and related information in SQL Query. Below query shows the top 100 records from backup history order by latest date Replace database name with your database name or remove from query. Below query containing information about the backup media from backup full file name. …
How to Add Linked server with a different name
Here I am trying to how to create linked server with different name. Other References:
Escape XML special characters in SQL Server Query
Here I am trying to how to work with special character in a SQL Server. Result of query (include type keyword) Result of query (without type keyword) Result of above 3 query Other Refrence
How to add oracle as a linked server in SQL server
Here I am trying to add new oracle linked server in in sql server Other References:
Get the most frequently executed queries for this database
dm_exec_query_stats, dm_exec_query_plan
Xml with null Column
How to get null value from XML column. XML requirements XML tags are case sensitive. Opening and closing tags must be written with the same caseIn XML, all elements must be properly nested within each otherIn XML, the attribute values must always be quoted“xsi:nil” represents the null value in XML Other Reference:
How to find orphan database files
Here I am going to provide sample query which help to identify database file are not using by SQL Server.
Difference between row_number(), rank() and dense_rank() window functions in SQL Server
All Three function work as per order by clause The row_number() function always generates a unique ranking even with duplicate records. RANK() behaves like ROW_NUMBER(), except that “equal” rows are ranked the same. Dense_Rank() Function is similar to Rank with the only difference, this will not leave gaps between groups. Other References https://docs.microsoft.com/en-us/sql/t-sql/queries/table-value-constructor-transact-sql?view=sql-server-ver15
How to read the SQL Server query plan file using TSQL
Here I am trying to read sql server plan (Execution query Plan) file from ssms query.
