Forum Replies Created

Viewing 15 posts - 21,916 through 21,930 (of 49,552 total)

  • RE: How to password protect your database on other person's machine and safeguard sql database from windows login

    crazy4sql (12/5/2011)

    To protect your database, SQL Server gives you the option by giving permission at login level.

    Dont give access to any login with whom you don't want to share the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2011 at 4:26 am

    #1416567

  • RE: Apart from DBcc commands, what can flush the cache....?

    ChrisTaylor (12/5/2011)

    but how long does the data stay unused until its "aged out of cache"?

    Depends on how often they're used and if there's 'memory pressure' (which there probably would be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2011 at 4:25 am

    #1416566

  • RE: Apart from DBcc commands, what can flush the cache....?

    Probably what happened is that the reindex pulled lots and lots of data into the cache (as it will) and those pages weren't used again, so they got aged out...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2011 at 4:11 am

    #1416558

  • RE: 70-453 Re-Test

    It'll be different questions.

    Each test gets a selection of questions from a large pool. You might get one or 2 the same, but that'll be about the most.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2011 at 4:09 am

    #1416555

  • RE: How to password protect your database on other person's machine and safeguard sql database from windows login

    Divine Flame (12/4/2011)

    You can create the procedures & views with encryption to encrypt them. Also, as you are using SQL Server 2005 you can encrypt the table's data as well....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2011 at 2:57 am

    #1416526

  • RE: Update statement for when a specific field changes

    A bit of a neater way.

    ALTER TRIGGER [dbo].[UDEF_COSTPRICE_UPDATE_DATE_KWD] ON stk_STOCK

    FOR INSERT, UPDATE

    AS

    IF UPDATE(STK_COSTPRICE)

    BEGIN

    ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2011 at 2:52 am

    #1416524

  • RE: SQL 2008 Logshipping, secondary database issue

    MyDoggieJessie (12/4/2011)

    Yes I had copied them all but it would let me restore the latest one as it was created after a new full backup, so I only restores the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2011 at 9:34 am

    #1416418

  • RE: Try catch in a transaction block or transaction in try catch block???

    Jeff Moden (12/4/2011)

    I truly hope than no one makes the mistake of running that code without actually looking at it to see what it does. 😉

    Likewise, but not for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2011 at 9:32 am

    #1416417

  • RE: Performance moved from 10 minutes to 3 hours plus

    Check that you haven't run into this:

    http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2011 at 6:22 am

    #1416396

  • RE: Rollback problem in VBA

    Post the actual code please.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2011 at 3:58 am

    #1416391

  • RE: why can't I shrink this log file?

    Please read through this - Managing Transaction Logs[/url] and this - http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 4, 2011 at 2:50 am

    #1416387

  • RE: negative spid number

    If you have a repeatable crash, I recommend you call MS support.

    Spid -3 is a symptom, not the problem itself.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2011 at 11:43 am

    #1416337

  • RE: Incorrect syntax near 'left'

    slizam (12/3/2011)

    SELECT p.phoneno, mf6_telmn AS TelID, mf6_lcno AS Schedule, mf6_stad1 AS Address, StatusCd

    FROM payphone p LEFT JOIN tbphonestatus s ON mf6_telmn=machno

    WHERE mf6_telmn='02408348'

    That query parses without error. Either one...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2011 at 9:58 am

    #1416321

  • RE: 70-432 - SQL Server

    Why did you remove the question? Just means that others with the same issue can't be helped.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2011 at 9:55 am

    #1416320

  • RE: 70-432 - SQL Server

    Garbage.

    I've written exams in under half an hour before (did 2 in one day before in less than an hour). No problems.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2011 at 7:59 am

    #1416307

Viewing 15 posts - 21,916 through 21,930 (of 49,552 total)