THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Documentation   (RSS)
Showing page 4 of 4 (40 total posts)
  • Did You Know? A New SQL Server 2008 Books Online Update is Available

    When I searched for ''sql server 2008 books online update'', the first non-advertising hit I got was labeled August 2008, and I already have a Books Online download for August.     However, when I clicked on the link I was taken to a page to download a brand new January 2009 Update::     So here's the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 2, 2009
  • What time do you have?

    The way in which SQL Server has treated Time has been a very misunderstood subject for as long as I can remember. The largest part of that was the fact that SQL Server was only accurate to 3.33ms. I would like to point you to an excellent article on this and other details surrounding Datetime in SQL Server by Tibor Karaszi found here:  ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 20, 2008
  • Did You Know? You can search the web-only Books Online

    You might be aware (from other bloggers on this site) that there is a new web-only Books Online for SQL Server 2008 available at http://msdn.microsoft.com/en-us/library/dd239407.aspx.  Like Tibor, I prefer a downloadable BOL, partly because I do a lot of research and writing while traveling and I don't always have an internet connection, ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 11, 2008
  • Debug button in SSMS 2008

    How many people are tired of accidentally hitting the toolbar button with the green triangle on it when trying to run a query in the Query Editor only to get into the debug mode?  If you are like me then I bet a lot of you:).  It only seems natural to hit the Green button to run something right?  Especially since it is right next to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 17, 2008
  • Did You Know: Specifying Checkpoint Duration

    I realize probably no one reads Books Online cover to cover, so there are probably lots of little details that easily slip by you. I was introduced to one of the hidden 'features' just last week. Here it is: CHECKPOINT can take a parameter! It's right there in BOL:  CHECKPOINT [ checkpoint_duration ] This parameter allows you to specify ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 29, 2008
  • When a Function is indeed a Constant

    In my last blog post:  http://sqlblog.com/blogs/andrew_kelly/archive/2008/02/27/when-getdate-is-not-a-constant.aspx I mentioned that I ran across a situation in which GETDATE() used in a SELECT statement occasionally returned more than 1 value for the result set. That sparked quite a debate amongst SQL Server programmers who belonged to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on March 1, 2008
  • Getting back to the basics with I/O

           One of the most common trends that I see related to performance & scalability with SQL Server is a poorly configured or implemented storage subsystem. There is a ton of information out there on this subject but in my opinion that is part of the problem.  Too much data is not always a good thing and there ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 13, 2008
  • Exists Vs. Count(*) - The battle never ends...

        I am still amazed at how many of the database applications written today still disregard some basic rules of thumb when it comes to accessing the data. One in particular is the use of COUNT(*) to check to see if there are any rows that match some criteria. The technique of using EXISTS over COUNT(*) has been widely publicized ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 15, 2007
  • Did You Know? It's in the Books Online!

    Did you know you can ALTER an existing column to give it the identity property? If you look up ALTER TABLE in the BOL index, you'll see this: ALTER TABLE table_name   { [ ALTER COLUMN column_name        {DROP DEFAULT |          SET DEFAULT ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 13, 2007
  • SQL Server Samples Blog

    On a private newsgroup I read, the question was asked: ''Samples in or out of the box? For the next release of SQL Server we're thinking of just shipping sample code on the web, instead of shipping on the web and also in the SQL Server box on a CD as we have done in the past.'' And I replied (amongst other things) that it would be nice if ...
    Posted to Louis Davidson (Weblog) by drsql on October 11, 2006
Privacy Statement