Forum Replies Created

Viewing 15 posts - 121 through 135 (of 179 total)

  • Reply To: Table processing questions

    Ahoi,

    the only way i know of to see the progress is in the "SQL Server Profiler".

    • change the servertype to Analysis Service and chose the correct instance
    • In there you...

    • This reply was modified 4 years, 11 months ago by  ktflash.
  • Reply To: SQL Query with latest record

    Not actually sure what the goal is, so i am guessing a bit, both queries should produce the same result

    1 Method is getting the Max  EEFDT values for CHAR_TYPE_CD in...

  • Reply To: Updating Statistics

    I a m developer (SSAS/SSIS) and familiar with the concepts of clusted and nonclustered indexes.

    How much more about indexing/statistics/... should i have knowledge of?

    What is "nice to have" and what...

    • This reply was modified 5 years ago by  ktflash.
  • Reply To: Finding Your Own Career

    This is a topic that is pretty close to my heart.

    I finished studying march last year and started as new developer responsible for all SSIS and SSAS in a company...

  • Reply To: Partition Caching

    Martin Schoombee wrote:

    Aggregations will help with performance and is definitely something worth looking at. You're right, proactive caching isn't really what you want to do here...you just want to warm the...

  • Reply To: It's More Than What You Know

    "Do not be afraid to ask questions"

    I think this also applies to: Do not be afraid to post your anwers and solutions here on the forum.

    Even if it is not...

  • Reply To: SQL Query weird result

    FUCK MY LIFE

    1. Reason it does not work is the following: This is by SQL (Server) design. NULL is not equal (or unequal) to anything. (good to know)
    2. Business reason...
  • Reply To: Table join question -- multiple records in one table

    Since you are not using any anything from the the Locations table L in your select , what happens if you run this query with a distinct?

    • This reply was modified 5 years, 1 month ago by  ktflash.
  • Reply To: Numeric and Decimal

    This post always appears on top of the "latest topic" section for me, is this for anyone else here aswell?

    If not, has anyone an idea how to get it rid...

    • This reply was modified 5 years, 1 month ago by  ktflash.
  • Reply To: how to set end date

    What John said is correct, it works perfectly the way he described it.

    Depending on the real columns you use you also need to use the partition option

    select...

    • This reply was modified 5 years, 1 month ago by  ktflash.
    Attachments:
    You must be logged in to view attached files.
  • Reply To: Data Science, BI, and Reports

    " Learn about them, experiment, understand the impact they have on your audience, and choose the best tools for the job."

    Any idea where to start with Data Mining?

    • Is there...

    • This reply was modified 5 years, 1 month ago by  ktflash.
  • Reply To: How Did I Do?

    Reading through this topic serveral thing i question myself came to my mind:

    What is the best way to keep up with new sql server technologies and updates?

    How often and how...

  • Reply To: Query Store vs Extended Events

    MVDBA (Mike Vessey) wrote:

    the query store is a useful tool, but as soon as your proc cache changes or you reboot your server then you start losing all of the valuable information...

  • Reply To: MIN is not giving me the lowest value

    Chris Harshman wrote:

    The performance mainly depends on the indexes available for the table and how up to date statistics are.

    If there is not an index that has person_id as the first...

  • Reply To: MIN is not giving me the lowest value

    Chris Harshman wrote:

    srienstr wrote:

    I do not know if my method is faster or slower, but I would do it with a subquery: 

    Have you looked at the execution plan for this?   Depending...

    • This reply was modified 5 years, 1 month ago by  ktflash.
    • This reply was modified 5 years, 1 month ago by  ktflash.

Viewing 15 posts - 121 through 135 (of 179 total)