With the GETDATE() function, the precision is in milliseconds, and with the SYSDATETIME() function, the precision is down to 100 nanoseconds. Continue reading What is the difference between GETDATE() and SYSDATETIME() in SQL Server?
Category Archives: Sql Server 2008
Data integrity & Business re-engineering
Usually when a company enrolls into a data clean-up exercise the focus is mainly on the in-depth analysis and profiling of the data.
Sometimes it’s worthwhile to step back from the in-depth look at data cleaning to get some perspective.
You should start asking questions like “Why is data dirty in the first place?”, “Are any of the clean-up exercise that we are currently doing reversible ?” or “Does this really need to become an ongoing process ?” Continue reading Data integrity & Business re-engineering
Why do we end up with Dirty Data [platform agnostic] ?
One of the biggest themes in operational databases and data warehouses alike that is universally recognized but far too often ignored is the cleanliness of the data.
From hundreds of meetings with data processing and IS staff, I have identified three consistent themes.
Although these three themes stand out dramatically as the biggest problems in corporate data access, the same data processing and IS staffs that identify them are usually attacking only the first two of them. Continue reading Why do we end up with Dirty Data [platform agnostic] ?
#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?
#SqlServer interview question: What are table-valued parameters?
Table-valued parameters is a feature introduced in SQL Server 2008. In earlier versions of SQL Server it was not possible to pass a table variable into a stored procedure as a parameter.
In SQL SERVER 2008 we can use table-valued parameters to send multiple rows of data to a stored procedure or a function without creating a temporary table or passing in multiple parameters. Continue reading #SqlServer interview question: What are table-valued parameters?