Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,473 total)

  • RE: Options for dealing with table Contention

    CirquedeSQLeil (4/5/2010)

    Garadin (4/5/2010)

    As of right now, our entire DB is in one file/filegroup. Would splitting this into multiple files provide any benefit in this regard? They'd all still...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 5, 2010 at 12:11 pm

    #1145925

  • RE: Options for dealing with table Contention

    Thanks again Steve. I think I might actually (for this one table at least) play with the idea of vertical partitioning and see how it works out. I've got...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 5, 2010 at 11:51 am

    #1145915

  • RE: Options for dealing with table Contention

    As of right now, our entire DB is in one file/filegroup. Would splitting this into multiple files provide any benefit in this regard? They'd all still be on...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 5, 2010 at 11:35 am

    #1145902

  • RE: Options for dealing with table Contention

    Jeff Moden (4/4/2010)

    (Way too much code involved in modifying them and it's not mine, it's a third party vendor's)

    My first inclination is to invite the officers of the third...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 5, 2010 at 7:46 am

    #1145716

  • RE: Creating Indices on Temp Tables from Stored Procedures

    I think it's a great thing that you can get some really great performing well thought out solutions on the forums and they should definitely be suggested. Whether or...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 4, 2010 at 1:18 pm

    #1145501

  • RE: Options for dealing with table Contention

    Unfortunately this isn't reporting or I'd do just that. The access is done from a front end forms module. The same forms that pull up data do the...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 4, 2010 at 1:06 pm

    #1145498

  • RE: Options for dealing with table Contention

    Robert L Miller (4/4/2010)

    Take a look at the Trigger at make sure it is not running a cursor or some other activity like referencing a remote table via a Linked-Server...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 4, 2010 at 1:01 am

    #1145420

  • RE: Options for dealing with table Contention

    Steve Jones - Editor (4/3/2010)

    Chaniging the isolation level? Move that table to faster disks? Not sure what you can do here, Seth.

    Hrm, the faster disks is an option to explore....

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 3, 2010 at 4:33 pm

    #1145396

  • RE: How can I fire a trigger for each row when a BULKUPDATE happen..?

    If it's a relatively short trigger, posting the code for it would help as well.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 3, 2010 at 11:51 am

    #1145363

  • RE: Output columns from lowest to highest in a pivot type query help

    I've read several of that guys articles, good stuff. 😉

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 2, 2010 at 9:50 pm

    #1145214

  • RE: Fuzzy query...

    Greg Snidow (4/2/2010)

    What I am looking for is a way to capture non-conformances based on Employee Name. However, the field that the name goes into is a text field...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 2, 2010 at 3:12 pm

    #1145107

  • RE: Fuzzy query...

    It sounds like you don't have all that much data that you're working with. Obviously a case statement explicity listing all the different variances would be out, but here...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 2, 2010 at 1:06 pm

    #1145056

  • RE: Optimizing Remote Scan with Linked Server

    One thing to try would be to do all the joins to the local tables first and populate variables with the information, then send across the update to the variables...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 1, 2010 at 6:02 pm

    #1144562

  • RE: Creating Indices on Temp Tables from Stored Procedures

    Also, have you checked the index usage DMV to see if all of those 20 indexes are actually being used?? Have you compared their create scripts to see if they...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 1, 2010 at 3:55 pm

    #1144516

  • RE: Insert - Exec Select statements

    renu.iitkgp (3/31/2010)

    Dude, that was a mistake in changing the name of the table, before copying the piece of the code and removing company specific info and other parts, not concerned...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    March 31, 2010 at 8:13 am

    #1143107

Viewing 15 posts - 211 through 225 (of 1,473 total)