-
Recent Posts
Recent Comments
- Stefan on Aliases
- jonmcrawford on Aliases
Archives
Categories
January 2021 M T W T F S S « Sep 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Meta
Tags
Activity Monitor Administration aliases blog Community Data Database Data Warehouse Design Dev Edition error File System Task Help Index Install Intellisense Intro Knowledge Links Mail Naming Conventions Notification Oracle Resources reusability Service Pack shared access speed sp_ SQL Server SSIS Strange Behavior style Syntax testing Text Message tools Try...Catch variables Virtual Machines Visual Studio Web Sites WikiBlogroll
Tag Archives: SQL Server
Stored Procedures don’t necessarily stop at an error
I normally expect precedence to save me in my stored procedures. If I have six statements and the third ones fails, I expect the fourth through sixth not to run. Boy, was I wrong. Normally I test my stored procedures … Continue reading
A weird result from IN (SELECT
I was recently building a query that referenced a SQL Server 2000 database on a linked server. I’m using SQL Server 2008 R2 on my end and I’m used to Intellisense suggesting the columns in the table I’m querying. Unfortunately, … Continue reading
Who’s data is it?
Recently I needed to import some data from a flatfile into SQL Server. As I was creating the table for it, I tried to determine what the data actually was. There wasn’t very good documentation for it so I played … Continue reading
Oracle to SQL Server
It can be hard getting back to blogging after some time off, but here goes. I moved in March/April and I’ll be unpacking for a long time, but I do want to be blogging it is just hard to find … Continue reading
Column Naming
When you’re designing your tables it is important to keep track of the names you’re using for the columns. Don’t just name the ID columns ID. Name them so you’ll know what table the ID belongs to. For example, if … Continue reading
Redundancy
There are certain types of redundancy that are good in the IT world: Backups, failover servers, recovery plans and the like. Most redundancy however, is bad. In the programming world, bad redundancy comes in the form of repeated code instead … Continue reading
Posted in 2008, Programming, SQL Server
Tagged Data Warehouse, Design, reusability, SQL Server
Leave a comment
Clarity in Code
Commenting code is always a good idea and there are more ways than one to comment your code. When running a long series of SQL queries it can be useful to know what has run. If you have conditional statements … Continue reading
Lecture
I went to a SQL Server lecture tonight on Virtual Machines and SQL Server by Brent Ozar. It wasn’t what I expected. The lecture was great, as have been all the ones in this lecture series, but the advice was … Continue reading
Posted in 2008, SQL Server
Tagged Resources, SQL Server, testing, tools, Virtual Machines
Leave a comment
Resources
I’d like to recommend a web site for learning SQL Server and for all your questions as you get stuck. And you will get stuck, believe me, at least if you do anything at all beyond the basics and probably … Continue reading