Import Data from AS400 to SQL Server
The process to import data from AS400 uses a SQL Server Linked server. The Linked Server points to an ODBC...
2011-09-16
17,173 reads
Probe Residual on Hash Match
I have to say, I only recently noticed this on a tool tip:
and this in the property sheet:
The bad news...
2011-09-15
1,695 reads
PowerShell for the Easily Frustrated N00b, or, “A Simple and Useful Command”
The stupid, stupid Windows search (Start Menu > Search) doesn’t work on one of my computers (running WinXP Pro). Yes, I made...
2011-09-15
488 reads
Analytic Functions – FIRST_VALUE / LAST_VALUE
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-15
4,045 reads
SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)
What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a...
2011-09-15
13,151 reads
How pure is your data?
It was a normal Monday. I was going over some HA designs and planning the joys of setting up log...
2011-09-14
2,331 reads
Normalize your Linked Server Names
This is a technique I’m sure many people are already using in their environments. Instead of using the actual name...
2011-09-14
3,614 reads
What Happens in Vegas…
…Need not Stay in Vegas Coming to Las Vegas in 2012 is an event many have been waiting for. Those that have been waiting for this event are the...
2011-09-14
13 reads
What Happens in Vegas…
…Need not Stay in Vegas
Coming to Las Vegas in 2012 is an event many have been waiting for. Those that...
2011-09-14
752 reads
SQL Server 2012 (“Denali”): Installing on a Virtual Machine
With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new...
2011-09-14
1,657 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers