Forum Replies Created

Viewing 15 posts - 37,876 through 37,890 (of 49,552 total)

  • RE: Release FileStream space

    Gift Peddie (7/5/2009)

    I have seen it did not read I am still saying no garbage collection is going on because if only backup release deletes that is almost like shadow...

    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

    July 5, 2009 at 5:52 am

    #1020049

  • RE: Deadlock when using Select With READPAST

    That shouldn't be enough to deadlock.

    Can you switch traceflag 1222 on, instead of 1204. Post the result of that graph here.

    DBCC TRACEON(1222,-1)

    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

    July 5, 2009 at 5:29 am

    #1020048

  • RE: Release FileStream space

    Gift Peddie (7/4/2009)

    If SQL Server garbage collector is the same as .NET then OS restart should have cleaned it up so then it is retained if there is no log...

    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

    July 5, 2009 at 5:12 am

    #1020046

  • RE: Release FileStream space

    The files will be retained until SQL's garbage collector runs. The files are eligible for garbage collection once they are no longer needed for database recovery. If you're in simple...

    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

    July 4, 2009 at 2:04 pm

    #1019993

  • RE: Error in copying table structure

    Are both servers running the same version of SQL?

    What version are they running? This looks like a SQL 2000 script.

    The create table runs without error on my SQL 2008 server....

    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

    July 4, 2009 at 2:00 pm

    #1019992

  • RE: Limit to the number of records in SQL Developer?

    There is no connection limitation on SQL developer edition. It is exactly like Enterprise edition in every way, except it is not licensed for production usage. The licensing on developer...

    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

    July 4, 2009 at 11:41 am

    #1019974

  • RE: "derived table" invalid object name

    Which information in particular to you want a reference to confirm against?

    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

    July 4, 2009 at 11:38 am

    #1019972

  • RE: Duplicate data

    Please run this and post the results

    select t.name, i.type_desc, i.name, ds.name

    from sys.tables t

    inner join sys.indexes i on t.object_id = i.object_id

    inner join sys.data_spaces ds on i.data_space_id = ds.data_space_id

    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

    July 4, 2009 at 11:35 am

    #1019971

  • RE: "derived table" invalid object name

    waleed_m_M (7/4/2009)

    but temp tables have problems in performance since they make locking for the server when it's under construction .

    That was a problem on SQL 2000, when there was...

    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

    July 4, 2009 at 11:30 am

    #1019969

  • RE: Duplicate data

    Do you have nonclustered indexes on that table? If so, they may be in different filegroups to the base table

    Add i.name and i.indid to the query.

    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

    July 4, 2009 at 2:03 am

    #1019920

  • RE: Intellisense for sql 2005 is needed

    Asked and mostly answered: http://www.sqlservercentral.com/Forums/Topic745243-147-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

    July 4, 2009 at 1:59 am

    #1019918

  • RE: "derived table" invalid object name

    waleed_m_M (7/4/2009)

    select * from (SELECT column_name,column_default

    FROM INFORMATION_SCHEMA.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

    July 4, 2009 at 1:58 am

    #1019917

  • RE: I am not abel to check to give unrestricted growth in my DB,

    If you're seeing a max size for the log of 2 TB, that's the maximum possible size for a log file within SQL. So restricted to 2TB is the 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

    July 4, 2009 at 1:54 am

    #1019915

  • RE: Update Statement

    That is going to update every single row in the sqldate_tbl table. Is that your intention?

    The only reason that could be not updating any rows is if there are no...

    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

    July 3, 2009 at 2:04 pm

    #1019860

  • RE: Are the posted questions getting worse?

    RBarryYoung (7/3/2009)

    I remember back in Q1 I had several weeks where I was really racking up the posts. But I eventually started to notice that it was having...

    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

    July 3, 2009 at 1:31 pm

    #1019853

Viewing 15 posts - 37,876 through 37,890 (of 49,552 total)