Forum Replies Created

Viewing 15 posts - 151 through 165 (of 508 total)

  • RE: AMD vs Intel

    Alexander,

    You might want to try some different comparisons. SET STATISTICS IO, TIME ON before running the query on each box. Could there be a big difference in scans/reads?

    Then...

    July 26, 2011 at 1:42 pm

    #1358789

  • RE: PK/FK on a same column, INSERT fails

    Just to add my 2 cents. When I get something like this then I know that there's either bad data in the database or data that I don't know...

    July 22, 2011 at 11:18 am

    #1357204

  • RE: Simple Aggregate Function Question [Novice]

    I would use a calendar table to do the grouping for this sort of thing. Here's a link to an article I wrote on the subject.

    http://www.sqlservercentral.com/articles/T-SQL/70482/

    Once you get the...

    July 18, 2011 at 11:54 am

    #1354383

  • RE: Advanced T-SQL Query

    jkp2311 (7/12/2011)

    Hi Guys,

    You all, getting right..

    I am looking for Subquery, Derived Table, Correlated Query.

    you have any good article,or tutorial.Please let me know..

    Thanks and Best Regards,

    Jignesh Patel

    Jignesh,

    I would try Google on...

    July 13, 2011 at 2:18 pm

    #1352451

  • RE: Report on sysjobs, sysjobhistory

    TheSQLGuru (7/13/2011)

    non-database: textpad (LOVE this one), sysinternals, trillian, roboform, iarsn taskinfo, sourcegear vault (free single user)

    Kevin,

    Glad you put in a plug for good ol' textpad. This one has saved...

    July 13, 2011 at 12:10 pm

    #1352347

  • RE: Handle NULLs

    SQLkiwi (7/8/2011)

    tfifield (7/8/2011)

    Is there a link to Paul's CROSS APPLY method for UNPIVOT? I'd love to see it.

    Let me link to someone else's blog for a change...http://bradsruminations.blogspot.com/2010/02/spotlight-on-unpivot-part-1.html

    Paul,

    Thanks for the...

    July 8, 2011 at 2:23 pm

    #1350647

  • RE: Memory pressure

    George and Gail,

    Thanks for your replies. It helped clear up a confusion I had on 32-bit SQL Server running on a 64-bit OS.

    Todd Fifield

    July 8, 2011 at 2:10 pm

    #1350641

  • RE: Memory pressure

    GilaMonster (7/8/2011)

    AWE is ignored completely on 64-bit.

    Locked pages has a use on both, but it is not related to memory addressability.

    Gail,

    Thanks - I'll keep it in mind. How about...

    July 8, 2011 at 1:22 pm

    #1350613

  • RE: Handle NULLs

    Jeff Moden (7/8/2011)

    Nevyn (7/8/2011)

    Cool stuff, Jeff!

    So do you ever use PIVOT and/or UNPIVOT, or are workarounds almost always better/faster?

    I don't use PIVOT because Cross-Tabs are (usually) both faster and easier...

    July 8, 2011 at 1:19 pm

    #1350610

  • RE: Memory pressure

    GilaMonster (7/8/2011)

    Jayanth_Kurup (7/7/2011)

    Since your using 64 bit SQL Server you actually do not need to enable lock pages in memory to avoid paging , mainly since sql will be able...

    July 8, 2011 at 11:59 am

    #1350566

  • RE: Temp Table Name confusion with Nested Procedures?

    I got burned on this the hard way. A temp table was created in a trigger. I used a very simple table name like #T for temp.

    I had...

    July 6, 2011 at 12:01 pm

    #1349200

  • RE: Oddball Configuration Question

    Lowell,

    Thanks for the quick reply.

    As for configuration - I would assume enabling AWE and lock pages in memory - just like AWE on a 32-bit machine. Correct?

    Todd Fifield

    July 5, 2011 at 1:44 pm

    #1348552

  • RE: Trying to capture no record inserted.

    Paul,

    That one is bloody brilliant! It would never have occurred to me to use an OUTPUT clause from an UPDATE for an INSERT.

    Remind me to buy you a beer...

    June 30, 2011 at 1:40 pm

    #1346725

  • RE: cursor issue

    shilpa.shankar87 (6/28/2011)

    Below error the job is throwing:

    Message

    Executed as user: . Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value...

    June 29, 2011 at 2:28 pm

    #1346236

  • RE: cursor issue

    I can see why you're using cursors here - to run procedures that run reports so I'm not going to go after you for using cursors within cursors. The...

    June 28, 2011 at 2:21 pm

    #1345493

Viewing 15 posts - 151 through 165 (of 508 total)