Forum Replies Created

Viewing 15 posts - 1 through 15 (of 100 total)

  • RE: Adding a SQL Server instance to existing 2012 cluster

    sgmunson - Friday, May 18, 2018 12:19 PM

    Lexa - Friday, May 18, 2018 12:11 PM

    May 18, 2018 at 2:00 pm

    #1991081

  • RE: Adding a SQL Server instance to existing 2012 cluster

    sgmunson - Friday, May 18, 2018 9:15 AM

    Lexa - Friday, May 18, 2018 8:34 AM

    May 18, 2018 at 12:11 pm

    #1991060

  • RE: Adding a SQL Server instance to existing 2012 cluster

    Great point. This is a request from a consultant who is going to do a migration in Production and requested everything set up identical. Also, resource constraints at the moment...

    May 18, 2018 at 8:34 am

    #1991001

  • RE: How to avoid Nested Loop Join

    I'm afraid I can't put table definitions and query plans here. I can send you via PM.

    March 25, 2014 at 6:42 pm

    #1700107

  • RE: Re-partitioning a large table

    HowardW, completely agree.

    I have a partition in place that has unrestricted growth (flaw in partitioning strategy that came from unforeseen business case after the fact), which in my case has...

    May 24, 2013 at 8:00 am

    #1618293

  • RE: Re-partitioning a large table

    PaulB-TheOneAndOnly (5/23/2013)

    Lexa (5/23/2013)

    PaulB-TheOneAndOnly (5/23/2013)

    Lexa (5/23/2013)

    Current partitioning strategy does not restrict growth within a single partition where we already see 576,114,055 records and growing. Operations on that specific partition are taking...

    May 24, 2013 at 7:22 am

    #1618267

  • RE: Re-partitioning a large table

    PaulB-TheOneAndOnly (5/23/2013)

    Lexa (5/23/2013)

    Current partitioning strategy does not restrict growth within a single partition where we already see 576,114,055 records and growing. Operations on that specific partition are taking unacceptable amount...

    May 23, 2013 at 2:53 pm

    #1618042

  • RE: TempDB and SSDs

    MyDoggieJessie (12/22/2012)

    Yep that's the one. It may be old but it works. "Electricity" is quite old, but still works all the same 😀

    I'm trying to measure performance of...

    January 9, 2013 at 12:55 pm

    #1575400

  • RE: TempDB and SSDs

    MyDoggieJessie (12/21/2012)

    I can't say for tempdb specifically but have noticed improvements for IO operations from other DB's running on SSD, I recommend you run some testing using IOMeter or similar...

    December 22, 2012 at 9:27 pm

    #1571163

  • RE: index creation on temp tables

    Jeff Moden (12/20/2012)

    If your Temp Tables are large enough to warrant indexes, you might be putting too much in your Temp Tables which defeats the whole purpose that you're trying...

    December 20, 2012 at 3:24 pm

    #1570668

  • RE: Dropping #temp tables at the end of stored procedure

    GSquared (12/5/2012)

    It doesn't hurt anything.

    I don't bother, personally, but there's no disadvantage to it that I know of.

    If you have a proc that is frequently called and it has 10...

    December 5, 2012 at 9:31 am

    #1565820

  • RE: SSRS 2008 generating reports from snapshots

    anthony.green (11/15/2012)

    What version of SQL are you running, Standard or Enterprise? If Standard then it will be multiple copies, if Enterprise you can use data driven subscriptions

    Enterprise. Sounds like...

    November 15, 2012 at 2:09 pm

    #1559532

  • RE: SSRS 2008 Parameter Passing Issue

    T_Dot_Geek (11/8/2012)

    Make sure there is no Default Values Specified in the Store Parameter Area.

    Thanks!

    November 8, 2012 at 7:20 pm

    #1557423

  • RE: Isolation Level and LOCK_TIMEOUT

    TheSQLGuru (10/4/2012)

    Lexa (10/4/2012)

    TheSQLGuru (10/4/2012)

    Please show the code for the sproc. Does the sproc reference any UDFs by any chance?

    Also, what tool/mechanism did you use to determine that this sproc...

    October 4, 2012 at 10:49 am

    #1545682

  • RE: Isolation Level and LOCK_TIMEOUT

    TheSQLGuru (10/4/2012)

    Please show the code for the sproc. Does the sproc reference any UDFs by any chance?

    Also, what tool/mechanism did you use to determine that this sproc was doing...

    October 4, 2012 at 9:14 am

    #1545613

Viewing 15 posts - 1 through 15 (of 100 total)