-
Recursion in Common Table Expressions (CTE’s), how does it work? How can I use it with the adjacency list model (parent / child columns)? In this blog entry I show how recursion works, how to use it with the adjacency list model and talk about other aspects...
-
One of the things I really enjoy when doing performance tuning on 2005 (I still work on a mix of several SQL 2000 and some SQL 2005) is the sys.dm_db_missing_index* DMVs. As the query processor evaluates queries, it detects if that specific query could...
-
In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...
-
JumpStart 2008 is an event held in Seattle in February. All the content delivered there is now available for everyone (after a quick registration). http://sqlserver2008jumpstart.microsofttraining.com/content/DownloadMaterial.asp?CcpSubsiteID=69§ion...
-
I have always told this in my classes to my students: managing a database is just like driving a car... it means everyone drives a car but few have a proper knowledge of driving rules, they just drive because they learnt how to do it and the rest is pure...
-
Say you have an external file you want to load into your SQL Server database; you need to load – verify – cleanse and insert and at the same time keep a cross reference between the original source file records and the inserted database rows. The OUTPUT...
-
In addition to INFORMATION_SCHEMA VIEWS, in SQL Server 2005, we can use Object Catalog Views to know more informations about the objects Refer this http://msdn.microsoft.com/en-us/library/ms189783.aspx
-
I've just released a new version of SQL Internals Viewer that has support for 2008 sparse columns, a feature introduced in SQL Server 2008 CTP6. There are also a few bug fixes and minor changes. It's available to download from http://www.sqlinternalsviewer...
-
Contest-Results
-
As I've remarked before the profusion of Blogs ( from the various Microsoft teams and individuals ) whilst exposing so much more information then we ever had before also requires you to almost spend all your time just checking every blog you can find...
-
Thankyou to all those who attended my session on 64-bit SQL Server at the UK SQL Server User Group on 17th April 2008. I've just got round to uploading the slidedeck for those of you that have been asking for it. You can download it here: http://coeo...
-
You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...
-
5th June, Thames Valley Park, Reading sees an Operations Day for SQL Server 2008 for Premier customers only. More information: http://sqlblogcasts.com/blogs/thepremiers/archive/2008/04/27/operations-day-for-sql-server-2008-open-for-premier-customers-only...
-
Dear Premier, I am pleased to announce that Premier Field Engineering (PFE) are hosting an Operations Day for SQL Server 2008. The day will provide customers with a wealth of technical information covering a wide range of issues relevant to SQL Server...
-
SQL Server 2008 UK Usergroup London Launch event As part of the SQL Server Launch wave we are holding a usergroup meeting to celebrate the launch (not RTM). We're going to run this as an open session so you'll be able to ask us to cover the areas...