Forum Replies Created

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

  • Reply To: Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework

    I was able to work my way through building out multiple BIML files to create an entire solution for loading my data warehouse, including using the INFORMATION_SCHEMA views to dynamically...

  • RE: Subscription error:Maximum request length exceeded

    I would think the best way to see what is going on is to do some tracing, the query in SQL Server, the network traffic using Wireshark or similar, and...

  • RE: Subscription error:Maximum request length exceeded

    Did you use the code that was listed at the link I posted to determine the request size? Solving this when it's just over the 64MB hard limit will likely...

  • RE: Term Extraction Tokens

    I have been using tis one for a while, and only date and January will be returned. the numbers will be tokenized and discarded.

  • RE: On-Time, or Not

    RonKyle (3/24/2016)


    It would be wonderful to be able to work a normal 9 to 5 schedule, but most issues occur when everyone else from the office is sleeping, so I...

  • RE: On-Time, or Not

    It would be wonderful to be able to work a normal 9 to 5 schedule, but most issues occur when everyone else from the office is sleeping, so I get...

  • RE: On-Time, or Not

    It was not until very recently that society became so temporally focused, and it has been only for the past few decades in the "information age", that we as a...

  • RE: Queues in Databases

    I frequently use SQL Server for queuing operations, and if I'm not mistaken, it is the backend persisted storage for MSMQ. I have found that by using triggers to...

  • RE: Altering Included Indexes

    #4 will result in an error since the orderstatus column does not exist...not sure how that is part of the correct answer.

  • RE: Cannot connect error to Analysis Services in SS Mgmt Studio

    Ran into this error when processing a cube on a legacy server. Digging a little deeper showed an error in the TDS stream, so I disabled the TCP chimney...

  • RE: UNION

    I guess I've been spending too much time looking at query plans lately. I saw merge join and went right for it and didn't even bother to look at...

  • RE: Disk Is Cheap! ORLY?

    Disk is about to become more expensive. We are on the edge of a transition to flash storage which will make traditional disk go the way of the floppy...

  • RE: Four Years Later

    My company is a large global enterprise and we're using things like flash storage arrays and putting everything in a VM, but with the main asset of the business being...

  • RE: Unable to shrink Database

    You mentioned that you truncated the trans log, but that's no longer possible with SQL 2008 R2. Are you certain the log was truncated? Regardless, the right way...

  • RE: Disable [guest] database user in [msdb] database

    I disable it for Internet facing databases and grant specific permissions. It's also interesting that the article has not been reviewed in two years and SQL 2012 is not...

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