Forum Replies Created

Viewing 15 posts - 30,451 through 30,465 (of 49,552 total)

  • RE: Subqueries to Inner Joins

    Why do you want to write them as joins?

    Changing IN to inner join may change the meaning of the query (introduce extra rows)

    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

    September 22, 2010 at 4:14 am

    #1225434

  • RE: Exports in SQL Server

    If you right-click the database and select tasks -> export, the fourth page of the wizard allows you to select any number of tables and map them to a destination.

    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

    September 22, 2010 at 4:11 am

    #1225433

  • RE: Exports in SQL Server

    Ed.Edwards (9/22/2010)

    I don't understand why there are no export/import utilities in SQL Server. Oracle, DB2 (LUW), and MySQL have export and import utilities. SQL Server 6.5 had export/import...

    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

    September 22, 2010 at 3:49 am

    #1225418

  • RE: Some advice for a badly performing query

    Can you post the actual execution plans for both fast and slow queries please?

    From your initial post I assume there are indexes other than the cluster on those tables? 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

    September 22, 2010 at 3:42 am

    #1225415

  • RE: Some advice for a badly performing query

    Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    September 22, 2010 at 2:43 am

    #1225383

  • RE: Are the posted questions getting worse?

    Ran across this earlier, thought it appropriate.

    http://www.despair.com/cluelessness.html

    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

    September 22, 2010 at 2:30 am

    #1225377

  • RE: SQl Query performace

    abcim (9/21/2010)

    Thanks for your kind replies.

    Is you saying some thing like this to widen index,

    CREATE NONCLUSTERED INDEX [IX_NAICSCode] ON [dbo].[SubCategoryNAICSCode]

    (

    [NAICSCode] ASC,[SubCategoryID]

    )

    It won't...

    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

    September 22, 2010 at 12:48 am

    #1225345

  • RE: Are the posted questions getting worse?

    Shawn Melton (9/21/2010)

    I like this one:

    Knock Knock

    Who's There?

    sp underscore

    sp underscore who?

    spid1, spid2, spid3....

    I told that one at a dinner at the PASS Summit a few years ago (my second summit...

    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

    September 21, 2010 at 3:40 pm

    #1225273

  • RE: Error on DROP TABLE line in stored procedure defintion

    The problem is not with the ;, it's the GO

    GO is not a T-SQL command, it's a directive to the client tools that indicates where the batch ends. Hence, 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

    September 21, 2010 at 3:27 pm

    #1225264

  • RE: Help on Backup File Size ..

    A backup is the size of the used space in the database. So a 15 GB backup that has 0% free space will have a 15GB backup. A 15 GB...

    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

    September 21, 2010 at 3:09 pm

    #1225253

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/21/2010)

    A query walks into a bar, sees two tables and says: "May I join you?" 😀

    That's so old the archaeologists are tired of 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

    September 21, 2010 at 2:46 pm

    #1225246

  • RE: Application not able to connect to SQL Server

    swethak13 (9/21/2010)

    Hi Gail, thank you it worked for me after removing the security. I ensured this with the network they sid their is a trusted connection between the servers, 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

    September 21, 2010 at 2:45 pm

    #1225244

  • RE: Datafile increased due to DBCC

    Craig Farrell (9/21/2010)

    From what I've been able to gather so far (I'm still digging when I can find time, will probably take me a few days to get through what...

    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

    September 21, 2010 at 2:24 pm

    #1225226

  • RE: Application not able to connect to SQL Server

    swethak13 (9/21/2010)

    connectionString="data source=IP address,1433;Integrated Security=SSPI;Initial Catalog=DBName;uid=User id ;password=password

    Remove the highlighted portion. Integrated = windows, not SQL authent.

    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

    September 21, 2010 at 2:09 pm

    #1225216

  • RE: Application not able to connect to SQL Server

    GilaMonster (9/21/2010)

    Your application is using a connection string for windows authentication and, as the error says, the domains aren't trusted.

    Either ask the domain admin to set up the required trust...

    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

    September 21, 2010 at 2:01 pm

    #1225208

Viewing 15 posts - 30,451 through 30,465 (of 49,552 total)