Forum Replies Created

Viewing 15 posts - 10,156 through 10,170 (of 49,552 total)

  • RE: How to fix - Cannot find object/table in database error when it actually exists ?

    If the table is not in the user's default schema nor is it in dbo, you'd need to qualify the table name with the schema name to access it.

    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

    January 31, 2014 at 12:20 am

    #1684938

  • RE: Tracing user actions

    free_mascot (1/30/2014)

    In addition resource of the server too may be affected i.e. CPU, MEMORY, I/O etc.

    Extended events are pretty light-weight. Trace, providing it's a server-side trace shouldn't be too bad,...

    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

    January 30, 2014 at 11:03 pm

    #1684925

  • RE: getDate(), each database is for different timezones

    Looks like the restrictions against non-deterministic functions has indeed been relaxed.

    CREATE FUNCTION dbo.OffsetDate(@Offset INT)

    RETURNS DATETIME AS

    BEGIN

    RETURN DATEADD(hh,@Offset, GETDATE())

    END

    GO

    SELECT dbo.OffsetDate(3)

    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

    January 30, 2014 at 12:18 pm

    #1684815

  • RE: getDate(), each database is for different timezones

    Firstly don't call it getdate (even if you can), second I think you'll have to pass two parameters, the offset and the datetime you want the offset to apply to.

    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

    January 30, 2014 at 11:34 am

    #1684803

  • RE: Restore succeeded but Data is different?? What? Is this possible?

    Nadrek (1/30/2014)

    I'd suggest taking a hash of the actual backup file before the first copy, and then checking it after each copy - if it's different, then re-copy.

    No need, if...

    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

    January 30, 2014 at 10:55 am

    #1684785

  • RE: Index Rebuild or Reorganize not working on Clustered index

    BriPan (1/30/2014)

    i have other table also they were having more than 1000 rows and having clustered index and page count

    3 or max 7 . and they also having same...

    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

    January 30, 2014 at 10:43 am

    #1684781

  • RE: Restore succeeded but Data is different?? What? Is this possible?

    DominantDBA (1/30/2014)

    So the network copy from B to C was corrupted

    Not necessarily. I gave two possibilities.

    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

    January 30, 2014 at 10:42 am

    #1684779

  • RE: create a table with two primary keys.

    Ryan George (1/30/2014)

    as per the requirement, it is asked to create a table with two primary keys. how can we implement the same

    At the risk of sounding like an echo...

    A...

    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

    January 30, 2014 at 10:40 am

    #1684777

  • RE: Tracing user actions

    Extended events or SQL Trace can both do that. Be aware you're going to have a HUGE amount of data to deal with, store and process.

    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

    January 30, 2014 at 7:09 am

    #1684652

  • RE: create a table with two primary keys.

    A table cannot have two primary keys. Sure the requirement isn't for a single primary key consisting of two columns?

    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

    January 30, 2014 at 7:08 am

    #1684649

  • RE: Encryption

    DuncEduardo (1/30/2014)

    With regards to encrypting in application do you mean that a similar methodology to that in SQL Server could be employed, or would "bespoke" code have to be written...

    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

    January 30, 2014 at 6:07 am

    #1684618

  • RE: Clustered Index needed for Time lookup table?

    polkadot (1/30/2014)

    are you suggesting that instead of Unique Index I make the column a Primary Key?

    If the table doesn't already have a primary key, yes.

    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

    January 30, 2014 at 6:06 am

    #1684617

  • RE: Encryption

    Encrypt in the application, not the database. It also prevents any sysadmin from just decrypting it, which they can do if you use keys protected by database permissions. Of course,...

    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

    January 30, 2014 at 5:41 am

    #1684611

  • RE: Encryption - chronology

    Please don't cross post. It just fragments replies and wastes people's time as they answer already answered questions.

    No replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1536266-359-1.aspx

    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

    January 30, 2014 at 5:34 am

    #1684606

  • RE: Encryption

    DuncEduardo (1/30/2014)

    Will the credit card number be transmitted in clear text to the database at which point the application will encrypt it, or is the data encrypted within the application...

    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

    January 30, 2014 at 5:33 am

    #1684605

Viewing 15 posts - 10,156 through 10,170 (of 49,552 total)