Useful tips for everyday
What is SQL Server patches? A brief overview of SQL Server Patches Here is a quick overview of the SQL Server updates. Service Pack: A…
How parse XML in SQL? These are the steps I performed for importing data into SQL Server and then parsing the XML into a relational…
Is defined as a snapshot of DBMS state? A database snapshot is a read-only, static view of a SQL Server database (the source database). While…
How do I remove a table partition? The Steps: DROP INDEX CIDX_X on X /* drop the clustered */ CREATE CLUSTERED INDEX CIDX_X1 ON X(col1)…
How long does it take to restore a SQL Server database? Restoring to a point in time with SQL Server, could take a significant amount…
How do I create a table with more than 1024 columns in SQL Server? In order to create more than 1024 columns, you have to…
Can we use two columns in WHERE clause in SQL? Answer. Yes, within a WHERE clause you can compare the values of two columns. When…
Do you have to update all records in a collection? For a collection, the entire record must match. Collections allow duplicate records, so multiple records…
Which Azure service can be used to ingest data? Azure Data Factory Azure Data Factory is a tool that ingests, automates, monitors and orchestrates the…
How to check if a column was updated inside a trigger? There are three ways one can check if a column was updated inside a…