This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(10)

You rated this post out of 5. Change rating

2011-12-06 (first published: 2011-10-28)

4,080 reads

Blogs

When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...

My life has some crazy travel stretches for sure. Between speaking, office visits, customer...

In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...

Forums

Comments posted to this topic are about the item Server-Level Table sizes

Comments posted to this topic are about the item ORDER BY alias

Comments posted to this topic are about the item Optional Parameter Plan Optimization in...

There is a table tmp_tab:

CREATE TABLE tmp_tab (
id int,
val int
);

INSERT INTO tmp_tab VALUES
(1, 1),
(2, NULL),
(3, 3),
(4, 4),
(5, 5);

You want to order the rows ids by the following expression:

    ISNULL(val, id) + 1

Which of the following queries produces the expected ordering and why? (Select all correct)