Skip to content

shannonlowder.com

Menu
  • About
  • Biml Interrogator Demo
  • Latest Posts
Menu

Tag: DEV

SQL Azure Incompatibilities list

Posted on June 2, 2010September 27, 2010 by slowder

While 99% of what you do in SQL is supported in SQL Azure, there is a small list of things you’ll have to redesign, or at least reconsider before implementing your code on SQL Azure.  The following is a list of items that are well documented, but I want to create a more complete list. …

Continue reading

SQL 102-SELECT * Overhead

Posted on May 12, 2010February 9, 2011 by slowder

How many of you have heard me rant against using “SELECT * FROM tableName”? If you have I’m sure you’ve heard me mention the following reasons why SELECT * is evil. the more data you ask for, the longer it takes to return that data extra paging table locking hinders future attempts to create a…

Continue reading

Microsoft Continues to Support PHP

Posted on April 29, 2010April 29, 2010 by slowder

Microsoft continued their support of PHP by releasing a Community Technology Preview for the SQL Server Driver for PHP 2.0.  With this release PHP developer can use PHP Data Objects with the SQL Server driver!  This will serve to reduce the complexity of targeting multiple databases on the back end.  As I’ve noticed before, Business…

Continue reading

Equals Sub Queries Versus Exists Sub Queries

Posted on April 26, 2010February 9, 2011 by slowder

I’d like to introduce you to the idea that you can replace an equal sub query with an exists sub query. Doing this can change a seek operation to a scan operation. This usually results in a faster query, with fewer resources used. Check out this example using the adventureworks database. USE AdventureWorks GO –…

Continue reading

Sorting Numbers in VarChar field

Posted on April 8, 2010February 9, 2011 by slowder

Over at Experts-Exchange, I saw a question I get every once in a while.  It all has to do with how SQL Server orders data in a VARCHAR column.  SQL Server tries to sort a VARCHAR column in a dictionary order, 0 comes before 1.  The problem is you may have mixed numbers in your…

Continue reading

Migrating Databases to Azure

Posted on April 7, 2010June 10, 2010 by slowder

When converting a database from an older version of Microsoft SQL to Azure, there will be many gotchas along the way.  I’d like to help you learn from the troubles I had along the way, hopefully sparing you a bit of time that was lost during my first conversion. Getting Started I’m going to assume…

Continue reading

Code Review

Posted on June 8, 2009June 29, 2010 by slowder

I’d like to start a new series that will help you learn some of the techniques I’ve used in the past.  Some of these techniques are useful, some aren’t.  Using SQL is a constant learning process.  You have to be willing to look at your solutions and throw out those ideas that no longer work…

Continue reading

INDEX ON partition_scheme_name, filegroup_name, and default

Posted on June 1, 2009February 9, 2011 by slowder

Consider the CREATE INDEX statement below: CREATE INDEX ix_tableName_columnName ON tableName (columnName) ON { partitionSchemeName (columnName) | fileGroupName | default } What’s it all about? Let’s take these one at a time, and dig in a little bit. partitionSchemeName (columnName) Before you can use this option, you have to have your partition scheme defined. Check…

Continue reading

ASC, DESC, and Filtered Views

Posted on May 11, 2009February 9, 2011 by slowder

I know I’ve covered quite a bit of the CREATE INDEX statement, but there is even more to learn. Today I want to cover ASC, DESC, and the WHERE clause for indexes. ASC | DESC By default, indexes are created in ascending (ASC) order. This is fine most of the time. You’re going to be…

Continue reading

SQL 202 – FILLFACTOR and Indexes

Posted on April 6, 2009February 9, 2011 by slowder

FILLFACTOR specifies the percentage for how full the Database Engine should make the leaf level of each index page during index creation or rebuild. FILLFACTOR must be an integer value from 1 to 100. The default is 0. If FILLFACTOR is 100 or 0 (MS SQL treats these the same), the Database Engine creates indexes…

Continue reading
  • 1
  • 2
  • 3
  • 4
  • Next
  • Career Development
  • Data Engineering
  • Data Science
  • Infrastructure
  • Microsoft SQL
  • Modern Data Estate
  • Personal
  • Random Technology
© 2023 shannonlowder.com | Powered by Minimalist Blog WordPress Theme