Forum Replies Created

Viewing 15 posts - 47,971 through 47,985 (of 49,552 total)

  • RE: Performance Problem when using Caching

    Can you double check that the notification services in the two DBs are set up the same? Same events, same schedules, same subscribers, etc.

    I'm not that familiar with notification sevices,...

    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

    December 20, 2007 at 11:42 pm

    #761982

  • RE: Error in a sql query :The column prefix 'XX does not match with a table name or alias name used in the query

    I have a feeling that the error's coming from the sub query. Try changing to the following and see if your problem goes away.

    SELECT

    L.LOC_ID,

    L.Location,

    L.Phone,

    L.DealerCode,

    (FirstName +...

    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

    December 20, 2007 at 11:33 pm

    #761980

  • RE: Deadlock - SQL Server 2000

    Enable traceflag 1204. That will write the deadlock graphs into the SQL error log. With the info in the graph, you should be able to locate the cause of 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

    December 20, 2007 at 11:28 pm

    #761979

  • RE: index space is a negative number

    Run sp_updateusage

    Edit: Correction, that should be DBCC UPDATEUSAGE. Sorry

    DBCC UPDATEUSAGE ('DB name','Table name');

    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

    December 20, 2007 at 12:57 pm

    #761888

  • RE: Serious Issue

    Is the DB set to autoclose?

    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

    December 20, 2007 at 12:42 pm

    #761884

  • RE: Each GROUP BY expression must contain at least one column that is not an outer reference.

    Adam Haines (12/20/2007)

    You cant put a function in a group by unless you set a column value = to it.

    example:

    SELECT mer_from_dttm fd,

    column2 = DBO.FreqFortnightlyFunction('24-MAY-2006 2:40:00',...

    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

    December 20, 2007 at 11:16 am

    #761860

  • RE: Like Operator.

    I'll try it out in 2005, see if the results are different.

    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

    December 20, 2007 at 10:56 am

    #761852

  • RE: Database Column Tuning

    Lowry Kozlowski (12/20/2007)

    With our databases, I have 30+ to check with many tables each with sometimes 100+ columns in the table. The script I wrote shows the column length, 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

    December 20, 2007 at 10:20 am

    #761844

  • RE: Serious Issue

    Is the DB set to autoclose? Is it offline?

    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

    December 20, 2007 at 10:04 am

    #761835

  • RE: Database Column Tuning

    The script as written will find you the longest column name per table. Somehow, I don't think that's what you wanted.

    If you want to find the length of the 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

    December 20, 2007 at 9:53 am

    #761827

  • RE: Database Column Tuning

    Please don't multi-post.

    Continue thread here

    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

    December 20, 2007 at 9:50 am

    #761825

  • RE: Help! I have an interview for a DBA job tomorrow !

    Whatever you do, don't lie to them. If you get asked a question on an area you're not familiar with, tell them that you're not that familiar with it. If...

    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

    December 20, 2007 at 9:46 am

    #761821

  • RE: passing GUID to a stored procedure

    Good to know. Thanks for that.

    I tested with brackets or with quotes, not with both.

    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

    December 20, 2007 at 9:45 am

    #761819

  • RE: Performance Problem when using Caching

    Robert Brown (12/20/2007)

    We have two identical copies of the database on the same server (confirmed with SQL Compare) and are using SQL Server Query Notifications to cache data in 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

    December 20, 2007 at 9:37 am

    #761814

  • RE: Query for specific records each new day

    SELECT Data_ID, DateTime, Batt_Vltg

    FROM

    tableName

    WHERE

    DateTime = DATEADD(hh,4,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0))

    Doing conversions to Varchar to trim the time off a date is inefficient and CPU intensive.

    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

    December 20, 2007 at 9:37 am

    #761812

Viewing 15 posts - 47,971 through 47,985 (of 49,552 total)