Tag: John F. Miner III

Math Functions – SQRT()

admin

I am going to knuckle down and write another short article or tidbit on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the SQRT() function today. This function takes an expression of type float or of a type that can be…

Math Functions – SQUARE()

admin

I am going to dig in and write another short article or tidbit on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the SQUARE() function today. This function takes a number N as input in either exact numeric or approximate numeric…

Math Functions – POWER()

admin

I am going to remain on course with my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the POWER() function today. This function takes two expressions, a base B and a exponent/power N, as…

Math Functions – SIGN()

admin

I am going to press on with my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the SIGN() function today. This function takes as input a expression in either exact numeric or approximate numeric…

Math Functions – PI()

admin

I am going to stick at writing my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the PI() function today. This simple function returns the mathematical constant of PI as a float. This function…

Math Functions – ROUND()

admin

I am going to keep going with my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the ROUND() function today. This function takes as input a expression in either exact numeric or approximate numeric…

Math Functions – FLOOR()

admin

I am going to carry one with my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the FLOOR() function today. This function takes as input a expression in either exact numeric or approximate numeric…

Math Functions – CEILING()

admin

I am going to continue my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the CEILING() function today. This function takes as input a expression in either exact numeric or approximate numeric form. This…

Math Functions – ABS()

admin

I am going to start a series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005. I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject. I will be exploring the absolute values, ABS() function today. This function takes a expression in either exact numeric or approximate numeric form and…

Page Anatomy – Part 2

admin

I am going continue my series of articles describing how information is stored and organized in a Microsoft SQL Server database. Today, I am going to talk about the Database Boot Page. All of the information is a gleamed from SQL Server 2008 Internals book by Kalen Delaney. If it is not on your bookshelf, I suggest you go out and by a copy. The online MCM training videos from Paul Randal are also an excellent resource. A single page (8K) is the smallest unit in which SQL Server allocates…