Forum Replies Created

Viewing 15 posts - 1 through 15 (of 86 total)

  • RE: Rebuilding Indexes very often is good?

    No rush but I am looking forward for you to release an article or post on the presentation you did yesterday. Very very good, Jeff!

    --Pra:-):-)--------------------------------------------------------------------------------

    May 11, 2018 at 12:44 pm

    #1990240

  • RE: Rebuilding Indexes very often is good?

    Jeff Moden - Thursday, March 22, 2018 8:04 AM

    paul s-306273 - Thursday, March 22, 2018 3:38 AM

    --Pra:-):-)--------------------------------------------------------------------------------

    May 10, 2018 at 3:06 pm

    #1990124

  • RE: Extremely basic Instance naming convention - Opinion needed

    No we set the AGs to failover manually. I know, it kind of destroys the purpose. Good point on the instance naming for auto failover AGs though! Thanks

    --Pra:-):-)--------------------------------------------------------------------------------

    April 12, 2018 at 7:56 am

    #1986588

  • RE: Static Port conflicts

    Thanks, Perry! I understand what the listener functionality is. My only question is that I am able to login through listener with a different port number that it has no...

    --Pra:-):-)--------------------------------------------------------------------------------

    March 29, 2018 at 11:39 am

    #1985020

  • RE: BAckup's not completing 100%

    thats what i am wondering how to send.. A private message????

    i know its pretty known to evryone but just wondering...unless if u want me post here

    I am okay with doing...

    --Pra:-):-)--------------------------------------------------------------------------------

    May 5, 2014 at 12:02 pm

    #1710826

  • RE: BAckup's not completing 100%

    Lowell,

    I am not usuing raw dbnames but using a cursor to loop through all the dbs and back them up to the folder location. There is no...

    --Pra:-):-)--------------------------------------------------------------------------------

    May 5, 2014 at 11:39 am

    #1710815

  • RE: Index fragmentation not cutting down to 0

    thanku i just came to know that.. Thanks for the quick response 🙂

    --Pra:-):-)--------------------------------------------------------------------------------

    January 20, 2014 at 11:26 am

    #1681651

  • RE: what is Copy-Only Backup?

    eng_mgomaa (8/11/2010)

    Copy-only backups are not supported via SQL Server Management Studio (SSMS)

    and must be performed via the Transact-SQL (T-SQL) BACKUP command.

    I dont think so.. I have a check box with...

    --Pra:-):-)--------------------------------------------------------------------------------

    December 12, 2013 at 12:31 pm

    #1673066

  • RE: Production databases, people involvement

    adb2303 (12/11/2013)

    might also be worth looking in the default trace to track some of those changes retrospectively

    Default Trace???

    --Pra:-):-)--------------------------------------------------------------------------------

    December 11, 2013 at 9:03 am

    #1672669

  • RE: Production databases, people involvement

    Keith Tate (12/11/2013)

    Do you want to prevent them from dropping objects? If so, you could write a DML trigger to prevent that:http://technet.microsoft.com/en-us/library/ms191524(v=sql.105).aspx. Or you could use the trigger to write...

    --Pra:-):-)--------------------------------------------------------------------------------

    December 11, 2013 at 9:02 am

    #1672668

  • RE: sql datatype convertion error??

    Erin Ramsay (4/18/2013)

    prathibha_aviator (4/18/2013)

    I know right but apply the same on below

    IF (SELECT COALESCE((SELECT dI.[entry] FROM InitialData AS dI WITH(NOLOCK) WHERE dI.dept= 'Support'

    ...

    --Pra:-):-)--------------------------------------------------------------------------------

    April 18, 2013 at 12:47 pm

    #1607962

  • RE: sql datatype convertion error??

    I know right but apply the same on below

    IF (SELECT COALESCE((SELECT dI.[entry] FROM InitialData AS dI WITH(NOLOCK) WHERE dI.dept= 'Support'

    ...

    --Pra:-):-)--------------------------------------------------------------------------------

    April 18, 2013 at 12:21 pm

    #1607946

  • RE: sql datatype convertion error??

    This is an example i gave u... with created tables and column values...and datatypes exactly replicating my original table at work...but I am missing some string conversions in my program.....

    --Pra:-):-)--------------------------------------------------------------------------------

    April 18, 2013 at 12:12 pm

    #1607940

  • RE: sql datatype convertion error??

    okay what if we do this

    IF (SELECT COALESCE((SELECT dI.[entry] FROM InitialData AS dI WITH(NOLOCK) WHERE dI.dept= 'Support'

    ...

    --Pra:-):-)--------------------------------------------------------------------------------

    April 18, 2013 at 12:03 pm

    #1607935

  • RE: sql datatype convertion error??

    sry i gave wrong values in the condition.. pls excuse

    here is the condition now

    IF (SELECT COALESCE((SELECT dI.[entry] FROM dbo.InitialData AS dI WITH(NOLOCK) WHERE dI.Dept = 'Support'

    ...

    --Pra:-):-)--------------------------------------------------------------------------------

    April 18, 2013 at 11:43 am

    #1607927

Viewing 15 posts - 1 through 15 (of 86 total)