A tally table is a table that contains a series of sequential numbers used as a base table to create other data sets such as calendars. There are many ways to create a tally table but I prefer the way...
Read More
A tally table is a table that contains a series of sequential numbers used as a base table to create other data sets such as calendars. There are many ways to create a tally table but I prefer the way...
Read More
As a follow on to yesterdays code snippet about finding the last modified date of SQL Server Agent Jobs, I thought I would apply the same code to find the last modified date of SQL Server Agent Job schedules. Always...
Read More
Earlier on today I really needed to see the last modified date of a job that had been disabled. I didn't know whether it was recent change or whether it was in the distant past. SQL Server Agent Job screen...
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
Divide by zero is a common error in whatever language you code in. Although an error is the correct response as you can't divide by zero, its something that we don't want to display. One method of getting round this...
Read More
A. NULL
B. 29
C. 22
D. 0
Q2. [crayon-662b1bff211f9914207615/]A. 1
B. Fales
C. 0
D. NULL
Q3. [crayon-662b1bff211fc339578238/]A. 0.999
B. 69999
You might need to know the IP Address and the TCP Port of the currently connected SQL Server; this simple SQL Script will help you to find the Server IP Address. This script only works for connections that are using...
Read MoreDatabase Mail feature can be used to send e-mail messages from the SQL Server Database Engine. Database Mail use SMTP server to send emails. Assume you want to get a list of SMPT server used by Database Mail due to...
Read More