Forum Replies Created

Viewing 15 posts - 211 through 225 (of 470 total)

  • RE: The Special Cloud

    Mattrick (8/31/2011)


    I want it to work, but to me it feels like throwing money at a problem without solving any of it.

    For migrating existing applications to the cloud, I agree....

  • RE: Inserted Identity

    forsqlserver (8/28/2011)


    Hi,

    Good question.

    Does below written statements is one query statment:

    INSERT INTO t2

    OUTPUT inserted.id INTO @temp

    SELECT d.id, t1.value FROM t1

    INNER JOIN define d ON t1.name = d.name

    That is just one...

  • RE: Specialists or Generalists: Who are best as Developers?

    I don't think reading any number of pages can give you expertise in programming. Doing is where you get the expertise and since you don't get expertise from doing...

  • RE: Combining SQL Servers

    I can certainly be something that makes sense to do. We have a cluster with a large number of DBs on them to eliminate the need for a bunch...

  • RE: Please any one help me to convert this cursor into Set based query

    Can you provide the DDL for the objects not defined in the script and sample data? What you have doesn't make it clear why you're doing the top 1...

  • RE: apis for sql server

    You can use the system_user function to get the login name if Windows authentication was used. To have an application use Windows authentication just set integrated authentication in the...

  • RE: SQL Express 2008 shows 9.0 in SSMS

    That would be a SQL2005 version. Have you tried checking @@version or serverproperty('productversion') to see what they say? You can also check the first line logged to the...

  • RE: Stairway to SQL Server Indexes: Step 7, Filtered Indexes

    roger.plowman (8/24/2011)


    My database design requires the use of bit fields, the majority of which will be false, and it would be nice to have a filtered index for bit fields...

  • RE: The Talent Crunch

    I don't know if it would be a bad thing if some IT careers didn't require a college degree. After all, is the standard help desk call that much...

  • RE: Shrink Database

    SanDroid (8/12/2011)


    You are right. I should stop randomly responding when others post posts about my posts and then repost. It is annoying and it takes away attention from the...

  • RE: Shrink Database

    SanDroid (8/12/2011)


    And your attitude and Rant is why more people do not say anything at all.

    What is the use of having an open forum or dicussion if the only thing...

  • RE: Data Matters

    Bob Abernethy (8/11/2011)


    The reason they are worth a lot (and the reason IT can be worth a lot) is that they have figured out how to make all that data...

  • RE: Data Matters

    Bob Abernethy (8/11/2011)


    The more data you have, the less valuable it becomes.

    Tell that to Google. 🙂

  • RE: How Far Will You Go (To Work)?

    When I started at one position my commute was an hour and a half one way including a ferry ride. I don't think I'll ever get much below 30...

  • RE: Shrink Database

    SanDroid (8/10/2011)


    As would I if the error in the script did not cause the wrong result.

    It seems incorrect to give a point to those that did NOT carefully read and...

Viewing 15 posts - 211 through 225 (of 470 total)