Forum Replies Created

Viewing 15 posts - 76 through 90 (of 120 total)

  • RE: MCSA 70-461 Question

    Thanks i got what writer meant to say..

    Thanks a lot

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 6, 2013 at 8:40 pm

    #1630257

  • RE: MCSA 70-461 Question

    One of the Geek sent me message specifying the answer as C

    but how do you differenciate between standard and non standard clause?

    I don't see such distinguishment in BOL...

    http://technet.microsoft.com/en-us/library/bb510625.aspx

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 5, 2013 at 8:07 pm

    #1630206

  • RE: Find out Free Virtual Memory

    DBCC Memorystatus

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 5, 2013 at 2:31 am

    #1629982

  • RE: I want deadlock notification using mail address and record stored in table.

    Also you can try setting "sql server performance condition alerts"

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 5, 2013 at 1:36 am

    #1629968

  • RE: Autonumber field sometimes skips a 1000

    does it always skips 1000 rows or any random number?

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 5, 2013 at 1:29 am

    #1629964

  • RE: Restoring failed

    multiple reasons could be there:

    1. Some other backup process is scheduled or taken manually

    2.Recovery mode might have changed to simple and then

    3.Might have taken full backup with copy only option

    4.Might...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 3, 2013 at 2:05 am

    #1629399

  • RE: How to connect SSMS 2012 with database engine?

    you question is not clear enough..

    hope this may help:

    get the servername from sql server configuration manager (run>sqlservermanager11.msc)..

    open ssms2012 and try connecting to the above server with your credentials.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 1, 2013 at 1:15 am

    #1628617

  • RE: Problem with Co-Related Subquery

    There could be multiple reasons to it,,

    There is huge date in the work_order and task_seek table

    index is missing or inappropriate

    sol:put the result of these tables in temp tables without applying...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 27, 2013 at 7:23 am

    #1627953

  • RE: ?? on shrinking transaction log

    to reclaim the space using shrink command,following command should return 'NOTHING'.

    else the log won't be truncated and file won't shrink

    select log_reuse_wait_desc from sys.databases where name='Your_db_name'

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 27, 2013 at 7:18 am

    #1627951

  • RE: Data corrupted, any advice?

    if i were you then i would have taken the backup first then

    tried

    DBCC CHECKDB (<db>, REPAIR_ALLOW_DATA_LOSS)

    Note:note sure this will work on 2000 or not?

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 27, 2013 at 4:13 am

    #1627894

  • RE: Login failed for user

    are you able to connect to the database using ssms with same user?

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 27, 2013 at 3:32 am

    #1627881

  • RE: SQL 2008 Mirroring

    you can use 2008 express edition as a witness instead of using 2005..

    Edition do not matter for witness server but versions do matter.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 27, 2013 at 3:28 am

    #1627879

  • RE: Float Data Type

    Thanks Martin and Hugo

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 27, 2013 at 3:21 am

    #1627876

  • RE: Logshipping Alerts

    sql server agent>alerts>Log shipping_<xyz>

    right click and disable on both primary,secondary

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 26, 2013 at 10:31 pm

    #1627795

  • RE: TOP clause WITH TIES

    Nice one

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    June 26, 2013 at 10:27 pm

    #1627794

Viewing 15 posts - 76 through 90 (of 120 total)