-
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
Category Archives: Uncategorized
How long do the parts of my job take?
When you schedule a job in SQL Server, you can see how long the job took by right clicking on the job and then clicking View History. If you want to see how long each step in the job took, … Continue reading
Posted in Uncategorized
Leave a comment
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
Knowledge Sharing
One of the biggest problems most companies face is the loss of institutional knowledge when an employee leaves. As a consultant, I see this at every company I go to. If it isn’t from an employee leaving while I’m there, … Continue reading
Taking Notes
I work with quite a few different technologies and I’ll use this blog to talk about all of them as I find interesting things to say about each. Currently I’m working primarily with SQL Server and that’ll be the primary … Continue reading