Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: ANSI_NULLS

    Thank you Paul... Good Question..Learn lot from this..

  • RE: What will be output?

    Thanks good question :-). For info rmation if we write question like this

    declare @a int

    declare @b-2 varchar(2)

    set @a = 10

    set @b-2 =...

  • RE: SSRS case sensitivity

    Good Question

  • RE: Rowcount

    Hi All,

    I got right answer(0,1) in SQL 2005, but this not in the fresh query window, first I executed pervious question query in query window then I executed this one,...

  • RE: Indexes in SQL Server 2005

    I got right anwser but it's true for the SQL Server 2008 not for SQL Server 2005.

    Please Change the question or add one more option with 250.

  • RE: Session Settings

    Thanks bitbucket for a nice question i learnt lot from this....

  • RE: Dynamic SQL

    I changed the table name, Now it works fine in 2005. good Question!

    Thanks to Sudhir.

  • RE: Shrink DB and Log on 2008

    After doing whatever proccess told by Henrico. Database size remain same, and in my database ldf size is 15gb and mdf size is 200mb.

    Actually I want to make ldf size...

  • RE: Shrink DB and Log on 2008

    Thanks Vikas for quick reply, I already use

    DBCC SHRINKFILE (DBName, Size)

    for reducing my database but it not work. Database base log file size remain same.

    I also run a script:-

  • RE: T-SQL

    The answer should be false.

    When I run the four statements, I get:

    2009-11-16 16:38:22.217Monday

    2009-11-16 16:38:22.217Monday

    2009-11-16 11:08:22.217Monday

    2009-11-16 11:08:22.217Monday

    Here time and minutes are different.

Viewing 10 posts - 1 through 10 (of 10 total)