A lof of time your index will get fragmented over time if you do a lot of updates or inserts and deletes. We will look at an example by creating a table, fragmenting the heck out of it and then doing a reorganize and rebuild on the index. First create this table CREATE TABLE TestIndex (name1 varchar(500) not null,id int not null,userstat int not null, name2 varchar(500) not null, SomeVal uniqueidentifier not null) Now insert 50000 rows
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
Windows Server 2008 R2 will support up to 256 logical processors, up till now Windows only supports 64 logical processors, that means you can’t even run that fancy Intel 80 core chip that they showed a while back. Since I am a SQL Server guy this is going to be interesting, wonder if you can get an execution plan that uses 100+ processors. Imagine you pay per CPU? That would be a ton of money.
Microsoft has released a collection of free charting controls for both ASP.NET and Windows Forms. These controls will only work with the .NET Framework 3.5. These are basically the Dundas Chart controls, Microsoft has acquired Dundas a while back and now you get these for free 🙂 Download links Microsoft Chart Controls for Microsoft .NET Framework 3.5 http://www.microsoft.com/downloads/details.aspx?FamilyId=130F7986-BF49-4FE5-9CA8-910AE6EA442C&displaylang=en Microsoft Chart Controls for .NET Framework Documentation http://www.microsoft.com/downloads/details.aspx?FamilyId=EE8F6F35-B087-4324-9DBA-6DD5E844FD9F&displaylang=en Microsoft Chart Controls Add-on for Microsoft Visual Studio 2008 http://www.
I saw that some people are hitting our site with a search for how to create a sorted view in SQL Server 2008. You all know that in SQL Server 2000 you can create a view and use TOP 100 PERCENT with ORDER By and it will be sorted. Since SQL server 2005 that doesn’t work anymore. I actually never understood the need for sorted views to begin with, how hard is it to do something like this
Dare Obesanjo has made an excellent post: Windows Azure from a Developer’s Perspective To try out Azure you need to be running Windows Server 2008 or Windows Vista with a bunch of prerequisites you can get from running the Microsoft Web Platform installer. Once you have the various prerequisites installed (SQL Server, IIS 7, .NET Framework 3.5, etc) you should then grab the Windows Azure SDK. Users of Visual Studio will also benefit from grabbing the Windows Azure Tools for Visual Studio.
Well, here is the code I came up with to test this. Trying it out seems like the best way. And good code is always self explanatory. using System; using System.Collections.Generic; using System.Linq; using System.Text; using Rhino.Mocks; namespace ConsoleApplication2 { [NUnit.Framework.TestFixture] public class Program { static void Main(string[] args) { var toThrow = new ToThrow(); ICatchThrow catchThrow = new CatchThrow(); toThrow.throwevent += catchThrow.catchthrow; toThrow.voidthrowingevent(""); } public delegate void mydelegate(string param); public class ToThrow { public event mydelegate throwevent; public void voidthrowingevent(string param) { throwevent(param); } } public class CatchThrow : ICatchThrow { public void catchthrow(string param) { Console.
Windows Server 2008 R2 is the first Windows OS platform to go 64-bit only That is right First and foremost, 32-bit is done. History. Archives. Windows Server 2008 R2 is the first Windows OS platform to go 64-bit only, and frankly it was high time. Customers have been unable to purchase a 32-bit server CPU for over two years now, and the advancements in CPU architectures really dictated that we squeeze as much performance out of customers’ hardware purchases as possible.
The Beta version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation Developer Standard Workgroup The build number is 9.00.4028.00 Download SQL Server 2005 Service Pack 3 – Beta here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D22317E1-BC64-4936-A14B-7A632B50A4CA&displaylang=en To obtain SQL Server 2005 SP3 Beta for Express Edition or Express Edition with Advanced Services go here: http://www.
Microsoft SQL Server 2008 Feature Pack October 2008 is available for download. The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of: Redistributable components for SQL Server 2008. Add-on providers for SQL Server 2008. Backward compatibility components for SQL Server 2008. Here is what is available Microsoft ADOMD.NET ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 Analysis Services.
Brad Abrams has on his blog 2 versions of the .NET Framework 4 poster, he has a PDF version and a DeepZoom version. You will need SilverLight for the DeepZoom version Get them both here: http://blogs.msdn.com/brada/archive/2008/10/29/net-framework-4-poster.aspx