Forum Replies Created

Viewing 15 posts - 2,161 through 2,175 (of 5,843 total)

  • RE: TempDB datafiles

    1) You can actually make physical file access be SLOWER by having too many files on too few (sometimes just ONE) spindles. I have seen this over and over...

  • RE: SQL Server Function: Cursor or Tally Table; which to use, HELP

    LOVE the pic Lowell!! Your code rocks too, btw.

    Oh, and I would like to request that the OP makes whomever designed that system to drop and give me 20!!!...

  • RE: moving log files in HA groups

    That sure would seem to be the process to me also, but like you I don't know that that is documented explicitly anywhere. Edge cases like that usually don't...

  • RE: SQL Server Function: Cursor or Tally Table; which to use, HELP

    Lowell, you are a better man than I this morning (or perhaps my caffeine hasn't fully kicked in yet)! Without sample output I can't make heads or tails of...

  • RE: Newbie Question

    Web search is your friend. I searched Google for the words

    ssms login other domain user

    and came up with a number of references to using the windows Run As...

  • RE: querry get data in double codes in string

    mpradeep23 (2/10/2014)


    Hi

    i have table called t1

    with column name offers with data as

    "entitlementwrapper" : [ {

    "Type" : "Factory Warranty",

    ...

  • RE: Batch processing in sql 2012 fails

    Do you really think you gave us enough to go on with that short one-liner to be able to assist you?? No table structures, no query, no error message...

  • RE: SQL Query

    1) Balu, you were asked explicitly what version of SQL Server you were running this on. You posted to a SQL 2012 forum, and the code provided DOES WORK...

  • RE: querry get data in double codes in string

    mpradeep23 (2/10/2014)


    hi

    i need out put as

    type ...

  • RE: Always On

    This should be possible and is easy enough to test out once you have the 3 serves in a Windows Server Failover Cluster, which is a required starting point anyway....

  • RE: querry get data in double codes in string

    Jeff Moden (2/9/2014)


    TheSQLGuru (2/9/2014)


    Please provide several sample sets of data and the corresponding table output you expect (with column data types). That's JSON, yes?

    THAT's JSON? Shoot... that's just...

  • RE: querry get data in double codes in string

    Please provide several sample sets of data and the corresponding table output you expect (with column data types). That's JSON, yes?

  • RE: Basic SQL Logic (Need some help with approach)

    gregory.perry2 87972 (2/8/2014)


    I have a 1 table Transactions table

    1) in this table I have the following fields

    StoreNumber, CustNo, TransactionAmt, Date

    I need to find out the following:

    1)The sum of transactions by...

  • RE: Result set from prior date

    You MUST have SOMETHING on that table to use as a filter. Without that you can't possibly be getting meaningful output.

    If the data does not contain a date field...

  • RE: Result set from prior date

    caippers (2/6/2014)


    I'm trying to run counts for dates prior to today's date. I want to run a count from a table from the day before.

    Here is what I...

Viewing 15 posts - 2,161 through 2,175 (of 5,843 total)