Forum Replies Created

Viewing 10 posts - 91 through 100 (of 100 total)

  • RE: Alternative to sp_spaceused

    abrukovsky.v (10/4/2011)

    Thanks, I'm trying to monitor DB growth at database level not at a file level for all DBs. Does anyone have a script for that?

    Maybe this template will...

    October 4, 2011 at 8:59 am

    #1390185

  • RE: Alternative to sp_spaceused

    george sibbald (10/3/2011)

    use the info from table master.sys.master_files and fileproperty.

    see http://www.sqlservercentral.com/Forums/Topic1182966-149-1.aspx#bm1183474

    Thanks, I'm trying to monitor DB growth at database level not at a file level for all DBs. Does...

    October 3, 2011 at 4:42 pm

    #1389901

  • RE: help with query needed

    Lynn Pettis (10/2/2011)

    Lexa (10/2/2011)

    Lynn Pettis (10/2/2011)

    You aren't passing any parameters to the query based on what you have posted. To get what you want based on your post, try...

    October 2, 2011 at 7:06 pm

    #1389256

  • RE: help with query needed

    Lynn Pettis (10/2/2011)

    You aren't passing any parameters to the query based on what you have posted. To get what you want based on your post, try this:

    DECLARE @table_name nVARCHAR(128)

    DECLARE...

    October 2, 2011 at 2:01 pm

    #1389238

  • RE: SQL Injection and sp_executesql

    GilaMonster (10/1/2011)

    Lexa (10/1/2011)

    codebyo (10/1/2011)

    'sp_executesql' will do that for you.

    codebyo, what exactly do you mean by it will do that for you? If a '; drop table --' command is...

    October 1, 2011 at 1:23 pm

    #1389140

  • RE: SQL Injection and sp_executesql

    codebyo (10/1/2011)

    'sp_executesql' will do that for you.

    codebyo, what exactly do you mean by it will do that for you? If a '; drop table --' command is passed, it...

    October 1, 2011 at 12:10 pm

    #1389126

  • RE: Shrink Database benefit

    Thanks.

    October 1, 2011 at 7:25 am

    #1389103

  • RE: Shrink Database benefit

    Evil Kraig F (9/30/2011)

    Now would be a good time to defrag your stuff too.

    Defrag with the overallocated DB? What do you use for defraging and why now be a...

    September 30, 2011 at 1:16 pm

    #1388994

  • RE: Index Efficency

    GilaMonster, what generally causes lock escalation?

    September 30, 2011 at 12:55 pm

    #1388981

  • RE: Covering Index using Included Columns

    Hi,

    I've a follow up question regarding this discussion. Query below which is called 10K a day causes of long PAGEIOLATCH_SH waits.

    UPDATE table1.list_item

    SET first_name...

    September 23, 2011 at 7:48 am

    #1385738

Viewing 10 posts - 91 through 100 (of 100 total)