Forum Replies Created

Viewing 15 posts - 39,856 through 39,870 (of 49,552 total)

  • RE: Under what Login do TRIGGERS run?

    UB (4/9/2009)

    We have a Patient table, when users try to INSERT records into it a TRIGGER is fired that INSERTS a copy of the same record in an audit table...

    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

    April 9, 2009 at 10:51 am

    #975232

  • RE: Incorrect data in teh 70-432 study guide.

    koustav_1982 (4/9/2009)

    hi can anyone please forward me the link for free download of these materials

    This site does not condone piracy or copyright violation. If you want to get the books,...

    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

    April 9, 2009 at 10:48 am

    #975230

  • RE: Index - Float or Char ..... Varchar or Char

    If the column will be containing 15-30 character and leading 0's are important, then you should make it a varchar(30) column.

    Varchar has a 2 byte overhead for the storage of...

    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

    April 9, 2009 at 10:42 am

    #975222

  • RE: Index - Float or Char ..... Varchar or Char

    jungnaja (4/7/2009)

    I have to create a new column and its index. This column can be any data type. The length of its value should be about 20-23. ...

    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

    April 9, 2009 at 2:05 am

    #974876

  • RE: Indexes

    geramkumar (4/9/2009)

    * no need create index on tables having little records or columns having duplicates (like country, gender etc).

    Not necessarily. If the columns are filtered on often it may...

    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

    April 9, 2009 at 1:58 am

    #974874

  • RE: Indexes

    suhasini.m (4/8/2009)

    When i am creating a new table how to identify whether i should create a Clustered or Nonclustered Index on this table? In terms of performance which one is...

    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

    April 9, 2009 at 1:47 am

    #974872

  • RE: How to display number of rows in each table in database

    Ells (4/9/2009)

    Thanks,

    but got multiple rows for tables so changed it slightly:

    SELECT table_name,table_rows FROM (

    select so.name as table_name, si.rowcnt as table_rows,ROW_NUMBER() OVER (PARTITION BY SO.NAME ORDER BY si.rowcnt DESC) AS RC

    from...

    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

    April 9, 2009 at 1:42 am

    #974870

  • RE: Verify my current backup strategy n suggest

    Where is that drive backed up to and how long are those backups kept 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

    April 8, 2009 at 2:52 pm

    #974728

  • RE: Reference 'Deleted' table: Dynamic SQL

    rodney.williams (4/8/2009)

    OK, just verified by my manager that the 2000 database was auto installed from previous software that we have. It just has a SQL 2005 interface. Crap! From...

    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

    April 8, 2009 at 2:50 pm

    #974724

  • RE: Falling Over our Assumptions

    Robert Frasca (4/8/2009)

    The point I was trying to make is that the assumption that table variables are better than temp tables because they are stored in RAM is false.

    I...

    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

    April 8, 2009 at 2:49 pm

    #974722

  • RE: Reference 'Deleted' table: Dynamic SQL

    rodney.williams (4/8/2009)

    I got

    Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows...

    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

    April 8, 2009 at 1:48 pm

    #974669

  • RE: Falling Over our Assumptions

    Robert Frasca (4/8/2009)

    Actually, if memory serves, in SQL Server 2005, table variables are stored in TempDB as well. In SQL Server 2000 they were stored in RAM. There's...

    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

    April 8, 2009 at 1:35 pm

    #974654

  • RE: Microsoft SQL Server v 8.00.761

    Lynn Pettis (4/8/2009)

    It may be possible to download and install the SQL Server Express management tools (Gail, am I right here) and use those from a remote PC to make...

    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

    April 8, 2009 at 1:29 pm

    #974647

  • RE: Reference 'Deleted' table: Dynamic SQL

    rodney.williams (4/8/2009)

    Msg 15416, Level 16, State 1, Procedure sp_dbcmptlevel, Line 92

    Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]

    Valid values of database compatibility level are 60, 65, 70, or 80.

    Why might this be?

    Because...

    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

    April 8, 2009 at 1:24 pm

    #974643

  • RE: Falling Over our Assumptions

    Jack Corbett (4/8/2009)

    Just put everyone in db_datareader role. That's good enough security.

    Don't you mean sysadmin?

    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

    April 8, 2009 at 10:21 am

    #974487

Viewing 15 posts - 39,856 through 39,870 (of 49,552 total)