Questions
Q1. Which of the following function would you consider using to get the day (day of the month) of the specified date?A. DAY()
B. DATE()
C. YEAR()
D. GETDATE()
Q2. Which of the following function would... Read More
A. DAY()
B. DATE()
C. YEAR()
D. GETDATE()
Q2. Which of the following function would... Read More
A. 199.0099
B. 199
C. 199.01
D. 199.0009
Q2. [crayon-66064dc72034f341652034/]A. 10
B. 20
C. 40
D. 8
Q3. [crayon-66064dc720353485011386/]A. 0
B. -1
See below a simple script to find latest backup date time and physical location for all the Databases in a given SQL Server...
Read MoreIf you want to get a list of SQL Server databases and their basic configuration details on your current SQL server instance, you could manually open database property windows on each and every database through SSMS and note down the...
Read MoreSometime you might want to get a list of SQL Server Agent Jobs and their schedules on your current SQL server instance. You could manually open each and every Agent job through SSMS and note down the details you required,...
Read MoreSometimes SQL Database administrators want to check whether given SQL Server instance is in clustered environment. The SERVERPROPERTY() built in metadata system function can be used to identify the clustered mode. SERVERPROPERTY() function with IsClustered Property will return “0” for...
Read More
A. SQL files
B. Text files
C. Bat files
D. XML files
Q2. What are the three essential elements... Read MoreFollowing simple script will help you to find out how long has your SQL Server been running since last startup. Please make note of that this script use tempdb information to calculate the server running time and tempdb system database is...
Read MoreBelow SQL Script will help you to find current location of Data and Log File of the Database. It shows the file location of every database on a SQL Server...
Read More