Steve is back with 7 points ....:-)

Try creating a filtered index

I have given the example as follows;

CREATE TABLE tbl(col1 tinyint);

create unique index tbl_idx on tbl(col1) where col1 = 1;

INSERT INTO tbl VALUES(1),(0),(0)

INSERT INTO tbl VALUES(0),(0),(0)

The above...

Interesting one 🙂

to arrive to the solution, I tried with guest account (because this account generally has downward pointing arrow)

so , one option is for sure,

Connect permission has been revoked

after this When...

Truly, this site is giving lot of information every day, I am learning a lot through this site.

I thank every one who is contributing

This is interesting and funny, though it is not in the answer options 😉

Andy could have used it as one...

Why this question is worth 4 points ?:hehe:

I generally use the below sql for logical name,physical name and path for any db, so this number seemed very familiar, after seeing the question, I have immediately tried the...

Though QOTD mentions to use sql2012, I had to use only 2008 R2 and i tried with row_number.

option A and B returned the same result in 2008 R2

but for option...

Interesting Question and learnt something new today, Never escaped before 🙂

I was also tossing between 2000 or Cloud, but selected 2000 option

:crazy: :crying:

BWFC (6/17/2014)

rhythmk (6/17/2014)

BWFC (6/17/2014)

Could you enlighten me on that please? It sounds very...

+1

Hi,

I have tried taking the backup with the following t-sql commands

case I

-----------------------------------------------------

backup database XTEST_DB to disk

='c:\XTEST_DB.bak' with compression

backup database XTEST_DB to disk

='c:\XTEST_DB.bak'

-----------------------------------------------------

Both the backups are successful. first backup is with...

+1