Forum Replies Created

Viewing 15 posts - 41,926 through 41,940 (of 49,552 total)

  • RE: syscolumns

    Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

    The Information schema exists in 2000 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 6, 2009 at 1:42 pm

    #922142

  • RE: How to link view and table together

    A view doesn't store data. It's just a saved SQL statement. So, when you change the data in the table, it will immediately reflect in the view, just as 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 6, 2009 at 1:41 pm

    #922140

  • RE: "Items is not a recognized table hints"

    GSquared (1/6/2009)

    Edit: Nope. I'm wrong. Just set a test database to compatibility 80 and tried to cross apply a function, and got exactly "... is not a recognized...

    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 6, 2009 at 1:38 pm

    #922135

  • RE: Getting Deadlocks Continuously?????????

    madhu.arda (1/6/2009)

    we need to add this trace file in sartup parameters in configuration manager or there is another way to do it?

    DBCC TRACEON(1222,-1)

    and I did not add the trace 1204...

    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 6, 2009 at 1:37 pm

    #922134

  • RE: USING SUBQUERY IN INSERT STATEMENT

    Franco_1 (1/6/2009)

    Is it because @ProjectName,@Description,@RequestedBy is not part of the Department table?

    In SQL Server Management Studio query pane, I had to actually pass in string values for it to work,...

    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 6, 2009 at 1:25 pm

    #922123

  • RE: Getting Deadlocks Continuously?????????

    Since it's SQL 2005, can you get the deadlock graph using traceflag 1222 instead of 1204 please? The information's a lot more detailed and far easier to read.

    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 6, 2009 at 1:01 pm

    #922094

  • RE: Sqlserver Joins

    nitinpatel31 (1/6/2009)

    By the way sql server uses nested loops and index

    nested loops join.

    Not true. Nested loops, merge and hash are the three algorithms that SQL uses to do joins. Nested...

    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 6, 2009 at 12:57 pm

    #922089

  • RE: Sqlserver Joins

    For a summary: http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/

    For the really technical details, follow the links on that page.

    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 6, 2009 at 12:55 pm

    #922084

  • RE: Extra page break bug fixed in SSRS 2008

    Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic630887-1063-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 6, 2009 at 12:54 pm

    #922082

  • RE: Are the posted questions getting worse?

    RBarryYoung (1/6/2009)

    GilaMonster (1/6/2009)

    Grant Fritchey (1/6/2009)

    I must be old, D&D used lots (and lots and lots) of six-sided dice. Now, Traveller, there were the decimal dice at work.

    Which edition was 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 6, 2009 at 12:51 pm

    #922077

  • RE: sql server performance issue

    GSquared (1/6/2009)

    If the UDFs are the ones that you define a table variable for the output (called "multi-value UDFs"), then that's probably the biggest source of the performance problem. ...

    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 6, 2009 at 12:49 pm

    #922075

  • RE: data file corrupted and became 0 size on server restart

    James Zhang (1/6/2009)

    do you think the problem is on the OS side or on the storage side?

    < Shrug > Out of my area of expertise. Absolutely no idea.

    Anything interesting...

    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 6, 2009 at 12:47 pm

    #922073

  • RE: User Defined Function: order by won't work

    kathyoshea (1/6/2009)

    Create a new multi-statement table-valued function.

    Select the data and use the order by in the loading of the table that is returned.

    This works in all the testing I've done....

    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 6, 2009 at 11:47 am

    #922015

  • RE: data file corrupted and became 0 size on server restart

    IO sub-system glitch? It's pretty much the only thing that comes to mind.

    I assume there's all sorts of errors in the error log about 'cannot open file', etc.

    Got 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 6, 2009 at 11:32 am

    #921999

  • RE: data file corrupted and became 0 size on server restart

    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/Topic630817-266-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 6, 2009 at 11:31 am

    #921998

Viewing 15 posts - 41,926 through 41,940 (of 49,552 total)