Scratchbox - scratchbox.co.uk - Ugg Boots UK Sale, Cheap Ugg Outlet UK SALE
General Information:
Latest News:
Carriage Return in Microsoft Excel 30 Aug 2012 | 02:30 am
Today, a colleague asked me to help him manipulate a spreadsheet to make it easier and faster for him to turn into an HTML table. He had a spread sheet consisting of 10 or so columns, one of which hou...
Changing the TOP 1000 option 20 Aug 2012 | 04:00 pm
I often use a quick SELECT TOP 1000 to get a quick understand of what data is stored in an unfamiliar table, or to retrieve a small extract from a view to hand off to someone else in a spread … Contin...
Using dm_db_missing_index_details can be dangerous 6 Aug 2012 | 05:50 pm
Using the DMV sys.dm_db_missing_index_details to identify and create “missing” indexes could be doing you more harm than good. If you read Microsoft books online carefully for information on this DMV,...
SSRS Default Date Parameter Functions 24 Jul 2012 | 06:19 pm
Several months ago, I made a list of date functions I commonly used to set the default value of an SSRS Parameter. I put it on our internal network for my colleagues, and today figured I may as well p...
SSRS Default Date Parameter Functions 24 Jul 2012 | 06:19 pm
Several months ago, I made a list of date functions I commonly used to set the default value of an SSRS Parameter. I put it on our internal network for my colleagues, and today figured I may as well p...
SQL Challenge: Snap To Nearest Factor 18 Jul 2012 | 12:25 am
In my office, I often have people come over to my desk and say something like “Zach, I’ve got a SQL Challenge for you…”, and I love it. It gives me a chance to just take a break from what … Continue r...
SQL Challenge: Snap To Nearest Factor 18 Jul 2012 | 12:25 am
In my office, I often have people come over to my desk and say something like “Zach, I’ve got a SQL Challenge for you…”, and I love it. It gives me a chance to just take a break from what I’m doing an...
SQL In The City London 2012 was fun… 16 Jul 2012 | 01:48 am
A few months ago I posted about a free SQL Server training event, SQL In The City London 2012, being put on in London by the good people of Redgate. Well, yesterday it took place and I thought I’d wri...
SQL In The City London 2012 was fun… 16 Jul 2012 | 01:48 am
A few months ago I posted about a free SQL Server training event, SQL In The City London 2012, being put on in London by the good people of Redgate. Well, yesterday it took place and I thought I’d wri...
Returning vertical data in one horizontal column 9 Jul 2012 | 03:35 pm
Having data in a normalized form is great. It helps eliminate redundant data, and therefore helps save space in the database. In this blog post, I want to discuss how you can query a normalized databa...
