The following query can be used to determine if Automatic Statistic update is enabled: Continue reading How do you check if automatic statistic update is enabled for a database?
All posts by Codereview
Sql Interview question: What are the limitations of indexed views?
Some of the limitations with Indexed views are:
- The UNION operation is not allowed in an indexed view.
- We cannot create an Index on a nested view scenario which means we cannot create index on a view built from another view.
Continue reading Sql Interview question: What are the limitations of indexed views?
What is the difference between the GETUTCDATE and SYSUTCDATETIME functions?
These functions return data as UTC time (Coordinated Universal Time). In case of the GETUTCDATE(), the precision is in milliseconds. SYSUTCDATETIME() has a default precision of 7 digits after the seconds (aka nanoseconds). Continue reading What is the difference between the GETUTCDATE and SYSUTCDATETIME functions?
What is the difference between GETDATE() and SYSDATETIME() in SQL Server?
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?
How do you get data from a database on another server?
If you want to import data only through a T-SQL query, then use the OPENDATASOURCE function. To repeatedly get data from another server, create a linked server and then use the OPENQUERY function or use 4-part naming. Continue reading How do you get data from a database on another server?