I had asked the same question for previous question on spatial data question....

A very Important command that anyone working on sql server should know (be it a developer or dba). It gives very basic onset information about database on server like

DB...

Nicely written Article, Alok.

Its always a good to read any article which had combination of enough code and to-the-point explanation in it.

Interesting question.

I got it right just because I executed it in SSMS and saw results. But without executing I would had selected option 6 also.

Interesting question. It succeeded on one server but failed on other. 'Cause the MSSQL\Backup directory is on F:\ drive instead of C:\.

Not sure if that was the...

Ol'SureHand (11/4/2009)

---

IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).

That is because the BACKUP command comes AFTER...

Execute this.

DECLARE

@p_SPID int,

@p_SQL nvarchar(2000)

DECLARE #cur_Processes CURSOR FOR

SELECT

p.SPID

----------> AND spid >= 51 (because spid's of 50 or less are reserved for internal use.)

FROM

master.dbo.sysprocesses...

On a Halloween day I expected a scary question than a routine one.

Does, Steve lost his sense of HUMOR ? 🙂

Take it easy.

Damn. I missed the increment/seed part. Generally we used (1,1) for identity column and its (1,3) in the question.

Agreed with Steve. It's a bad formatted question.

Thanks for the article, Gail.

"When an index scan is done on the clustered index, it’s a table scan in all but name."

Then why do we see index scan and table...

Does any one uses mixed datetime styles in a single query like the above one ?

I haven't seen any.

It's easy.

For

1). Since the plan had full, differential and TLog backup steps SSMS will create 3 jobs each for one of its kind. You cna change schedule or manage...

Had used LiteSpeed and SQLSafe before and they both does compression, encryption. With LiteSpeed you can take backup and save file on different network.

ftp ? I doubt. Have...