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?
Category Archives: Interview Questions
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?
What is auditing inside SQL Server?
SQL Server audit offers features that help DBAs achieve their goals of meeting regulatory compliance requirements. SQL Server audit provides centralized storage of audit logs and integration with system center. SQL Server audit was designed with the following primary goals in mind: Continue reading What is auditing inside SQL Server?
#Sql Server interview question: What is filestream in SQL Server?
Filestream allows you to store unstructured large objects (text documents, images, and videos) in the file system and have these files integrated within the database. Filestream basically integrates the SQL Server Database Engine with NTFS (New Technology File System); it basically stores the data in the varbinary(max) datatype. Continue reading #Sql Server interview question: What is filestream in SQL Server?