Forum Replies Created

Viewing 15 posts - 26,671 through 26,685 (of 49,552 total)

  • RE: Declare table variable

    Grant Fritchey (4/17/2011)

    While you can then use EXEC @MySQL to run it, you'll be better off learning about sp_executesql so that you can build parameters into the string and execute...

    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

    April 17, 2011 at 7:09 am

    #1312509

  • RE: MAXDOP-Help required

    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/Topic1094536-391-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

    April 16, 2011 at 4:20 pm

    #1312471

  • RE: SQL Database Artistructure

    "Archistructure" is not only a non-existant technical term, it's not even a word in the English language.

    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

    April 16, 2011 at 4:19 pm

    #1312470

  • RE: MAXDOP- Help required

    It's the maximum number of processor cores that a query operator is allowed to parallel across.

    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

    April 16, 2011 at 4:17 pm

    #1312469

  • RE: Maintenance plan for large databases, how many times?

    Shrink is easy. Never.

    Rebuild or reorganise (makes no sense to do both) depends on how fast they fragment. I recommend you discard the maint plan and get one 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

    April 16, 2011 at 4:15 pm

    #1312468

  • RE: Database slow sql server 2005

    Animal Magic (4/15/2011)

    first thing you need to do is a bit of information digging. find out what part(s) of the application(s) are slow and if the users who 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

    April 16, 2011 at 7:21 am

    #1312436

  • RE: How to find a temporary table in tempdb?

    Yup, that's pretty much what I was thinking about.

    Just one comment, if the session_id>50 is supposed to filter out system processes, remove it as it won't necessarily do what you...

    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

    April 16, 2011 at 7:16 am

    #1312435

  • RE: Database level trigger on delete,update operation

    DML triggers (delete, insert, update) are applied to individual tables. Database and server-level triggers are only DDL (schema and definition changes)

    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

    April 16, 2011 at 4:43 am

    #1312429

  • RE: Database Recovery - DB Not Detached - SQL Server 2000

    Great. Now go put a backup strategy in place.

    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

    April 16, 2011 at 12:40 am

    #1312415

  • RE: Can't find index even though it exists

    Is it disabled? Hypothetical? (check the other columns in sys.indexes)

    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

    April 16, 2011 at 12:40 am

    #1312414

  • RE: How to find a temporary table in tempdb?

    SQL Guy 1 (4/15/2011)

    First, they do affect the performance. From time to time users get a messages that SQL Server cannot allocate space in tempdb.

    That's not a 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

    April 16, 2011 at 12:39 am

    #1312413

  • RE: How to find a temporary table in tempdb?

    SQL Guy 1 (4/15/2011)

    That's because I am tasked to write a script to find largest objects in tempdb.

    Just having large objects in TempDB shouldn't have any effect 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

    April 15, 2011 at 2:05 pm

    #1312340

  • RE: Can't find index even though it exists

    What does this return?

    SELECT index_id, name FROM sys.indexes WHERE object_id = OBJECT_ID('mms_cs_link')

    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

    April 15, 2011 at 2:04 pm

    #1312339

  • RE: Are the posted questions getting worse?

    Can someone able to at least spell Powershell help out here: http://www.sqlservercentral.com/Forums/Topic1094283-1351-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

    April 15, 2011 at 12:29 pm

    #1312300

  • RE: using sys.dm_exec_sessions in application

    No need to use the DMV...

    SELECT APP_NAME () AS ApplicationName

    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

    April 15, 2011 at 12:22 pm

    #1312297

Viewing 15 posts - 26,671 through 26,685 (of 49,552 total)