Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

Request Friendship



Upload Image

33 years old
UK
Male

My Sections

Mike's Blog (Blogs)

My Activities

Ask20
Blogs18
Puzzles182
Pages1
Quiz37
Mike Lewis
42 · 4% · 1336

Mike Lewis's Home

My name is Mike Lewis.
  • Need your suggestion / Feedback regarding - automation of database rebuild / reorganize indexes

    Mike Lewis Commented 5 Months ago through Ask
    See [http://ola.hallengren.com][1] You'll struggle to find a more comprehensive set of maintenance scripts. Index optimisation is one of them, and allows you to set your own thresholds for when to reorg or rebuild. I've created my own scripts in th...
    krish
    136 · 1% · 360
  • How to make statistics work for this table/query

    Mike Lewis Commented 6 Months ago through Ask
    If it's the same query but only the inputs to the dataversion range are changed then a plan guide should do the trick. Look it up, it's a useful feature, which is particularly good for optimising queries for 3rd party tools when you can't get access to...
    guenter
    28 · 6% · 1822
  • How to make statistics work for this table/query

    Mike Lewis Commented 6 Months ago through Ask
    Is it a parameterised query causing the problem? Would a plan guide do the trick? If the query is only using a refactored plan depending on the dataversion values then a plan guide may work in this case, as you can tell the optimizer which plan to use...
    guenter
    28 · 6% · 1822
  • TSQL In a select I want to include conditions in my where clause

    Mike Lewis Commented 6 Months ago through Ask
    In that case I'm going to recommend using dynamic sql. Never run dynamic sql where the sql is passed as a parameter, but in my example below it is fine as you are in total control of the sql being run. Essentially, I'm suggesting specifying the WHE...
    Emile
    463 · 0% · 81
  • TSQL In a select I want to include conditions in my where clause

    Mike Lewis Commented 6 Months ago through Ask
    Is this script to form part of a stored proc? And is ColumnId an input parameter? Or is ColumnId a table column? There are various options to achieve this but choosing the best one depends on the answers to my questions above, along with a few othe...
    Emile
    463 · 0% · 81
  • send email notification from ssrs 2005

    Mike Lewis Commented 6 Months ago through Ask
    You can try creating an extra dataset that points to a SQL Server. In this SQL Server create a stored proc (ideally in a utility or DBA database) that sends emails - this will need to be configured for db mail. Your SSRS dataset can then point to ...
    nilesh
    1182 · 0% · 21
  • Take Offline option of Database.

    Mike Lewis Commented 6 Months ago through Ask
    Hi Ramkoti You cannot disable this option, however there really should be no need to. If you don't wish to take the database offline, don't click on the option! There's no reason why you should click it accidentally due to its location in the menu....
    ramkoti
    414 · 0% · 95
  • Scalar Function for Text Compression

    Mike Lewis Commented 6 Months ago through Blogs
    As with anything it depends on the situation, and it's always worth checking that the compression overhead is worthwhile for each scenario. I actually wanted this originally when capturing the query cache data in SQL Azure - I wanted to compress the st...
  • Scalar Function for Text Compression

    Mike Lewis Commented 6 Months ago through Blogs
    I have and will probably do something like that for on-premise, however i'm currently working on sql azure which doesn't support CLR functions. My other option is to make use of the. net libraries in powershell but that would mean using powershell for r...
  • Scalar Function for Text Compression

    Mike Lewis Commented 6 Months ago through Blogs
    Thanks. I experimented with passing keywords too, forming part of the Huffman tree like the individual characters. I figured that repeated words reduced down to bit sequences would save a lot of space - I was wrong! I didn't actually get much more c...
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.