Forum Replies Created

Viewing 15 posts - 22,996 through 23,010 (of 39,936 total)

  • RE: Most efficient way to insert 20 records via a sproc?

    I assume you mean other than calling a sproc 5, 10, or 20 times? I'd go with a comma list then, but test it against just 20 calls.

  • RE: Pull Out Of Office data from exchange server

    I've seen products before that would connect Exchange to SQL, but I'm not sure about OoO info. That sounds more like a setting for a user, and you'd need an...

  • RE: port number of differnent services

    Instances use a range to dynamically select a port. You can get the port from the error log of the instance when it starts up, or you can set...

  • RE: SQL Dependency problem

    Do you mean those objects created out of order? Or are you trying to find objects that are dependent on something that hasn't been created?

    This isn't easy to figure out,...

  • RE: Indexing Question...

    However you wouldn't build indexes for every query. I would think you would start with the columns in PKs and FKs first, if you haven't explicitly declared those or set...

  • RE: Take a Seat

    Richard (7/29/2009)


    I could not find a chair that really expressed me so I built one.

    See it here

    It is from a 2007 Corvette. The recline still works and it is...

  • RE: excessive DB processes?

    That's more along the lines of what I'd expect.

    The memory usage in SQL Server can be a little strange. I know there are certain things that might need contiguous references,...

  • RE: Multiple Instances on One Server

    Hadn't considered the ports to move between machines, but that's a good idea. I'd go above 50000 and just pick a port for each app. Makes sense.

  • RE: The Reading Poll

    I'm not sure the sony reader allows annotations. The iPhone apps don't, though you can bookmark a page.

    The PC reader (BN) does allow notes.

  • RE: fillfactor

    This also impacts performance. Lower fillfactor, more reads to get the data.

    You have to find a good balance for heavily accessed tables that accounts for reads and writes.

  • RE: Multiple Instances on One Server

    Minimal risk that I see with the browser. If someone is going to scan, they'll find the ports. I've set specific ports so that I could be sure that port...

  • RE: The Reading Poll

    Joe, you can highlight and annotate on the Kindle. Not quite the same thing, but just so you know.

    I think it's a great device and platform, but there are issues...

  • RE: excessive DB processes?

    Typically that error is an interruption in the communciation between your server and the client. The number of processes shouldn't be an issue, though each one takes resources. It's possible...

  • RE: Sargeble?

    It's actually SARG able, meaning search arguments can be used by the optimizer to better handle your query.

  • RE: Does Maturity Make a DBA?

    Not to create issues, but I have had friends work for the Catholic or Jewish hospital companies, or for organizations like CBN. They pray before meetings, nothing illegal about it.

    GSquared...

Viewing 15 posts - 22,996 through 23,010 (of 39,936 total)