Forum Replies Created

Viewing 15 posts - 5,011 through 5,025 (of 7,164 total)

  • RE: EXECUTE sproc permissions

    John Mitchell-245523 (11/30/2011)


    You don't need to assign permissions on the underlying tables and views. This is one great advantage of developing your application so that all access is through...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: User access to Activity Monitor

    Shabba (12/8/2011)


    Thanks Dev.

    I was looking into this when you replied. Any idea what permissions I would need to grant to allow a login to see other user processes in...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to store lots of data (1024 columns) for a particular reading

    I went ahead and created a couple different CLR types. This being my first try in this area I was not sure whether calculating everything from the outset and storing/serializing...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Enable autogrowth for databases in SQL Server

    Jeff Moden (11/29/2011)


    opc.three (11/29/2011)


    Taking it a step further we can easily employ PowerShell and WMI to discover all SQL Server instances on our network without relying on the SQL Browser....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Enable autogrowth for databases in SQL Server

    I think I have given you the tools you need...and there is always Google. Feel free to post what you have if you get stuck...or start a new thread.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Enable autogrowth for databases in SQL Server

    I agree with all the points Steve made. sp_MSforeachDB was a nice breadcrumb left for us by Microsoft and is very useful when managing a single instance but when trying...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to store lots of data (1024 columns) for a particular reading

    loki1049 (11/25/2011)


    I assume this is a way to write the equivalence of .NET language in a SQL contruct?

    That's pretty much the gist of it...SQLCLR allows us to implement various SQL...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to store lots of data (1024 columns) for a particular reading

    Jeff Moden (11/22/2011)


    opc.three (11/22/2011)


    Max of a comma-delimited string can be found quite easily in .NET using "Split" to create an Array from a comma-delimited list

    Precisely my point. And it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to store lots of data (1024 columns) for a particular reading

    Jeff Moden (11/21/2011)


    opc.three (11/20/2011)


    That said, I am not convinced that a small group of "readings tables" that make up 1024 readings columns would be so bad here (group of tables...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to store lots of data (1024 columns) for a particular reading

    Jeff Moden (11/20/2011)


    Just to make a small correction to what opc.three said, both a flat wide (1024+ columns) and a tall skinny table aren't likely to be the way to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to store lots of data (1024 columns) for a particular reading

    Dev (11/20/2011)


    I don’t understand how it will consume triple the space? Even if it does space is cheap but that’s not the concern (time being).

    If you do not...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How to store lots of data (1024 columns) for a particular reading

    I would avoid storing a comma-separated list if at all possible. If your boss is married to the idea the least you could do is steer them towards coalescing the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Multiple ambiguous overloads found for "Script" and the argument count: "1"

    My script works when I run this through cmd prompt then type POWERSHELL to launch PS.

    When you execute through a cmd shell are you on the same server as the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Effect of .net on sql server

    This question has come up before and IIRC .NET FW is not listed as a requirement for the product itself. It is required for the installer, however once installed it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: New application / database questionairre

    Some items imposed on us by third-party apps that have caused trouble:

    1. Is your application able to connect to a named instance?

    2. What are your network protocol requirements? TCP/IP, Named...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 5,011 through 5,025 (of 7,164 total)