Forum Replies Created

Viewing 15 posts - 22,891 through 22,905 (of 39,824 total)

  • 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...

  • RE: text field in insert trigger

    I don't believe there is a workaround. The CREATE TRIGGER documentation says not text/ntext types.

    What are you trying to accomplish?

  • RE: Sql Server installation

    SQL server only runs on Windows. You cannot install it on any other OS. It can be Windows Mobile/CE to Data Center server and everything in between, but it will...

  • RE: break down into hours, minutes and seconds

    You'll need to use a CASE with LEN to determine what the places mean. Then the SUBSTRING to split out the items.

    The issue is that if you have

    1101

    is that 1:10:01...

  • RE: text field in insert trigger

    Move to varchar(max) as a data type.

  • RE: Take a Seat

    That's a great idea for recruitment at growing companies, but not so good at larger ones. However larger ones could make a deal with a used furniture company to swap...

  • RE: Virtualization Hints

    One thing I'd mention that came up with a friend yesterday. Be sure that your help desk, sys admins, etc. know where the VM exists on a physical host. Someone...

  • RE: SIMPLE Full Backup Fails

    No it definitely sounds strange.

    If you can make the test, what if you delete your 7GB backup and then run the job? Does it work?

    I'm reaching here, testing different things.

Viewing 15 posts - 22,891 through 22,905 (of 39,824 total)