Forum Replies Created

Viewing 15 posts - 586 through 600 (of 1,187 total)

  • RE: Hostname is a dot in sp_who2

    catchmekc (7/9/2013)


    They are related to system SPIDs. See the SPID column, all are less or equal to 50

    Thanks. Some of them are system SPIDs, but I see several where the...

  • RE: Hostname is a dot in sp_who2

    Thanks, everyone, for the prompt replies.

    Just so I understand correctly, does a dot mean that the connection in question is being made from the current SQL Server itself? How would...

  • RE: LEFT JOIN

    I just tried this question and picked B (correct answer was D, it says).

    Even though I see the point of the issues with the question wording, I want to praise...

  • RE: A New Look

    david.wright-948385 (7/2/2013)


    gary.morgan 31549 (7/2/2013)


    The featured contents should be put back at the top of the letter so that a summary is immediately viewable.

    +1

    Also, the width of the original would scale...

  • RE: Fun with real and float

    Yes, thanks to Hugo for the detailed explanation. I agree with those who say that the Microsoft documentation could use Hugo's addition!

    I think the following queries show the switchover point...

  • RE: PowerShell snap-ins

    opc.three (6/28/2013)


    webrunner (6/28/2013)


    Maybe I just need to manually load whatever snap-ins I want to use or test out?

    Yep. For oft used snap-ins you can edit your Profile so they are...

  • RE: PowerShell snap-ins

    Thanks for your response!

    When I run this command in a new session:

    Get-Command -commandtype cmdlet | select PSSnapin -Unique

    I get this:

    PSSnapIn

    --------

    Microsoft.PowerShell.Core

    PS C:\Windows\system32>

    Maybe I just need to manually load whatever snap-ins I...

  • RE: How does SQL pronounce SQL?

    Thanks - really cool question.

    - webrunner

  • RE: Trust

    marcia.j.wilson (6/20/2013)


    webrunner (6/20/2013)


    ... I guess it comes down to whether computerization is truly a unique industry/business entity or can be put in line with other industries such as mechanical...

  • RE: Trust

    As technology industries move further and further into areas where lives can be lost (as in pharmaceuticals and construction), I think we will see that things have to mature or...

  • RE: SQL Server 2005 - Backup, Integrity Check and Index Optimization

    Ola Hallengren (6/11/2013)


    I calculate the cleanup time before I start backing up the database. The reason for that is to protect against a scenario where you delete a backup that...

  • RE: SQL Server 2005 - Backup, Integrity Check and Index Optimization

    This is a fantastic set of scripts. Thanks to Ola Hallengren for them!

    I do have one question, though. I have tried setting the CleanupTime for the backup script to 24...

  • RE: Data Type

    Great question. I was close but got it wrong. Still, a great teaching question.

  • RE: Android Development

    Eric M Russell (2/18/2013)


    There are some Android apps out there that claim connectivity and querying functionality for Oracle, MySQL, or SQL Server.

    http://www.appszoom.com/android_applications/business/mysql-sql-client_bbwxj.html

    There is a Microsoft JDBC Driver for SQL...

  • RE: The Security of You

    Fascinating topic. Thanks.

    It seems to me the ultimate biometric data would be some kind of very rapid DNA fingerprinting. But I agree that the copying issue is paramount. No matter...

Viewing 15 posts - 586 through 600 (of 1,187 total)