Forum Replies Created

Viewing 15 posts - 49,171 through 49,185 (of 49,552 total)

  • RE: select date

    I just want to give a great big 'shout-out' to Gila for the information about avoiding the use of functions in where clauses.

    My pleasure.

    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

    March 28, 2006 at 10:58 pm

    #629361

  • RE: Locks Rows in Table when use View

    No need to do that, read comitted is the default isolation level in SQL

    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

    March 28, 2006 at 10:58 pm

    #629362

  • RE: drop index constraint

    IF exists (select * from dbo.sysobjects

    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

    March 28, 2006 at 10:50 pm

    #629360

  • RE: sql date question

    Just note that in sql dates always have assocated times. Getdate() returns date and time, not just date. There's no built in function that only returns date.

    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

    March 28, 2006 at 3:47 am

    #629110

  • RE: select date

    I believe using DateDiff() is going to offer the best performance and clearest results.

    Clearest results possibly, but very definately not best performance. Be very careful when applying any function...

    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

    March 28, 2006 at 2:55 am

    #629100

  • RE: Locks Rows in Table when use View

    Yes, locks will be taken on the base table. You can see this my running the stored proc sp_lock or looking at the system table syslocks (located in the master database)....

    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

    March 28, 2006 at 12:44 am

    #629087

  • RE: MS SQL Server 2000 SQL3 Statment?

    That's the way to create tables in SQL 2000 and SQL 2005. MS

    SQL Server doesn't implement that portion of the SQL 1999 standard. Offhand, I can't think of 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

    March 27, 2006 at 2:25 am

    #628831

  • RE: Can you delete from multiple tables with a Delete Stmt?

    If it's a parent table and several child tables you can create foreign keys (or modify existing ones) and set them to cascade delete. Then you delete from the parent and 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

    March 24, 2006 at 3:51 am

    #628541

  • RE: Automatic summing of fields / integrity

    What I would recomend, if you're using stored procdures (and if you're not, why not?) is to do the summary calc in the sp before or after inserting the detail...

    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

    March 22, 2006 at 10:42 pm

    #628274

  • RE: Question of the Day for 22 Mar 2006

    The question does state the version. Look at the category

    Category : SQL Server 2005 - TSQL

    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

    March 22, 2006 at 10:42 pm

    #628275

  • RE: cursor problem

    The pseudocode looks OK at a quick glance. Can you post the actual code? Would be easier to debug.

    Why global temp tables?

    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

    March 22, 2006 at 3:52 am

    #628038

  • RE: Automatic summing of fields / integrity

    Triggers would work, but they'd be very resource intensive.

    Why do you need to store summary information when it can be recalculated easily? If it's for a report than it can...

    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

    March 22, 2006 at 3:44 am

    #628036

  • RE: Question of the Day for 22 Mar 2006

    Category : SQL Server 2005 - TSQL

    Question - Worth 2 Point(s):

    What will be the result of the last SELECT statement if you execute the T-SQL script below as a 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

    March 22, 2006 at 2:09 am

    #628028

  • RE: Delete Statement in SQl 2000

    If the foreign key between the tables is set to cascade delete them you can delete from the parent and SQL will cascade the deletes down to the child 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

    March 15, 2006 at 4:48 am

    #626714

  • RE: Who Needs a 64-bit Desktop?

    22GB? I have a production system that has 48GB of memory in it, 44GB assigned to SQL Server. Runs beautifully, just takes a week to shutdown.

    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

    March 13, 2006 at 3:42 am

    #626174

Viewing 15 posts - 49,171 through 49,185 (of 49,552 total)