in

SQLServerCentral.com

The largest free SQL Server community.
All Tags » SQL Server 2005 » SQL (RSS)

Browse by Tags

  • Bye Bye FIPS... We Hardly Knew Ye...

    SQL Server has an option called SET FIPS_FLAGGER that many developers don't even know about. This option warns you if your code does not comply with the SQL-92 levels of compliance specified by FIPS 127-2. This used to be a requirement if you wanted to sell your DBMS to the government. Effective...
    Posted to Pseudo-Random (Weblog) by Mike C on 02-18-2008

  • Stop Using OPENXML (Please...)

    As we all know by now, the xml data type is one of the new features introduced in SQL Server 2005. The xml data type has a handy feature for shredding XML data, the nodes() method; but based on newsgroup postings and various articles on SQL Server 2005 XML it seems that developers are still stuck in...
    Posted to Pseudo-Random (Weblog) by Mike C on 01-20-2008

  • "Exact Numerics" Re-visited

    Wow, seems like I have a lot to write about today. I just noticed a blog by SQL Server guru Hugo Kornelis about the difference between "exact" and "approximate" numeric data types. (Hugo's blog entry is here: http://sqlblog.com/blogs/hugo_kornelis/archive/2007/10/17/so-called...
    Posted to Pseudo-Random (Weblog) by Mike C on 10-20-2007

  • The Problem With Joins

    I recently came up against a pretty big problem with outer joins on SQL Server, and thought I'd talk about it a bit. First let me give you a little background on the problem. <Begin Background> It's common in data warehousing and datamarts to "band" data. By "banding"...
    Posted to Pseudo-Random (Weblog) by Mike C on 10-20-2007
Page 1 of 1 (4 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems