tag:blogger.com,1999:blog-74853731306842378322024-03-13T04:14:41.590+00:00T-SQL Tidy BlogNews and Updates for <a href="http://www.tsqltidy.com">T-SQL Tidy</a>. An On-line Transact-SQL parser and formatter.Unknownnoreply@blogger.comBlogger88125tag:blogger.com,1999:blog-7485373130684237832.post-37304560505525435922016-04-14T23:35:00.001+01:002016-04-14T23:35:36.457+01:00Sad face, Podcast, Sad face Azure soundsofsql.com<div dir="ltr" style="text-align: left;" trbidi="on">
The soundsofsql.com site running on Azure has stopped working.<br />
<br />
So I'm sad, the network forwarding is broken, it's just a sad mess. It went wrong earlier in the week, but now I'm just shaking my head and looking sad.<br />
<br />
There does appear to be some issue with Azure VM and the disks...<br />
<br />
But I think its going to take a little bit to get it up and running again.<br />
I am toying with starting again from scratch and using a dedicated podcast service like soundcloud.com<br />
<br />
I'm going to some investigation, until then, soundsofsql.com is down... but not out.<br />
<br />
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-14095961088054761092016-04-12T22:20:00.000+01:002016-04-12T22:20:10.013+01:00Install SQL Server 2016 RC2<div dir="ltr" style="text-align: left;" trbidi="on">
I installed <a href="https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016" target="_blank">SQL 2016 tonight</a>, I thought it would be interesting to record the setup then comment on it...<br />
<br />
The video of the server install is here;<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/HBYQah5qwN8/0.jpg" src="https://www.youtube.com/embed/HBYQah5qwN8?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<br />
<br />
I really like the new tempdb section and the <a href="https://msdn.microsoft.com/en-us/library/ms175935.aspx" target="_blank">instant file initialization tick box.</a><br />
<h3 class="r" style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 18px; font-weight: normal; margin: 0px; overflow: hidden; padding: 0px; text-overflow: ellipsis;">
<br /></h3>
<div>
I've taken this bit from the Microsoft website.</div>
<div>
<br /></div>
<div style="background-color: white; border: 0px; box-sizing: inherit; color: #454545; font-family: WOL_Reg, 'Segoe UI', Tahoma, Arial, sans-serif; font-size: 14px; line-height: 21px; margin-bottom: 25px; outline: 0px; padding: 0px; vertical-align: baseline; word-break: keep-all; word-wrap: break-word;">
In SQL Server 2016 RC 2, enhancements include:</div>
<ul style="background-color: white; border: 0px; box-sizing: inherit; color: #454545; font-family: WOL_Reg, 'Segoe UI', Tahoma, Arial, sans-serif; font-size: 14px; line-height: 21px; margin: 0px 0px 1.5em 3em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">R Services setup – the setup process for R Services is much more integrated into SQL Server setup. There is no longer a need to manually download and install Microsoft R open and R Server if the SQL Server is connected to the Internet; it becomes part of the SQL Server install sequence.</li>
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">SQL Server Management Studio (SSMS) – This release of SSMS features an update to the Visual Studio 2015 shell bringing enhancements such as the quick launch toolbar and improved theming support.</li>
<li style="border: 0px; box-sizing: inherit; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 0.5em; outline: 0px; padding: 0px; vertical-align: baseline;">Mobile reports – Brand Packages will now be downloaded to the mobile report publisher from a server running RC2 and available for use in report creation. Basic mobile report content migration between servers is now supported.</li>
</ul>
<br />
https://blogs.technet.microsoft.com/dataplatforminsider/2016/04/01/sql-server-2016-release-candidate-2-now-available/</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-87278275819703684652016-04-11T21:04:00.001+01:002016-04-11T21:04:45.811+01:00One blog a day... Not very LinkedIn - Misidentifying people<div dir="ltr" style="text-align: left;" trbidi="on">
I've heard about strange people who blog every day, yes, every EVERY DAY. This includes people like <a href="http://www.richardherring.com/" target="_blank">Richard Herring</a> - I'm not sure if he blogs as me1 or me2, but since he has an alter ego - he only has to work half as hard....<br />
<br />
So I'm going to blog every day this week, I could cheat an include the blog post I put up yesterday, but I'm a much better person than that.... Hold on a sec. No I am not.<br />
<br />
This is my second post, and I think I've run out of interesting things to say.... Or have I....<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimfAA-QoCDWO9wQ5gUDndW46s_ddclgJDGsXjv8UqDYnxNfhcJabxt-LLS05l_WCS1exVyTXpDtPVGrR0pSaP8-BKa3fEHOjadAOiUd1e-3aots91nJQQkgcCNUuG8T1zi-hRNKIbNeFkU/s1600/iphone+1045.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimfAA-QoCDWO9wQ5gUDndW46s_ddclgJDGsXjv8UqDYnxNfhcJabxt-LLS05l_WCS1exVyTXpDtPVGrR0pSaP8-BKa3fEHOjadAOiUd1e-3aots91nJQQkgcCNUuG8T1zi-hRNKIbNeFkU/s320/iphone+1045.png" style="cursor: move;" unselectable="on" width="179" /></a>This morning I saw an email from LinkedIn. This is a screen grab from my phone.<br />
<div style="font-family: Helvetica,Arial,sans-serif; font-size: 24px; font-weight: 100; line-height: 1.2em; text-align: left;">
</div>
I was very impressed, I don't know Nick that well. I thought he was a Data Professional who worked in Southampton and not a Fleet Street Journalist!!<br />
<br />
Well he's not. Nick is a Data Architect and it appears that the LinkedIn AI / Bot that has been collecting articles has been misidentifying people. <br />
<br />
Now, this is a trivial case. But what if this system was being used to identify people for other purposes? "Have you been miss sold PPI?"<br />
<br />
So that's blog post two done, now 5 more to go.<br />
<br />
<img height="96" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimfAA-QoCDWO9wQ5gUDndW46s_ddclgJDGsXjv8UqDYnxNfhcJabxt-LLS05l_WCS1exVyTXpDtPVGrR0pSaP8-BKa3fEHOjadAOiUd1e-3aots91nJQQkgcCNUuG8T1zi-hRNKIbNeFkU/s320/iphone+1045.png" style="left: 530px; opacity: 0.3; position: absolute; top: 197.61px;" width="54" /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-15266593718351134662016-04-10T23:50:00.002+01:002016-04-10T23:50:50.890+01:00Guerrilla Talks - A new lightning talk format...<div dir="ltr" style="text-align: left;" trbidi="on">
Its all <a href="https://twitter.com/splappy" target="_blank">Richard Munn's </a><strike>fault </strike>idea - "Lets create a forum to encourage new speakers..."<br />
<br />
Guerrilla Talks is <a href="https://twitter.com/splappy" target="_blank">Richard Munn's </a><strike>fault</strike> brain child. A way of encouraging new speakers.<br />
<br />
He pitched it as a crazy idea, but in fact its quite sensible.<br />
<br />
A way of;<br />
*Allowing people to dip their toes into speaking without having to do a 50/60 minute session.<br />
* Letting people try new ideas.<br />
* Doing it all from the comfort of your desk (or <a href="https://en.wikipedia.org/wiki/As_It_Occurs_To_Me" target="_blank"><span style="background-color: white; color: #252525; font-family: sans-serif; font-size: 14px; line-height: 22.4px;">high-backed armchair</span>)</a> at lunch time.<br />
<a href="https://www.youtube.com/watch?v=36nWNAvtwrw" target="_blank"><br /></a>
<a href="https://www.youtube.com/watch?v=36nWNAvtwrw" target="_blank">So as Pop Will Eat Itself would say, 'Let's get down to it, Boppers'.</a><br />
<br />
Guerrilla Talks is a new lightning talk format session to help and encourage new, up and coming speakers to dip their toes in speaking without leaving the comfort of the desk. It also gives old hands a chance to trying something new and different.<br />
<br />
Its all remote (via GotoWebinar) and the rules are quite simple.<br />
* The session can be either 5 or 10 minutes<br />
* Its run at lunch time (BST) 12:30pm-1pm<br />
* Once a month, the last Wednesday in each month.<br />
* It’s open to any and everyone<br />
* Any topic<br />
<br />
<a href="https://attendee.gotowebinar.com/rt/3975031776336985857" target="_blank">The first one is on the 27th April at 12:30</a>; And here is the first line up.<br />
<br />
Richard Munn @splappy - Once, Twice, Three Times A DBA (5 mins)<br />
Alex Whittles @PurpleFrogSys - “Windowing functions – the Chuck Norris of T-SQL” (10 mins)<br />
Rob Sewell @sqldbawithbeard - Four things you need to know to effectively use PowerShell (5 mins)<br />
<br />
<a href="https://attendee.gotowebinar.com/rt/3975031776336985857" target="_blank">Be there or be square (yes, I am that old). Register here. </a><br />
<br />
The next one is on the.. 25th of May<br />
<br />
See you there,<br />
<br />
Mark</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-59431967555110742702015-11-02T03:05:00.000+00:002015-11-02T03:05:00.211+00:00SQL Relay YouTube Channel<div dir="ltr" style="text-align: left;" trbidi="on">
Over the last week months we have launched the <a href="https://www.youtube.com/channel/UCHAMO8eY29raj57AXQl1Mxw" target="_blank">SQL Relay YouTube channel.</a><div>
<br /></div>
<div>
We currently have 9 videos ranging from R, Powershell and Extended Events - but there are many more on the way.. </div>
<div>
<br /></div>
<div>
New videos should be going up every few weeks for the next couple of months, so you need to subscribe to the <a href="https://www.youtube.com/channel/UCHAMO8eY29raj57AXQl1Mxw?view_as=subscriber" target="_blank">YouTube channel</a> to get notifications.</div>
<div>
<br /></div>
<div>
Remember to leave rate and leave feedback about the sessions ( Your call is important to us)</div>
<div>
<br /></div>
<div>
If you want to record a session or do a webinar for us, then please get in contact!!</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
<br /></div>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-22941458624441179632014-11-04T20:11:00.001+00:002014-11-04T20:11:25.141+00:00New Podcast on Technology and SQL Server - Sounds of SQL <div dir="ltr" style="text-align: left;" trbidi="on">
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
I've been planning on doing a technology / SQL Server podcast for a while.</div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
<br /></div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
There are some really goods ones on tech I listen to like; <a href="http://www.dotnetrocks.com/">.NET Rocks</a> , <a href="http://www.runasradio.com/">RunAs Radio</a><span style="color: #222222; font-family: arial, sans-serif;"> , <a href="http://www.sqldownunder.com/Podcasts" target="_blank">SQL DownUnder</a>, </span></div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
<span style="color: #222222; font-family: arial, sans-serif;">and of course Scott Hanselman's podcasts </span><a href="http://www.hanselminutes.com/" target="_blank">HanselMinutes</a><span style="color: #222222; font-family: arial, sans-serif;"> , </span><a href="http://thisdeveloperslife.com/" target="_blank">This Developers Life</a><span style="color: #222222; font-family: arial, sans-serif;"> , </span><a href="http://azure.microsoft.com/en-us/documentation/videos/azure-friday/" target="_blank">Azure Friday</a><span style="color: #222222; font-family: arial, sans-serif;"> and of course the 'fancy' </span><a href="http://www.ratchetandthegeek.com/" target="_blank">Ratchet and the Geek </a><span style="color: #222222; font-family: arial, sans-serif;">(which is my favourite right now )</span></div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
<span style="color: #222222; font-family: arial, sans-serif;"><br /></span></div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
<span style="color: #222222; font-family: arial, sans-serif;">These are great and I love then, but I’ve not found anything from a British point of view… </span></div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
<span style="color: #222222; font-family: arial, sans-serif;"><br /></span></div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
<span style="color: #222222; font-family: arial, sans-serif;">I asked a friend to put one together with me and I went up to SQLRelay in London and did a series of 5 minute interviews with a number of speakers..</span></div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
<span style="color: #222222; font-family: arial, sans-serif;"><br /></span></div>
<div style="font-family: -apple-system-font; font-size: 12px; line-height: 16px;">
<span style="color: #222222; font-family: arial, sans-serif;">The interviews will be going up on<a href="http://www.soundsofsql.com/" target="_blank"> Sounds of SQL </a>over the next few weeks once I get the hang of the editing process, I will be putting them up on iTunes too. [One has already gone up]</span></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-89122429787065758892014-10-14T20:50:00.003+01:002014-10-14T21:57:20.737+01:00Windows Technical Preview...<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
I just can't resist a new version of windows, no matter how how early.</div>
<div style="text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="webkit-fake-url://19f90da3-2b23-43d2-ad80-a6ba3a2b690b/image.tiff" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div style="text-align: left;">
<br />
Firstly get with the program, http://windows.microsoft.com/en-gb/windows/preview</div>
<div style="text-align: left;">
<br />
Download the ISO, create a new virtual machine and bish bash bosh - minutes later, Windows X<br />
(using a VMWare Fusion on my macbook pro)</div>
<div style="text-align: left;">
When you log into windows, you go straight to the desktop and well, well, well the <u>start menu</u> is back - and its looking good...<br />
It feels like Windows 7.5 (!) ;-)<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfBiMDspHPZW4T-U5iH_-wCAEKXGoaHf_yRoRBzpRIVVG7Mv3kLrbdCT2eXQhrhGXLp0YJC9AlfNDXQMMs8SNpRSrMrRd5YepklcvSTZSZC2swlB5x5JX8rjpZjN4Zc2FBsqb6aoEViWDf/s1600/startmenu.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfBiMDspHPZW4T-U5iH_-wCAEKXGoaHf_yRoRBzpRIVVG7Mv3kLrbdCT2eXQhrhGXLp0YJC9AlfNDXQMMs8SNpRSrMrRd5YepklcvSTZSZC2swlB5x5JX8rjpZjN4Zc2FBsqb6aoEViWDf/s1600/startmenu.png" height="200" width="320" /></a></div>
<br />
<br />
<br />
<u><br /></u></div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<u><br /></u></div>
<div style="text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmRUdJf0bMEJr_0pjaXpAZqfvVl2kxPqVGmdG_29dHXC9gZxHyDFgsphK3HecSQFKu4_z1II_2S_M6ilK0gYbLSH_ieuG-RWbmH5UbbBxuprbBTKvvyd6AKfmuttCsqlz7f9Zwx06Pmt9h/s1600/manydesktops.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmRUdJf0bMEJr_0pjaXpAZqfvVl2kxPqVGmdG_29dHXC9gZxHyDFgsphK3HecSQFKu4_z1II_2S_M6ilK0gYbLSH_ieuG-RWbmH5UbbBxuprbBTKvvyd6AKfmuttCsqlz7f9Zwx06Pmt9h/s1600/manydesktops.png" height="125" width="200" /></a><u>Task View </u>- or multiple desktops is cool, but I do remember a Tweak UI on Windows 95/98 , this has been a feature of XWindows for years!</div>
<div style="text-align: left;">
<br />
<br />
<u><br /></u>
<u><br /></u>
<u><br /></u>
<u><br /></u>
<u><br /></u>
<u><br /></u>
<u><br /></u>
<u><br /></u>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiPlpDH5jntw5KFfVnHYcWfB2LkDa68C6b_dild3Vla2-tnhE4Z1oS0TArZGX9PQ_G0h3DHokHzVjPM6C9WlwK-VOZdPHlU5stNpRX5pr6gvxaStajrFZRikXR0zAKdEzJoUBlkCkCCHDr/s1600/history.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiPlpDH5jntw5KFfVnHYcWfB2LkDa68C6b_dild3Vla2-tnhE4Z1oS0TArZGX9PQ_G0h3DHokHzVjPM6C9WlwK-VOZdPHlU5stNpRX5pr6gvxaStajrFZRikXR0zAKdEzJoUBlkCkCCHDr/s1600/history.png" height="125" width="200" /><u>File History</u> - interesting - is this the start of TimeMachine for windows? (Perhaps not) - I will play when I attach a USB drive.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTLZI_xlOMT2Dhz2VU6Zr_LXBpOY-scquQ-7NdZoil5pXAQkpReqNb6UUgajxqQb1coe0f7uJWF-mTrZvICwH3i7ndWFRatojlbr64m-fORlgiuOxERTrYTM9lvDGdo3n67Z5VHjG9qwtE/s1600/search.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTLZI_xlOMT2Dhz2VU6Zr_LXBpOY-scquQ-7NdZoil5pXAQkpReqNb6UUgajxqQb1coe0f7uJWF-mTrZvICwH3i7ndWFRatojlbr64m-fORlgiuOxERTrYTM9lvDGdo3n67Z5VHjG9qwtE/s1600/search.png" height="125" width="200" /></a></div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<u>Search</u> has been updated, but its not clear how different or new this is.<br />
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><br />
<br />
<br />
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: Times; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: Times; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<br /></div>
<br />
<br />
<br />
Well thats it for now, it looks good, its quick, I might just switch over as my main OS. ;-)</div>
<div style="text-align: left;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-left: 1em;"></a></div>
<div style="text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7485373130684237832" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-27218010588540024922014-07-30T22:14:00.000+01:002014-07-30T22:29:40.894+01:00SSMS Add-in feature request<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
We all use SSMS, we all love SSMS, it's really good. </div>
<div>
<br /></div>
<div>
I know we use it everyday and it hardly ever breaks, but Microsoft don't add new features very often.</div>
<div>
This can be somewhat frustrating, you can buy 3rd party Add-ins, to extend the functionality, but technically these are unsupported by Microsoft. </div>
<div>
<br /></div>
<div>
A while ago, I wrote a couple of SSMS Add-ins for a few missing features that really bugged me, namely; code formatting, scripting data and schema (I know you can do it, but not from a right click on a table) and a versioning Add-in (this tracked each schema change and showed it in SSMS).</div>
<div>
<br /></div>
<div>
I stopped working on these a while ago, but after SQLBits, I've decided to dust off the code I uploaded into CodePlex and pick up where I left off.</div>
<div>
<br /></div>
So I put a request for new features on twitter, I got the following requests;<br />
<div>
<div style="text-align: left;">
1) Cats (I assume the musical)<br />
2) Calendar with community events in it<br />
3) Porn<br />
4) To produce server build documentation<br />
5) A quick way of seeing all the extended properties on a table and all its columns. And editing them!<br />
6) Some way of indicating the IDENTITY column if there is one?<br />
7) Something that shows the partitioning wouldn't go amiss either and the age of the stats<br />
8) Size of the table in Kb/Mb? Same with the indexes?<br />
9) Is it possible to see number of table reads/scans for a particular table?<br />
10) A feature that says "Please remove this software from your computer as you clearly have not idea what you are doing!"? I would prefer something that gives electric shocks as well but I think that Amnesty International and the unions may have object to that!!</div>
<br /></div>
<div>
Feel free to add more features requests to the blog comments.<br />
<br /></div>
</div>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7485373130684237832.post-6426238848134583762014-07-27T22:37:00.003+01:002014-07-27T22:37:24.875+01:00Recharging my SQL Batteries<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: Helvetica; font-size: 13px;">I went to SQLBits ( the biggest SQL Server Conference in Europe) last week and came back with two things, 1) a sore knee and 2) my SQL Batteries being recharged. (Its just under 10 weeks since I broke my leg)</span><br />
<div style="font-family: Helvetica; font-size: 13px;">
<br /></div>
<div style="font-family: Helvetica; font-size: 13px;">
Last year I chaired SQL Relay, we (the SQL Relay committee) put on 10 events up and down the country. If you think it sounds like a lot of work, it was!! But we pulled it off together. I am massively proud of everyone involved, I can’t remember the numbers, but we had over 1000 attendees - without the helpers, sponsors and attendees we would not have pulled it off.</div>
<div style="font-family: Helvetica; font-size: 13px;">
<br /></div>
<div style="font-family: Helvetica; font-size: 13px;">
But its was really draining…</div>
<div style="font-family: Helvetica; font-size: 13px;">
<br /></div>
<div style="font-family: Helvetica; font-size: 13px;">
So now, I'm feeling recharged, refreshed and ready to go... I've got a number of things planned, so watch this space.. </div>
<div style="font-family: Helvetica; font-size: 13px;">
<br /></div>
<div style="font-family: Helvetica; font-size: 13px;">
<br /></div>
<div style="font-family: Helvetica; font-size: 13px;">
<br /></div>
<div style="font-family: Helvetica; font-size: 13px;">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-11834978469073461832014-05-23T08:21:00.001+01:002014-05-23T08:21:15.273+01:00Broken Leg... <div dir="ltr" style="text-align: left;" trbidi="on">
Firstly, let me answer a few questions..<br />
<br />
<div>
Yes - it hurt (a lot).</div>
<div>
Yes - it still hurts.</div>
<div>
Yes- the pain killers do help.</div>
<div>
3 months.</div>
<div>
Judo - I was fighting and landed on my knee. </div>
<div>
Yes - I may go back to Judo.</div>
<div>
Yes - Lots of clips/staples.</div>
<div>
I've got a metal plate and some screws.</div>
<div>
No - they won't come out, they stay in.</div>
<div>
Yes - its a cool scar and yes, you can have a look.<br />
<br /></div>
<div>
I think that just about covers everything? :-)<br />
<br />
Now for the pictures...<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtQ_0BNCNfO8SKB8jGn-5npX1Z37i-0eYyGWtHUZPJJKaaxAbXvQ_t_8eEzi0cyzUlGj4bUNma9Y0_MLxPb0AtVugkPiTp49tN4I77AKLOAtEx3hDX2Ub4dbiYSgjFkeeK4e_F78vxTUgc/s1600/IMG_1910.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtQ_0BNCNfO8SKB8jGn-5npX1Z37i-0eYyGWtHUZPJJKaaxAbXvQ_t_8eEzi0cyzUlGj4bUNma9Y0_MLxPb0AtVugkPiTp49tN4I77AKLOAtEx3hDX2Ub4dbiYSgjFkeeK4e_F78vxTUgc/s1600/IMG_1910.jpg" height="240" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-bT2C-_a-Gdj7MneY2y75eEc5SldKqVta82xXlzep5RLyOXZSAy1myU3oFvK_bLlpPw-BSYa9kvA2UizJRiuj7twKtx80iLvC2xM8JTZBWkmOQhmHyPP5ZfzPqDxW8gP-hc6ngDpNJOfX/s1600/IMG_1911.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-bT2C-_a-Gdj7MneY2y75eEc5SldKqVta82xXlzep5RLyOXZSAy1myU3oFvK_bLlpPw-BSYa9kvA2UizJRiuj7twKtx80iLvC2xM8JTZBWkmOQhmHyPP5ZfzPqDxW8gP-hc6ngDpNJOfX/s1600/IMG_1911.jpg" height="240" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgw-7XDfqQTGkKeQnWfakJ8yWdNDzCNuHmAlQsDHkqfaL69DiwpdTdfLAveV-p8GIbVuEDwwUh-GnoelCb3JZMSkCTzPECkyueGlWpUOLZPF5sxg-WCtpxh_hwdSqnerrZEsRMnvK51Egx7/s1600/IMG_1912.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgw-7XDfqQTGkKeQnWfakJ8yWdNDzCNuHmAlQsDHkqfaL69DiwpdTdfLAveV-p8GIbVuEDwwUh-GnoelCb3JZMSkCTzPECkyueGlWpUOLZPF5sxg-WCtpxh_hwdSqnerrZEsRMnvK51Egx7/s1600/IMG_1912.jpg" height="240" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br /></div>
<div>
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-42025013037582360972013-07-11T20:00:00.001+01:002013-07-11T20:00:38.147+01:00Question: When is a columnstore index not a columnstore index?<p>Answer: </p> <p>When its a rowstore index.</p> <p>or</p> <p>When its not been rebuilt.</p> <p> </p> <p>Explanation:</p> <p>The answer is on <a href="http://msdn.microsoft.com/en-us/library/dn223749(v=sql.120).aspx" target="_blank">MSDN</a> – “The updateable columnstore first inserts new data into an <strong>OPEN</strong> rowgroup, which is in <strong>rowstore</strong> format” –> Yes, rowstore, not column store.</p> <p>MSDN says re-organising the index will put it in columnstore format, but in CTP1 this doesn’t work. You need to rebuild the index, not a problem because we are using developer edition (or enterprise edition).</p> <p>I’ve blogged here what happens when you insert into a column store index <a href="http://tsqltidy.blogspot.co.uk/2013/07/column-store-index-life-cycle.html" target="_blank">here</a></p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-73797493337188619732013-07-09T00:55:00.001+01:002013-07-09T00:55:08.059+01:00Column Store Index Life Cycle<p>In my series on the Column Store Index, I thought I would blog on what happens when you insert/ delete into a column store index.</p> <p>1) Lets insert some rows into a table with a column store index.</p> <p><a href="http://lh4.ggpht.com/-AeC2C09zmHk/UdtRQ59x-TI/AAAAAAAABH8/AKms9qhKmrU/s1600-h/image%25255B3%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh6.ggpht.com/-E4TH9PWQLIo/UdtRRny81ZI/AAAAAAAABIE/Ow9XhBW8oJo/image_thumb%25255B1%25255D.png?imgmax=800" width="516" height="143"></a></p> <p>2) Rebuild the Index. The state of index changes to Compressed from Open and size_in_bytes is populated.</p> <p><a href="http://lh3.ggpht.com/-ca7iwupO6rw/UdtRRzUQLFI/AAAAAAAABIM/Tz_eCK5vzbk/s1600-h/image%25255B7%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh4.ggpht.com/-_7LfW4al_rY/UdtRSm5i9iI/AAAAAAAABIU/jD6tkGHcxek/image_thumb%25255B3%25255D.png?imgmax=800" width="512" height="146"></a></p> <p>3) Insert some more rows. We now have two rows, one ‘OPEN’ and second ‘COMPRESSED’</p> <p><a href="http://lh4.ggpht.com/-jdcckBFuo6o/UdtRTNFIRQI/AAAAAAAABIc/ILxYTfAS46A/s1600-h/image%25255B11%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh6.ggpht.com/-sLqBHRmEkSs/UdtRTnM0xeI/AAAAAAAABIk/7i6FMai-kWo/image_thumb%25255B5%25255D.png?imgmax=800" width="517" height="156"></a></p> <p>4) Delete some rows. The deleted rows appear to have come from the ‘COMPRESSED’ row.</p> <p><a href="http://lh3.ggpht.com/-bjUI72tHLlY/UdtRUAT3E8I/AAAAAAAABIs/GT-PJPxhc2g/s1600-h/image%25255B15%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh5.ggpht.com/-hq_VWeAnMBg/UdtRUgunZWI/AAAAAAAABI0/IfS60Bhl3RA/image_thumb%25255B7%25255D.png?imgmax=800" width="515" height="159"></a></p> <p>5) Rebuild the index again.</p> <p><a href="http://lh3.ggpht.com/-_X2bWgeM_F8/UdtRVAwzt7I/AAAAAAAABI8/vSx16fb_uks/s1600-h/image%25255B19%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh3.ggpht.com/-Pfhq-lPOQxI/UdtRVu8hjnI/AAAAAAAABJE/48JkRLI72Eo/image_thumb%25255B9%25255D.png?imgmax=800" width="509" height="145"></a></p> <p> </p> <p>6) When I updated 1 row in the COMPRESSED table, the engine deleted the row and added a new row in the OPEN / delta table. </p> <p> </p> <p><a href="http://lh6.ggpht.com/-6OL0A0ePZyQ/UdtRWKzeroI/AAAAAAAABJM/NKmLuKE4uRY/s1600-h/image%25255B23%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh5.ggpht.com/-rNusZPNNOFk/UdtRWliHSaI/AAAAAAAABJU/1YLqCee-McI/image_thumb%25255B11%25255D.png?imgmax=800" width="501" height="108"></a></p> <p>The page on MSDN about the <font size="2">sys.column_store_row_groups system table</font> <a href="http://msdn.microsoft.com/en-us/library/dn223749(v=sql.120).aspx">http://msdn.microsoft.com/en-us/library/dn223749(v=sql.120).aspx</a> , explains why the 2nd table / delta table or delta row set is used , how and when data is moved from open of the threee states; ‘OPEN’,’COMPRESSED' and ‘CLOSED’ – I’ve not seen ‘CLOSED’ yet.</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-30117348775796017212013-07-09T00:26:00.001+01:002013-07-09T00:26:04.291+01:00Clustered Column store index recap<p>Last week I blogged on the Clustered Column store index, I’ve been playing with it – its very early days, as its a feature of SQL2014 CTP1.</p> <p>Just to recap. I noticed that something wasn’t working as I expected.</p> <p><a href="http://lh6.ggpht.com/-8QV0IUjDU3Y/UdtKgMF2i9I/AAAAAAAABHE/zLQTWPJ50Ow/s1600-h/image%25255B13%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh5.ggpht.com/-28uI_xmUtds/UdtKg6GKk9I/AAAAAAAABHM/TP8SKUlXttE/image_thumb%25255B5%25255D.png?imgmax=800" width="404" height="329"></a></p> <p>The number of rows returned from the report ‘Disk usage by table’ is incorrect, shown by the top results set, the correct number is shown from select count (*) query and the select from sys.partitions.</p> <p>Also notice on sys.partitions, the compression description.</p> <p><a href="http://lh5.ggpht.com/-lJTFk_AgoVY/UdtKhBbxizI/AAAAAAAABHU/txCwX97kvq0/s1600-h/image%25255B8%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh4.ggpht.com/-z8DBGxqcB9A/UdtKh9NRVpI/AAAAAAAABHc/ybyz7b8zdDI/image_thumb%25255B2%25255D.png?imgmax=800" width="244" height="123"></a></p> <p>So how do I get the standard report to show the right data? </p> <p>Well, restarting the instance doesn’t help. </p> <p>But what about rebuilding / re-organising the index? Re-organising the index does nothing, but rebuilding the index works!</p> <p><a href="http://lh6.ggpht.com/-DkwM55BIdrg/UdtKiAWyXXI/AAAAAAAABHk/O0Nnd5VvMN8/s1600-h/image%25255B12%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh4.ggpht.com/-a40Ust8FSTU/UdtKilnOlsI/AAAAAAAABHs/lZV4dFQmOlY/image_thumb%25255B4%25255D.png?imgmax=800" width="350" height="235"></a></p> <p>All the counts are returning the expected number of rows, now everything is alright with the world.</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-10162423495405845652013-06-26T21:24:00.001+01:002013-06-26T21:24:39.439+01:00Very interesting things about updateable column store indexes<p>After more digging, I’ve found a link on msdn to information about the new system table sys.column_store_row_groups. <a href="http://msdn.microsoft.com/en-us/library/dn223749(v=sql.120).aspx">http://msdn.microsoft.com/en-us/library/dn223749(v=sql.120).aspx</a></p> <p>This bit “The hobt_id for delta row groups, or NULL if the row group type is not delta. A delta row group is a read/write row group that is accepting new records. A delta row group has the <strong>OPEN</strong> status. A delta row group is still in rowstore format and has not been compressed to columnstore format.”</p> <p>So this sounds like there are still two tables [or row groups], the delta row group which you can read and write into and a 2nd row group which is compressed. </p> <p>This is the work-around people have been using with the non-updateable column store indexes to make to work like they are updateable, but its happening behind the scenes. </p> <p> </p> <p>Very very nice.</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-33313726912827121092013-06-26T21:06:00.001+01:002013-06-26T21:06:18.115+01:00More interesting things about the Clustered Column store index..<p>I’ve previously blogged on some <a href="http://tsqltidy.blogspot.co.uk/2013/06/interesting-thing-about-updateable.html" target="_blank">interesting things about the clustered column store index</a> or CCSI for short.</p> <p>I’ve found my CCSI in an internal table. sys.Column_store_row_groups</p> <p><a href="http://lh4.ggpht.com/-Vrg48RQ1oBY/UctJqqZ-lbI/AAAAAAAABDk/3iSJkxF7iaw/s1600-h/image%25255B3%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh3.ggpht.com/-kekSlHvolYw/UctJrWbeNbI/AAAAAAAABDs/l4aqnbfGHrY/image_thumb%25255B1%25255D.png?imgmax=800" width="522" height="136"></a></p> <p>Noticed the size_in_byte…NULL </p> <p>Just for fun, I tried to create a 2nd column store index on the same table. (Non-clustered of course)</p> <p><a href="http://lh4.ggpht.com/-SFlO-xaXbl4/UctJsAhYtpI/AAAAAAAABD0/oWmCYGjSk3M/s1600-h/image%25255B8%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh3.ggpht.com/-ed7L5qdjSOQ/UctJs6CQ8kI/AAAAAAAABD8/FASu5DKpLGY/image_thumb%25255B4%25255D.png?imgmax=800" width="506" height="347"></a></p> <p>So we can’t add a non-clustered column store index (NCCSI) to a table that already has a CCSI.</p> <p>But can we add two NCCSI to a table? The answer is no, but the UI doesn’t let you get that far. Its non-selectable.. interesting..</p> <p><a href="http://lh5.ggpht.com/-DWv4fBBsr_c/UctJtf9Uj7I/AAAAAAAABEE/Je-glm6jjxs/s1600-h/image%25255B12%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh6.ggpht.com/-Z1g2qzwsQzg/UctJuOxqkCI/AAAAAAAABEM/4ygYPX5EprA/image_thumb%25255B6%25255D.png?imgmax=800" width="411" height="265"></a></p> <p>And more digging….</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-68201282669053934662013-06-26T19:50:00.001+01:002013-06-26T19:50:48.399+01:00Interesting thing about updateable Clustered Column Store Index<p>I downloaded SQL Server 2014 CPT1 last night and I’ve started playing with it.</p> <p>I’m really interested in the updateable clustered column store index, so I thought I would see if it works in the CTP1 (not all features are released in the CTPs)</p> <p>I created two identical tables, added a Clustered Column store index to one of them, and inserted 15000 rows into both of them.</p> <p>Guess what, it only bloody worked! Excellent! Happy bunny.</p> <p>So the next step, how does it work? While looking at the IO for the insert, I stumbled on this..</p> <p><a href="http://lh5.ggpht.com/-DmDRu7SQu9Q/Ucs39ntTJnI/AAAAAAAABCs/XoIb0KPYym8/s1600-h/image%25255B4%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh4.ggpht.com/--d54mA97-9E/Ucs3-0PZArI/AAAAAAAABC0/dtl54g-ofv0/image_thumb%25255B2%25255D.png?imgmax=800" width="488" height="193"></a></p> <p>TestTB_1 has 15,000 rows and TestTB_2 has 0 rows… Wait a second, that’s not right.</p> <p><a href="http://lh5.ggpht.com/-n2DotdHH1Aw/Ucs3_kf3UeI/AAAAAAAABC8/Br4z8nyl-j8/s1600-h/image%25255B7%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh5.ggpht.com/-oFyXtc_V0IQ/Ucs4AFCdb3I/AAAAAAAABDE/NPwQDSAzkUU/image_thumb%25255B3%25255D.png?imgmax=800" width="229" height="244"></a></p> <p>No – There are 15,000 records in both tables.</p> <p><a href="http://lh6.ggpht.com/-I5EKWo9b3QM/Ucs4AyfXmvI/AAAAAAAABDM/HEnW-S4KSLc/s1600-h/image%25255B11%25255D.png"><img title="image" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" border="0" alt="image" src="http://lh3.ggpht.com/-8r_0LBrrDwg/Ucs4BtchQMI/AAAAAAAABDU/0njOKvWV7jM/image_thumb%25255B5%25255D.png?imgmax=800" width="474" height="206"></a> </p> <p>Wow – check out the logical reads,physical reads…etc…etc..</p> <p>All coming back as 0 – I guess the column store engine isnt reporting back in the same way the normal engine is.</p> <p>This will get fixed at some point, no doubt, but the fact that the column store index was updated is so cool…</p> <p>I’m going to do some more digging now…</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-41622303143623057722013-06-10T19:03:00.001+01:002013-06-10T19:03:27.171+01:00Going to SQL Relay?<p>Going to SQL Relay? Show some support and impress your friends and colleagues with these two badges. Not going to SQL Relay? Why not! Go to the <a href="http://www.SQLRelay.co.uk" target="_blank">SQL Relay web site</a> and find out where your nearest event is.</p> <p>“I’m speaking at SQL Relay” <p><img src="http://www.SQLRelay.co.uk/images/SQLRelaySpeaking.png"> <p><a href="<a href="http://www.SQLRelay.co.uk">http://www.SQLRelay.co.uk</a>"><img src="<a href="http://www.SQLRelay.co.uk/images/SQLRelaySpeaking.png">http://www.SQLRelay.co.uk/images/SQLRelaySpeaking.png</a>"></a> <p>“I’m going to SQL Relay” <p><img src="http://www.SQLRelay.co.uk/images/SQLRelayGoing.png"> <p><a href="<a href="http://www.SQLRelay.co.uk">http://www.SQLRelay.co.uk</a>"><img src="<a href="http://www.sqlrelay.co.uk/images/SQLRelayGoing.png">http://www.SQLRelay.co.uk/images/SQLRelayGoing.png</a>"></a> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-59766697302433196302013-05-15T17:46:00.001+01:002013-05-15T17:46:03.148+01:00How many rows in that table?<p>How many of us have typed ‘select count(*) from TABLE’ when we want to know how many rows in a table?</p> <p>There is another way, by querying sys.partitions. </p> <p>I’ve compared the performance and IO. </p> <style type="text/css"><br />.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br /><br />.csharpcode pre { margin: 0em; }<br /><br />.csharpcode .rem { color: #008000; }<br /><br />.csharpcode .kwrd { color: #0000ff; }<br /><br />.csharpcode .str { color: #006080; }<br /><br />.csharpcode .op { color: #0000c0; }<br /><br />.csharpcode .preproc { color: #cc6633; }<br /><br />.csharpcode .asp { background-color: #ffff00; }<br /><br />.csharpcode .html { color: #800000; }<br /><br />.csharpcode .attr { color: #ff0000; }<br /><br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br /><br />.csharpcode .lnum { color: #606060; }<br /></style> <div class="csharpcode"> </div> <div class="csharpcode"><pre class="alt"><span class="lnum"> 1: </span><span class="kwrd">SET</span> <span class="kwrd">TRANSACTION</span> <span class="kwrd">ISOLATION</span> <span class="kwrd">LEVEL</span> <span class="kwrd">READ</span> UNCOMMITTED;</pre><pre><span class="lnum"> 2: </span> </pre><pre class="alt"><span class="lnum"> 3: </span><span class="kwrd">SET</span> <span class="kwrd">STATISTICS</span> <span class="kwrd">TIME</span> <span class="kwrd">ON</span>;</pre><pre><span class="lnum"> 4: </span> </pre><pre class="alt"><span class="lnum"> 5: </span><span class="kwrd">SET</span> <span class="kwrd">STATISTICS</span> IO <span class="kwrd">ON</span>;</pre><pre><span class="lnum"> 6: </span> </pre><pre class="alt"><span class="lnum"> 7: </span><span class="kwrd">SELECT</span> <span class="kwrd">COUNT</span>(1)</pre><pre><span class="lnum"> 8: </span><span class="kwrd">FROM</span> MYBIGTABLE</pre><pre class="alt"><span class="lnum"> 9: </span> </pre><pre><span class="lnum"> 10: </span><span class="kwrd">DECLARE</span> @objid <span class="kwrd">AS</span> BIGINT;</pre><pre class="alt"><span class="lnum"> 11: </span> </pre><pre><span class="lnum"> 12: </span><span class="kwrd">SELECT</span> @objid = object_id</pre><pre class="alt"><span class="lnum"> 13: </span><span class="kwrd">FROM</span> sys.tables</pre><pre><span class="lnum"> 14: </span><span class="kwrd">WHERE</span> name = <span class="str">'MYBIGTABLE'</span>;</pre><pre class="alt"><span class="lnum"> 15: </span> </pre><pre><span class="lnum"> 16: </span><span class="kwrd">SELECT</span> <span class="kwrd">SUM</span>(<span class="kwrd">rows</span>)</pre><pre class="alt"><span class="lnum"> 17: </span><span class="kwrd">FROM</span> sys.partitions</pre><pre><span class="lnum"> 18: </span><span class="kwrd">WHERE</span> index_id <span class="kwrd">IN</span> (0, 1)</pre><pre class="alt"><span class="lnum"> 19: </span> <span class="kwrd">AND</span> [object_id] = @objid;</pre><pre><span class="lnum"> 20: </span> </pre><pre class="alt"><span class="lnum"> 21: </span><span class="kwrd">SET</span> <span class="kwrd">STATISTICS</span> <span class="kwrd">TIME</span> <span class="kwrd">OFF</span>;</pre><pre><span class="lnum"> 22: </span> </pre><pre class="alt"><span class="lnum"> 23: </span><span class="kwrd">SET</span> <span class="kwrd">STATISTICS</span> IO <span class="kwrd">OFF</span>; </pre></div><br /><p>The results from STATISTICS IO and TIME are as follows;</p><br /><p>Table 'MYBIGTABLE'. Scan count 1, logical reads 115328, physical reads 0, read-ahead reads 115328, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.</p><br /><p>SQL Server Execution Times:<br> CPU time = 27628 ms, elapsed time = <strong>61186</strong> ms.</p><br /><p>So over a minute.</p><br /><p>For the query on sys.partitions;</p><br /><p>Table 'syssingleobjrefs'. Scan count 1, logical reads 2, physical reads 2, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.<br>Table 'sysidxstats'. Scan count 1, logical reads 2, physical reads 1, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.<br>Table 'sysschobjs'. Scan count 1, logical reads 4, physical reads 2, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.</p><br /><p>SQL Server Execution Times:<br> CPU time = 16 ms, elapsed time = <strong>140</strong> ms.</p><br /><p>(1 row(s) affected)<br>Table 'sysrowsets'. Scan count 1, logical reads 10, physical reads 0, read-ahead reads 7, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.</p><br /><p>SQL Server Execution Times:<br> CPU time = 0 ms, elapsed time = <strong>35</strong> ms.<br></p><br /><p>So 140+35=175ms, so less than a quarter of a second compared with 61 seconds.</p><br /><p>Much much much much much much faster!</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-57389875675540320802013-04-08T16:10:00.001+01:002013-04-08T16:10:48.999+01:00Technology: Why I Hate and Love you so…<p>I word in IT, I love and hate technology with equal passion…</p> <p>Technology makes our lives better, wireless networks, cheap computers, mobile phones that can make calls / play games and make a terrible cup of coffee… We can do more..cheaper.. </p> <p>But its the most frustrating thing in the world, when the iPad doesn’t find the airport printer…What do you do? Reboot everything….if that doesn’t work, setup everything from scratch again…if that doesn’t work? Pray to the God of Calculators… if that doesn’t work??? ? ? ? Hours later… still doesn’t work, even after selling my soul to the God of Calculators….</p> <p>But wait a second, the iPhone can see the airport printer… so its a problem with the iPad.. </p> <p>At that point I give up and print from a PC {wirelessly}– several hours of my life I will never get back…. </p> <p>Viva technology!!</p> Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7485373130684237832.post-49608020238217606142013-04-08T16:02:00.001+01:002013-04-08T16:02:40.205+01:00More Blogging…<p>This is my second post where I state my intention to blog more…’this time is personal’ (tag line from Jaws: The Revenge’ )…</p> <p>Just like everyone else I have blog ideas that fade into nothingness, either I forget it and move on or it takes so long to write something witty and informative that it just gets binned…</p> <p>So I will try and keep then short and sweet, amusing if possible, but unlikely. But most of all, actually blog something.</p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-45843835607849053102012-12-16T22:31:00.002+00:002012-12-16T22:31:35.422+00:0012 days of Geekmas..on the 3rd day<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
Yes, I am a geek and Yes, I'll do almost anything for something geeky :-)<br />
<br /></div>
<a href="http://blogs.msdn.com/b/ukmsdn/" title="UK MSDN"><img src="http://blogs.msdn.com/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-39-66/4338.MSDN-Blog-Badge.jpg" /></a><br />
<div>
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-73330575494279522012-11-27T07:00:00.000+00:002012-11-27T07:00:08.026+00:00#BADSQL 2<div dir="ltr" style="text-align: left;" trbidi="on">
This is my 2nd submission for bad SQL..<br />
<br />
Bad SQL 2:<br />
The dev system has run out of disk space. Lets shrink all the databases, that will free up some space.<br />
<code><br /></code>
<code>EXEC sp_MSForEachDB 'DBCC SHRINKDATABASE (''?'' , 0)'</code><br />
<br />
<code>It might seam like a good idea, but it does apply to EVERY database.</code><br />
DBCC SHRINKDATABASE ('master' , 0) <br />DBCC SHRINKDATABASE ('tempdb' , 0) <br />DBCC SHRINKDATABASE ('model' , 0) <br />DBCC SHRINKDATABASE ('msdb' , 0) <br />DBCC SHRINKDATABASE ('ReportServer' , 0) <br />DBCC SHRINKDATABASE ('ReportServerTempDB' , 0) <br />
…</div>
Unknownnoreply@blogger.com0Norwich, Norfolk, UK52.6308859 1.29735552.5537859 1.1394265000000001 52.707985900000004 1.4552835tag:blogger.com,1999:blog-7485373130684237832.post-67819346058112080782012-11-26T09:53:00.001+00:002012-11-26T13:21:19.233+00:00SQL Event Calendar<p> </p> <p>The SQL event calendar for next year is filing up!! </p> <p>Tell your friends/colleagues and your pets!</p> <p> <p>SQL Santa London (#sqlfaq) 14th December - <a title="http://sqlserverfaq.com/events/452/SQL-Santa-2012.aspx" href="http://sqlserverfaq.com/events/452/SQL-Santa-2012.aspx">http://sqlserverfaq.com/events/452/SQL-Santa-2012.aspx</a> <p>SQL Saturday Exeter (#sqlsat194) 8th-9th March – <a title="http://www.sqlsaturday.com/194/eventhome.aspx" href="http://www.sqlsaturday.com/194/eventhome.aspx">http://www.sqlsaturday.com/194/eventhome.aspx</a> <p>SQLBits XI Nottingham (#sqbits) 2<sup>nd</sup>–4<sup>th</sup> May - <a title="http://sqlbits.com/" href="http://http://sqlbits.com/">http://sqlbits.com/</a> <p>SQL Saturday Scotland Edinburgh (#sqlsatscotland) 7th-8th June - <a title="https://twitter.com/SQLScotland" href="https://twitter.com/SQLScotland">https://twitter.com/SQLScotland</a> <p>SQL Relay – (#sqlrelay) Dates coming up…. <p>SQL Server User Groups (UK Wide) Various dates (#sqlfaq) - <a title="http://sqlserverfaq.com" href="http://sqlserverfaq.com">http://sqlserverfaq.com</a></p> <p>SQL Saturdays (World) Various dates (#sqlpass) <a href="http://sqlsaturday.com">http://sqlsaturday.com</a></p> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-53400066390949119242012-11-26T09:27:00.001+00:002012-11-26T09:54:03.866+00:00Bad SQL, Naughty SQL!<p> </p> <p>During my time as a dev, I’ve done some bad things in SQL, some terrible things that still give me nightmares. </p> <p>But I feel like a bit of therapy and I should share, and perhaps you would like to share too?</p> <p>Bad SQL 1:</p> <p>I think I used it on a dev system that ran out of space. </p> <style type="text/css"><br />.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: consolas, "Courier New", courier, monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br /><br />.csharpcode pre { margin: 0em; }<br /><br />.csharpcode .rem { color: #008000; }<br /><br />.csharpcode .kwrd { color: #0000ff; }<br /><br />.csharpcode .str { color: #006080; }<br /><br />.csharpcode .op { color: #0000c0; }<br /><br />.csharpcode .preproc { color: #cc6633; }<br /><br />.csharpcode .asp { background-color: #ffff00; }<br /><br />.csharpcode .html { color: #800000; }<br /><br />.csharpcode .attr { color: #ff0000; }<br /><br />.csharpcode .alt <br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br /><br />.csharpcode .lnum { color: #606060; }<br /></style> <div class="csharpcode"><pre class="alt"><span class="lnum"> 1: </span><span class="kwrd">EXECUTE</span> sp_MSforeachtable "<span class="kwrd">ALTER</span> <span class="kwrd">TABLE</span> ? REBUILD <span class="kwrd">WITH</span> (DATA_COMPRESSION = page)"; </pre></div><br /><p> <p>Feel free to share your BAD SQL, please post anonymously if you are too ashamed. <img style="border-bottom-style: none; border-left-style: none; border-top-style: none; border-right-style: none" class="wlEmoticon wlEmoticon-smile" alt="Smile" src="http://lh4.ggpht.com/-UWaJhdmEEQY/ULM18SBjG-I/AAAAAAAAAPI/OGvM1nXh6YQ/wlEmoticon-smile%25255B2%25255D.png?imgmax=800"> Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7485373130684237832.post-38061625658621715242012-11-21T20:48:00.001+00:002012-11-21T20:48:44.778+00:00SQLBits XI and SQL Saturday Exeter (194)<p>It never rains but it pours, not one but two SQL conferences for us to get our teeth into. </p> <p>SQLBits is back and in the Midlands, Nottingham to be precise – the home of Robin hood… 2nd-4th May. <a href="http://www.sqlbits.com">www.sqlbits.com</a></p> <p>And SQL Saturday Exeter (192) is taking place on the 9th of March at Jurys Inn Hotel Exeter, Western Way, Exeter <a title="http://www.sqlsaturday.com/194/eventhome.aspx" href="http://www.sqlsaturday.com/194/eventhome.aspx">http://www.sqlsaturday.com/194/eventhome.aspx</a></p> <p>I’ll be there! Hopefully you can be too!</p> Unknownnoreply@blogger.com0