Forum Replies Created

Viewing 15 posts - 7,411 through 7,425 (of 49,571 total)

  • RE: Are the posted questions getting worse?

    Luis Cazares (10/25/2014)


    GilaMonster (10/25/2014)


    Anyone live anywhere where they can easily get a variety of different dried chillies? Stuff Costeño, New Mexico, Choricero, Arbol, Cascabel, Ancho, Mulatto, Negro, Pasilla?

    I do, but...

  • RE: Are the posted questions getting worse?

    BWFC (10/25/2014)


    GilaMonster (10/25/2014)


    Anyone live anywhere where they can easily get a variety of different dried chillies? Stuff Costeño, New Mexico, Choricero, Arbol, Cascabel, Ancho, Mulatto, Negro, Pasilla?

    Have you tried Amazon?...

  • RE: Are the posted questions getting worse?

    Anyone live anywhere where they can easily get a variety of different dried chillies? Stuff Costeño, New Mexico, Choricero, Arbol, Cascabel, Ancho, Mulatto, Negro, Pasilla?

  • RE: High PLE and raising... but Paging up to 120/sec?

    SQLKnowItAll (10/24/2014)


    "It is the sum of Memory\ Pages Input/sec and Memory\ Pages Output/sec. " [snip] Really it is just an indication of how much data is being moved in and...

  • RE: Logs full even with Simple model

    Something in the job is filling the log, failing and rolling back, leaving the log empty again after it completes.

    You're going to have to monitor log reuse reason and %...

  • RE: Why it's showing 3 sessions.......!!!!!

    spaghettidba (10/24/2014)


    SSMS opens multiple connections:

    1 for the editor window

    1 for the object explorer

    1 for the intellisense

    And sometimes a few more for no good reason.

  • RE: CTE update column

    You'll get an error. You reference the column name where the table name needs to be in the update and you reference a column which doesn't exist in that scope

    This,...

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (10/24/2014)


    spaghettidba (10/23/2014)


    Jack Corbett (10/23/2014)


    spaghettidba (10/22/2014)


    Stefan Krzywicki (10/22/2014)


    Of course, regionalisms mean it could be called most anything.

    For example: In most of the USA, a blended milk and...

  • RE: Why it's showing 3 sessions.......!!!!!

    Don't use sysprocesses. It's deprecated, from SQL 2000.

    Use the DMVs, sys.dm_exec_requests/sys.dm_exec_sessions

  • RE: How to name a column the same name of a tablename

    ScottPletcher (10/23/2014)


    You can use system procedure:

    sp_rename

    to rename a column.

    He's trying to alias a column in a query with a dynamic name, not rename a column in a...

  • RE: How to name a column the same name of a tablename

    Can you post what you have so far please? It's not actually hard to do the highlighted portion, but easier to add to your existing code than write from scratch.

  • RE: Best Practices

    ramana3327 (10/23/2014)


    I think it is possible, If there are 2 SQL Instances (Replicas) running on the same node, can they being part of the same AG?

    I'm glad you think...

  • RE: High PLE and raising... but Paging up to 120/sec?

    SQLKnowItAll (10/23/2014)


    I assumed this meant pages of data from sql, but I suppose now that it could be anything on the server. Thoughts?

    Only one. Figure out exactly what it's showing...

  • RE: Best Practices

    ramana3327 (10/23/2014)


    Is it possible to have AG created across multiple domains?

    No.

    Is it possible to have AGs created across VMs on same physical host?

    Should be, but that's not a good idea...

  • RE: High PLE and raising... but Paging up to 120/sec?

    What, exactly, do you mean by 'paging'?

Viewing 15 posts - 7,411 through 7,425 (of 49,571 total)