Forum Replies Created

Viewing 15 posts - 22,846 through 22,860 (of 39,824 total)

  • RE: DBCCRebuild Indexes v DBCC FreeProccache

    Do all procedures get marker or only those from the dependency tree in SQL Server get marked? I assume this is at the end of each index that is rebuilt?

  • RE: SQL Permissions

    The service account needs permissions to create the database, not your log in account.

  • RE: Learn A Bit More

    you'll have to ask Red Gate, but Eugene isn't too far away. Might be a nice trip. Spent some time there in 98 and enjoyed it.

  • RE: Mapping Users to DB

    you can't drop them all at once. You can loop across the result set (while or cursor) and issue a DROP USER for each one.

    The same thing occurs for the...

  • RE: DBCCRebuild Indexes v DBCC FreeProccache

    I don't believe so.

  • RE: Reserved space

    You have 6 filegroups, not 1. So the way it works is that your files in that filegroup take the data for the tables stored there. If they run out...

  • RE: Reserved space

    you must have an object on that particular filegroup that is growing. As mentioned, a table doesn't grow across filegroups.

  • RE: Be a Craftsman

    Interesting you mention cooking. 37 signals talks about inspirations from chef's and recently Andy Warren started cooking a bit and said it gave him an interesting perspective. Perhaps that should...

  • RE: Are the posted questions getting worse?

    Lynn,

    Best wishes, and I hope it goes well. I'm sure she will appreciate the hardships later.

  • RE: Reserved space

    Ok, double check what you're saying.

    It is one physical file split into many physical files? either you have one MDF, which is one file, one file group, or you have...

  • RE: Learn A Bit More

    Jeff, there are a few MI people that do SQL. you ought to get the user group to run a SQL Saturday. The event in Baton Rouge ran smoothly, minimal...

  • RE: Learn A Bit More

    Sarah B (7/31/2009)


    I am from central Wisconsin, and the closest SQL Saturday event is in Iowa City. They will not pay for the travel, but I am considering paying...

  • RE: Learn A Bit More

    jpowers (7/31/2009)


    The main reason I don't go is that many are not local. If it is within a 60 mile radius of my home, then I can go. I don't...

  • RE: Learn A Bit More

    Terri (7/31/2009)


    I will be driving from New Orleans to Baton Rouge tomorrow morning (1.5 hour drive) to attend SQL Server Saturday. I'm happy to have the opportunity for the...

  • RE: Reserved space

    It uses the reserved space automatically.

    Let me ask a couple questions. Are you giving us total space or data space? Some people confuse the log with the data, and see...

Viewing 15 posts - 22,846 through 22,860 (of 39,824 total)