Current Category Subscribe to the RSS feed for this category
SQL Server
Parent Categories
All Categories
Child Categories
Analysis Services
Jesse Taber,

This blog post has moved:

http://gruffcode.com/2011/11/15/time-warp/

DevJef,

If you work with SQL Server you will eventually encounter a JOIN statement. This JOIN statement can be stated as an ordinary JOIN, or as a sub select. In most cases I try to use JOINS (even though it’s ...

Kevin Shyr,

The following is my experience with SSIS building: Make sure you understand the 3 modes of Lookup. General, I would only do full cache if the lookup table only return less than 200 rows Never use the table ...

xamlnotes,

Today I was working on hooking up some CLR sprocs in SQL Server. My friend Greg Low (SolidQ Australia) pointed out that even vb clr sprocs are case sensitive. I loaded an assembly like so: CREATE ASSEMBLY ...

Robz / Fervent Coder,

DropkicK (DK) has been in development for over two years and has been used for production deployments for over a year. Dru Sellers originally posted about DK back in 2009. While DK isn’t yet as super easy ...

Bunch,

To print multiple int variables on one line you need to CAST them first. Otherwise the PRINT command will add them up (at least it does for me anyways using SQL 2008). In the example I needed to have two ...

DevJef,

For (almost) all developers, there’s no greater feeling, then knowing your source code is (relatively) safe. The same counts for T-SQL script. Especially if you know that you need the same code next year ...

DevJef,

If you write a SQL query, it’s important to know when certain pieces of you query are executed. For example, it’s possible that some statement in your query interferes with another part of your query, ...

James Rogers,

I cut my DBA teeth on IBM's DB2 UDB EEE (enough acronyms) back in the 90's. I have always appreciated the scalability that is available with a MPP architecture. So a couple of years ago I was excited to ...