tag:blogger.com,1999:blog-5941051Sat, 28 Jul 2012 15:03:06 +0000debugxmlbooks onlinewindows server 2008msdnreportssql server 2000personalmemory managementsql server katmaidynamicoptimizerbest practicescommunitymigrationDatabase Professionalssql server enginememorydiskpartservice packsp2sql server2005virtual serversqliosimdevdayssql server 2008iotechedVisual Studio Team Edition for Database Professionalslimitationpowershellservice pack 3visual studio 2005service pack 2windowst-sql programmingdatabase engineperformancebpahotfixcounterssql server 2005blogsvistawindows vistaMy long term memory for SQL Server related information.http://dis4ea.blogspot.com/noreply@blogger.com (WesleyB)Blogger369125tag:blogger.com,1999:blog-5941051.post-734957862130612835Fri, 16 May 2008 14:44:00 +00002008-05-16T16:55:53.889+02:00personalFor reasons that may be clear from the address this blog will move to http://blogs.msdn.com/wesleyb/.I hope you will all continue to read my blog on this new address!http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/71qqC80aV_4/this-blog-will-move.htmlnoreply@blogger.com (WesleyB)3<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/71qqC80aV_4" height="1" width="1"/>http://dis4ea.blogspot.com/2008/05/this-blog-will-move.htmltag:blogger.com,1999:blog-5941051.post-303838665949845105Thu, 08 May 2008 18:02:00 +00002008-05-08T20:46:07.037+02:00windows server 2008sql server 2008SQL Server 2008 has not yet been released but nevertheless there are already some test results from the CTP versions. Do note that the performance will probably improve even more when the final product arrives but the results today are already quite amazing. They can be found on https://www.microsoft.com/sqlserver/2008/en/us/benchmarks.aspx.Apart from the performance improvements you get by http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/Dez29t0V-pI/sql-server-2008-performance.htmlnoreply@blogger.com (WesleyB)2<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/Dez29t0V-pI" height="1" width="1"/>http://dis4ea.blogspot.com/2008/05/sql-server-2008-performance.htmltag:blogger.com,1999:blog-5941051.post-9050767298413825767Sun, 27 Apr 2008 19:36:00 +00002008-04-28T10:00:11.783+02:00sql server 2005hotfixservice pack 3Those of you who read my blog regularly may have noticed the previous post and maybe more important the comments on this post.Somehow I think we were not the only ones having this questions and remarks. As a follow-up please read the following blog posts as they are very relevant to the discussion.First of all there is the Self-Service hotfix which is explained here. This allows you to download http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/sw3nf3EQU2s/self-service-hotfixes.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/sw3nf3EQU2s" height="1" width="1"/>http://dis4ea.blogspot.com/2008/04/self-service-hotfixes.htmltag:blogger.com,1999:blog-5941051.post-8258125028618023659Thu, 17 Apr 2008 18:10:00 +00002008-04-17T20:51:21.845+02:00service pack 2sql server 2005hotfixservice pack 3The guys @ Microsoft have been busy improving the quality of SQL Server even more.First of all CU7 was released (Build 3239) here.As usual this means CU8 has been announced here.I know there has been a lot of requests from the customers to release Service Pack 3 for SQL Server 2005. Although I see the benefits in the Incremental Servicing Model many people like the "certainty" of a good old http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/lMkUnAsSc7g/sql-server-2005-sp2-cumulative-hotfix.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/lMkUnAsSc7g" height="1" width="1"/>http://dis4ea.blogspot.com/2008/04/sql-server-2005-sp2-cumulative-hotfix.htmltag:blogger.com,1999:blog-5941051.post-4892291404089566201Mon, 14 Apr 2008 18:49:00 +00002008-04-15T20:21:24.976+02:00sql server 2005t-sql programmingsql server engineThere are many myths surrounding table variables and one of the most common is probably the 'in memory' story. There are however a couple of other interesting facts about temp variables which you should also know about. The guys from the Storage Engine have an excellent post about table variables so you definitely have to read it. One of the things that caught my eye in the post was the fact thathttp://feedproxy.google.com/~r/Dis4easSqlBlog/~3/WYww53UieOo/table-variable-vs-parallelism.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/WYww53UieOo" height="1" width="1"/>http://dis4ea.blogspot.com/2008/04/table-variable-vs-parallelism.htmltag:blogger.com,1999:blog-5941051.post-7157738016588794206Sat, 05 Apr 2008 06:45:00 +00002008-04-05T08:47:01.894+02:00communityIt looks like I maybe convinced another (ex) colleague to start blogging.Welcome to the blogginghood Egon ;-)http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/TPrP2PCyARs/sql-server-area.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/TPrP2PCyARs" height="1" width="1"/>http://dis4ea.blogspot.com/2008/04/sql-server-area.htmltag:blogger.com,1999:blog-5941051.post-6724319605288370346Wed, 19 Mar 2008 19:17:00 +00002008-03-19T20:23:07.150+01:00sql server engineioA question I get asked quite a lot is "how many files / filegroups should my database have?". As we all know there is only one right answer to all of life's questions and that is: "it depends!". Lucky for us the guys from the SQLCAT team have taken the time to explain a little how to evaluate how many files you need for specific workloads. In the first post they talk about OLAP environments and http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/QrNL9ixmhco/how-many-files-should-my-database-have.htmlnoreply@blogger.com (WesleyB)3<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/QrNL9ixmhco" height="1" width="1"/>http://dis4ea.blogspot.com/2008/03/how-many-files-should-my-database-have.htmltag:blogger.com,1999:blog-5941051.post-3881661166186847921Thu, 06 Mar 2008 19:30:00 +00002008-03-06T20:52:46.143+01:00communityThe Techdays (and launch event) are coming pretty close so get ready for some nice sessions about SQL Server 2008, Windows 2008, Visual Studio 2008, Hyper-V and more!You can always pay me a visit at the Euricom stand. Tip: There will be "champagne" on Thurday ;-)http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/zug2n9z2HZk/techdays-2008-belgium.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/zug2n9z2HZk" height="1" width="1"/>http://dis4ea.blogspot.com/2008/03/techdays-2008-belgium.htmltag:blogger.com,1999:blog-5941051.post-6524434897814022262Wed, 20 Feb 2008 09:48:00 +00002008-02-20T10:53:39.534+01:00sql server katmaisql server 2008In case you have not noticed, the February CTP is out there!Go get it!http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/3l-3N2e2HfQ/sql-server-2008-february-ctp-ctp6.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/3l-3N2e2HfQ" height="1" width="1"/>http://dis4ea.blogspot.com/2008/02/sql-server-2008-february-ctp-ctp6.htmltag:blogger.com,1999:blog-5941051.post-7126198191035116113Tue, 19 Feb 2008 22:24:00 +00002008-02-20T16:26:33.005+01:00service pack 2sql server 2005hotfixWith every release comes a new announcement of course.http://support.microsoft.com/kb/949095/http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/P1de989jCt8/sql-server-2005-sp2-cumulative-hotfix_19.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/P1de989jCt8" height="1" width="1"/>http://dis4ea.blogspot.com/2008/02/sql-server-2005-sp2-cumulative-hotfix_19.htmltag:blogger.com,1999:blog-5941051.post-7868725419679159363Tue, 19 Feb 2008 22:21:00 +00002008-02-20T16:23:54.601+01:00service pack 2sql server 2005hotfixIt is out there! The build number is 3228.http://support.microsoft.com/kb/946608/http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/Ef7HeLT7BBw/sql-server-2005-sp2-cumulative-hotfix.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/Ef7HeLT7BBw" height="1" width="1"/>http://dis4ea.blogspot.com/2008/02/sql-server-2005-sp2-cumulative-hotfix.htmltag:blogger.com,1999:blog-5941051.post-1542507621916520572Sat, 16 Feb 2008 09:21:00 +00002008-02-16T10:27:21.626+01:00sql server 2000sql server 2005One last reminder that the mainstream support for SQL Server 2000 SP4 and SQL Server 2005 SP1 will end on 08/04/2008.For more information about this visit the guys from Microsoft SQL Server Release Services.http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/MpLzRFss2j0/mainstream-support-on-sql-server-2000.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/MpLzRFss2j0" height="1" width="1"/>http://dis4ea.blogspot.com/2008/02/mainstream-support-on-sql-server-2000.htmltag:blogger.com,1999:blog-5941051.post-6897414754867681420Tue, 05 Feb 2008 20:05:00 +00002008-02-05T21:13:15.361+01:00windows server 2008windows vistaThis time I am not just trying to draw your attention to this post, it has really RTM'ed!More information here.Together with the announcement of Windows Server 2008 they have also announced Windows Vista SP1 here.They will probably be available somewhere next month so just a little more patience.http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/l-GZL-d1LGk/windows-server-2008-rtm.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/l-GZL-d1LGk" height="1" width="1"/>http://dis4ea.blogspot.com/2008/02/windows-server-2008-rtm.htmltag:blogger.com,1999:blog-5941051.post-9086475431624412406Mon, 04 Feb 2008 20:55:00 +00002008-02-04T22:00:19.235+01:00sql servercommunityThe nice people from the SQL Server Customer Advisory Team have started a new website called SQLCAT.com.It is a great source of information for large SQL Server implementations so make sure to check it out!http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/I-rqBIPBxDU/sqlcat-site.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/I-rqBIPBxDU" height="1" width="1"/>http://dis4ea.blogspot.com/2008/02/sqlcat-site.htmltag:blogger.com,1999:blog-5941051.post-7712438842175721699Mon, 28 Jan 2008 21:32:00 +00002008-02-09T13:26:44.643+01:00communitySome sad news on this blog. Ken Henderson was one of the SQL Server gurus who wrote wonderful books and had a real passion for SQL Server. We will sure miss him in the community. My condolences to his family, friends and colleagues. We will see you in the next life khen1234 :'(Update: Ken's sisters have asked for stories about Ken you would like to share. Please check out this post for more http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/GSGdVfJDXJg/remembering-ken-henderson.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/GSGdVfJDXJg" height="1" width="1"/>http://dis4ea.blogspot.com/2008/01/remembering-ken-henderson.htmltag:blogger.com,1999:blog-5941051.post-3797463003723261989Sat, 26 Jan 2008 21:19:00 +00002008-01-26T13:56:34.390+01:00sql server katmaisql server 2008I got your attention didn't I?Unfortunately the news in this post is not as good. The guys from the Data Platform Insider blog posted a 'Roadmap Clarification' for SQL Server 2008 and I am afraid it has a sad statement: "Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release candidate (RC) in Q2 calendar year 2008, with final Release to http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/Av1Hghj5N9g/sql-server-2008-rtm.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/Av1Hghj5N9g" height="1" width="1"/>http://dis4ea.blogspot.com/2008/01/sql-server-2008-rtm.htmltag:blogger.com,1999:blog-5941051.post-1699893089436943893Mon, 21 Jan 2008 19:53:00 +00002008-01-21T20:58:36.156+01:00sql server 2005In case you have not noticed yet, the SQLCat team has released a new version of the Best Practices Analyzer. Among other things it contains 60+ new rules and the Analysis Services rules have been updated so they match the Best Practices warnings in BIDS 2008.More information can be found here and the download can be found here.http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/r9i76_jECX0/sql-server-2005-best-practices-analyzer.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/r9i76_jECX0" height="1" width="1"/>http://dis4ea.blogspot.com/2008/01/sql-server-2005-best-practices-analyzer.htmltag:blogger.com,1999:blog-5941051.post-2344275082035901992Sat, 12 Jan 2008 08:58:00 +00002008-01-12T10:20:01.111+01:00sql server katmaisql server 2008I was giving a presentation on the new programmability features in SQL Server 2008 when the following question popped up:"Does the MERGE statement support multiple WHEN MATCHED clauses?"As you know it is possible to say "WHEN MATCHED AND myField = 0 THEN...", so it would make sense to have multiple WHEN MATCHED statements because depending on the criteria you could have different actions. Since http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/vyyKKZ7Ztf4/question-about-and-answer-to-merge.htmlnoreply@blogger.com (WesleyB)1<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/vyyKKZ7Ztf4" height="1" width="1"/>http://dis4ea.blogspot.com/2008/01/question-about-and-answer-to-merge.htmltag:blogger.com,1999:blog-5941051.post-2680346036345613681Fri, 04 Jan 2008 20:33:00 +00002008-01-04T21:36:58.505+01:00service pack 2sql server 2005hotfixBecause CU5 is released here is the next announcement.The question is of course how many of you have already implemented CU5?http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/m4v2L84VTVw/sql-server-2005-sp2-cumulative-hotfix.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/m4v2L84VTVw" height="1" width="1"/>http://dis4ea.blogspot.com/2008/01/sql-server-2005-sp2-cumulative-hotfix.htmltag:blogger.com,1999:blog-5941051.post-4514941335274127419Wed, 19 Dec 2007 08:32:00 +00002007-12-19T09:38:40.366+01:00service pack 2sql server 2005hotfixIt is out there! The build number is 3215.http://support.microsoft.com/kb/943656/http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/W3iakf0lvXU/sql-server-2005-sp2-cumulative-hotfix.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/W3iakf0lvXU" height="1" width="1"/>http://dis4ea.blogspot.com/2007/12/sql-server-2005-sp2-cumulative-hotfix.htmltag:blogger.com,1999:blog-5941051.post-391496546579653956Mon, 10 Dec 2007 19:58:00 +00002007-12-10T21:55:41.413+01:00sql server 2005t-sql programmingsql server engineWith every release there are really some features that you seem to miss, maybe because they are small or maybe because you just do not use that functionality that often.That is how I recently stumbled upon a nice feature that has been added in SQL Server 2005 but I had never seen before.EXEC AT allows you to execute queries on a linked server just like OPENQUERY and OPENROWSET but with a little http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/ZDTXaaHTMZk/exec-at.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/ZDTXaaHTMZk" height="1" width="1"/>http://dis4ea.blogspot.com/2007/12/exec-at.htmltag:blogger.com,1999:blog-5941051.post-8426755354353311649Tue, 04 Dec 2007 14:21:00 +00002007-12-04T15:25:17.649+01:00sql server 2005books onlineBecause I have a day off my colleague said I should stop working and blog something.Since inspiration comes mostly at work I will keep this one simple.The updated Books Online for SQL Server 2005 are available here.http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/d5I884Y-jQA/sql-server-2005-books-online-september.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/d5I884Y-jQA" height="1" width="1"/>http://dis4ea.blogspot.com/2007/12/sql-server-2005-books-online-september.htmltag:blogger.com,1999:blog-5941051.post-2397021119049883214Mon, 26 Nov 2007 19:53:00 +00002007-11-26T21:43:24.870+01:00sql server 2005sql server engineToday we found a table that was perfect for testing the newsequentialid() default. My colleague killspid thought it might be useful to talk about it and said "Blog it!".This new feature has been added to SQL Server 2005 although it was available in SQL Server 2000 with the addition of an extended stored procedure written by Gert Drapers.The Books Online state the following for the newsequentialidhttp://feedproxy.google.com/~r/Dis4easSqlBlog/~3/m132Jf0G29I/sequential-guids.htmlnoreply@blogger.com (WesleyB)2<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/m132Jf0G29I" height="1" width="1"/>http://dis4ea.blogspot.com/2007/11/sequential-guids.htmltag:blogger.com,1999:blog-5941051.post-7511724341131573362Tue, 20 Nov 2007 19:46:00 +00002007-11-20T21:35:14.738+01:00sql server katmaisql server 2008First of all I am very glad that 2 of my requests seem to have made it to SQL Server 2008:Cumulative waitstats info https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=275212A central registered server list https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=136596Of course there is a lot more in this CTP 5 and the first thing you will notice ishttp://feedproxy.google.com/~r/Dis4easSqlBlog/~3/dfnx5bDkLAU/some-new-features-in-sql-server-2008.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/dfnx5bDkLAU" height="1" width="1"/>http://dis4ea.blogspot.com/2007/11/some-new-features-in-sql-server-2008.htmltag:blogger.com,1999:blog-5941051.post-2248783842912993724Mon, 19 Nov 2007 20:18:00 +00002007-11-19T21:22:25.878+01:00sql server katmaisql server 2008Fire up those virtual servers because the latest CTP is out!Get it here:http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=enWhat's new:https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470http://feedproxy.google.com/~r/Dis4easSqlBlog/~3/hNHjCbNjMDE/sql-server-2008-ctp5.htmlnoreply@blogger.com (WesleyB)0<img src="http://feeds.feedburner.com/~r/Dis4easSqlBlog/~4/hNHjCbNjMDE" height="1" width="1"/>http://dis4ea.blogspot.com/2007/11/sql-server-2008-ctp5.html