Forum Replies Created

Viewing 15 posts - 20,881 through 20,895 (of 49,552 total)

  • RE: Question about GETDATE()

    SQL Kiwi (1/20/2012)

    GilaMonster (1/20/2012)

    Yes, they will. GetDate, like Rand, gets one value for a statement (if called once)

    Not necessarily true for RAND, if it is seeded with a non-deterministic 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

    January 20, 2012 at 3:49 am

    #1436356

  • RE: Cant release unused space???

    hewitg (1/20/2012)

    used it and it doesnt do anything!!!!!

    Try shrinking in small chunks, couple GB at a time. Also check while Shrink's running if it's waiting for anything (like a latch...

    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 20, 2012 at 2:44 am

    #1436330

  • RE: Cant release unused space???

    Robert Murphy UK1 (1/20/2012)

    DBCC SHRINKFILE (N'YourDbName' , 5000)

    GO

    DBCC SHRINKFILE (N'YourDbName' , 0, TRUNCATEONLY)

    Why would you run shrinkFile with truncateony (release unused...

    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 20, 2012 at 2:42 am

    #1436329

  • RE: Cant release unused space???

    Ok, so DBCC ShrinkFile (<file name of data file>,<target size>)

    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 20, 2012 at 2:16 am

    #1436319

  • RE: Need some help with query WHERE clause....

    TimeToShine (1/19/2012)

    I will store the data in 2 fields in the Atts. table; AttName & AttValue. AttName would contain data similar to: |Color||Style||Size|. AttValue would store the associated...

    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 20, 2012 at 2:03 am

    #1436316

  • RE: Cant release unused space???

    How much free space is there in the database?

    How long did you leave things after the drop? Drop table is not an instantaneous removal of data.

    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 20, 2012 at 1:58 am

    #1436313

  • RE: Question about GETDATE()

    Yes, they will. GetDate, like Rand (without a seed), gets one value for a statement (if called once)

    That said, if milliseconds are significant, datetime is a poor data type 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 20, 2012 at 1:52 am

    #1436310

  • RE: Cant release unused space???

    Have you rebuild the clustered index? If not, that space is likely to be spread through the table, not free pages that can be released.

    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 20, 2012 at 1:51 am

    #1436309

  • RE: Stairway to SQL Server Indexes: Step 10, Index Internal Structure

    Just one correction:

    Non-leaf level entries contain only index key columns and the pointer to a lower level page. Included columns only exist in the leaf level entries; they are...

    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 20, 2012 at 1:49 am

    #1436308

  • RE: Creating Index on DATETIME Column based just DATE

    sudhirnune (1/19/2012)

    I have a table which has a column (ISSUE_DATE) which is a date time Data type.

    But for improving the Query Performance i need to Index the Table based on...

    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 20, 2012 at 1:39 am

    #1436307

  • RE: sp_attach_db with ATTACH AS

    Well, firstly you don't use sp_attach_db as it it deprecated. Use CREATE DATABASE <new database name> .... FOR ATTACH

    What do you mean 'attach as'?

    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 20, 2012 at 1:26 am

    #1436306

  • RE: INDEXES

    Grant Fritchey (1/19/2012)

    The size of the index, whether it's unique or not, and, most importantly, the selectivity of the index (how unique is the data within it) are all taken...

    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 19, 2012 at 1:06 pm

    #1436141

  • RE: t-sql,sql server 2000

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1238996-8-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 19, 2012 at 1:04 pm

    #1436140

  • RE: ISOLATION level difference between Client connections and Database

    Close...

    _UB (1/19/2012)

    Transaction Isolation Level is different from Database Isolation Level setting.

    There is no such thing as a database isolation level.

    There are two database settings.

    1) Allow snapshot isolation level. All that...

    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 19, 2012 at 1:02 pm

    #1436139

  • RE: Question about log shipping from SQL 2005 to SQL 2008

    In that case I would very strongly advise against using mis-matched versions. In a disaster you could fail over and find your apps don't work on the newer version, and...

    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 19, 2012 at 12:53 pm

    #1436136

Viewing 15 posts - 20,881 through 20,895 (of 49,552 total)