Browse by Tags
All Tags »
BOL (RSS)
Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as
Read More...
Recently when I had a task to identify the learning materials (free) and web resources for SQL Server Integration Services (SSIS), then first place I have used is MVP private newsgroups. You will appreciate the immediate help I received from fellow MVPs
Read More...
Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required
Read More...
As we blogged much on Books Online importance and recent changes to availablility of updated books online for SQL Server 2005 under BOL-Sep2007-MSDN-Technet the same update is available to download. Do not forget to update your local copies as it will
Read More...
Still most of the users in SQL Server 2005 are afraid of using SSIS - SQL Server Integration Services for their ETL process and procedures. I would say the newbie users are in luck to obtain help easily on the web by referring to the blogs and forums/newsgroups
Read More...
SQL Server User Education blog on MSDN has this update about SQL Server 2000 BOL Update - Don't forget to update your local version copy with this latest release. You can download the updated SQL Server 2000 Books Online from the Microsoft Download Center.
Read More...
SQL Server version 2005 Books Online aka BOL has been updated by SQL Development Team in September 2007 and not available for download yet. As usual they are awaiting customer feedback from the BOL or via MSDN/Technet pages. Refer in their words: In the
Read More...
Well this is confusing me, this DownloadLink refers SQL Server 2005 Books Online as May 2007 update that can be installed on the machine. But when you search for any content on MSDN library for SQL Server it refers " SQL Server 2005 Books Online (September
Read More...
Yet another update to SQL Server 2005 Books Online, though it states May 2007 update that was released on June 06th 2007! During February 2007 with the release of Service pack 2 Microsoft has updated the BOL content to reflect the changes with SP2. For
Read More...
You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that
Read More...
Here is another LiveLink that helps you to search the SQL Server books online on web without having them installed on your machine. Thanks Quimbo for the reference.
Read More...
As a SQL Server user have you ever looked at 'How do I....' topics in Books online? I'm afraid not many will be interested to look at it, I know if you are an expert in SQL Server then visitng BOL will be quicker for you to look for what you need. For
Read More...
Microsoft has invested fair amount of time in providing 'sensible' documentation or references since last few years as compared to the initial windows days. Recently with the Trustoworthy Computing intiative has made the product documentation a lot better,
Read More...
I have written an article explaining how effectivley you can take help of SQL Server 2005 books onilne here . I'm a big fan of BOL that has given me relevant first hand help whenever needed.
Read More...
In SQL Server 2000 for index defragmentation DBCC DBREINDEX and DBCC INDEXDEFRAG statements are used, as you are aware defragmentation on table does not yield performance gains in every case. Every scenario is different. Similarly, determining when you
Read More...