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...

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...

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...

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...

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...

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 ...

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....

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...

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...

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...