SQL Server Blogs

Voices from the UK SQL Server Community

Search

Page 1 of 2 (15 items) 1 2 Next >
  • SQL 2008 CTP6

    http://download.microsoft.com/download/3/1/5/315b8683-3765-4426-96ec-179360abb82f/Download_Instructions_ENU.htm or http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en Powershell providerFiltered indexes and stats!!!!!!!Data and index compressionLots of other stuff. 
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Wed, Feb 20 2008
  • SQL Server LinkedIn group

    I have created a LinkedIn SQL Server group. Join up.
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Mon, Feb 18 2008
  • Creating a custom data collection in SQL Server 2008

    In the first post, we took a quick look at how data collection works. In this post, we will see how to create custom data collection. To create a custom collection, you must use the stored procedures. In Bill Ramos's web cast, he hints it may stay like this i.e. NO GUI. I tend to doubt it because Microsoft built their empire making hard stuff ...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Fri, Feb 15 2008
  • SQL Server 2008 performance data collection in 5 minutes

    This will be a quick and dirty post on data collection in SQL Server 2008. The next two posts will cover creating custom data collection sets and integrating reporting services. For a deeper understanding of data collections, check out Bill Ramos's web cast. He talks about it in this post. Data collection is basically a separate application that ...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Fri, Feb 15 2008
  • Migrating your SQL Cluster to a new SAN

    There is a nice utility that does a lot of the heavy lifting for you when migrating your cluster to a new SAN. It is ClusterRecovery.exe. It is designed for replacing a failed disk but when you migrate to a new SAN, you have to go through the same steps. It basically moves all of the meta data like dependencies. The utility can be found the Win2k3 ...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Thu, Feb 14 2008
  • 2008 to RTM next week

    Windows Server 2008, that is. '' Windows Server 2008 (and Vista Service Pack 1) are slated to release to manufacturing (RTM) on Feb. 6, according to several sources. That gives the company plenty of time to churn out disks for distribution at the event, which Microsoft executives have characterised as the company's ''biggest enterprise ...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Thu, Jan 31 2008
  • Never use table variables?

    MS pushed tables variables too hard back in 2000 and developers went a little crazy with them. However, we found out that they were not the greatest thing since sliced bread especially when the result set is more that a few records and the query is even mildly complex. The other case we hear for table variables is to avoid recompilations. This ...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Wed, Jan 30 2008
  • SQL Server 2008 RTM delayed until Q3

    '' 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 manufacturing (RTM) of SQL Server 2008 expected in Q3. Our goal is to deliver the highest quality product possible and we simply want to use the time to meet the high ...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Fri, Jan 25 2008
  • The problem with local variables

    Have you ever been writing a query and just cannot get it to use the right index? This could be one of the reasons why. Let's use this query with local variables as our example. declare @Start datetimedeclare @End datetimeselect @Start = '2004-08-01 00:00:00.000'select @End = '2004-07-28 00:00:00.000'select ProductID from ...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Fri, Jan 25 2008
  • SQL Server 2008 Plan Guides from Cache

    Uhoh... I can see some junior developers going crazy with this. One of the things that kept plan guides from being over used was the fact that they are kind of hard :) Well, Microsoft built their empire making hard stuff easy. They do it again with sp_create_plan_guide_from_cache. Let's look at this BOL sample.   USE ...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Fri, Jan 18 2008
Page 1 of 2 (15 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems