Change Tracking was a much anticipated feature in SQL Server 2008. Prior to SQL Server 2008, SQL DBAs had to code complex triggers and archive tables in order to track changes made to their database tables. Continue reading #Sql Server interview question: What is change tracking inside SQL Server 2008?
Category Archives: Sql Server Tutorials
Exemple of SQL Server Cursor
Scenario
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples? Continue reading Exemple of SQL Server Cursor
#Sql Server interview question: What is a ROLLUP Clause?
The ROLLUP clause is used to do aggregate operations on multiple levels in hierarchy. Continue reading #Sql Server interview question: What is a ROLLUP Clause?
#SqlServer interview question: What is ROW_NUMBER()?
ROW_NUMBER() returns a column as an expression that contains the row’s number within the result set. This is only a number used in the context of the result set; if the result changes, the ROW_NUMBER() will change.
Thanks for reading this article,
Next steps :
- Share this with your colleagues because Sharing is Learning
- Comment below if you need any assistance
Powered by CodeReview – Let’s make it Better!
#SqlServer interview question: What is Change Data Capture (CDC) in SQL Server 2008?
Another innovative feature in SQL Server 2008 is Change Data Capture (abbreviated as CDC). The concept is similar to Change Tracking but with a major difference.
CDC tracks every field in your table(s) – not just the primary key fields. Change Data Capture (CDC) records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables and makes a record available of what changed, where, and when. Continue reading #SqlServer interview question: What is Change Data Capture (CDC) in SQL Server 2008?