Archives: August 2010
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing About SELECT blog.
We’re looking at the SELECT statement clauses in the order that the SQL engine logically processes them…we’ll even write it that way – it’ll look weird, but… Read more
If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) - new in SQL Server 2005 – are actualy pretty #awesomesauce. A CTE is, in essence, a temporary view attached to your SELECT statement. They’re good for a number of uses, not the least of… Read more
SELECT is our bedrock, our foundation, our now-and-forever T-SQL multitasker…and it’s one of the most complicated structures available to us. Here are a few things worth knowing about it, from the basic to the obscure.
More-or-Less Basic Structure
There’s tons more that… Read more
Piggybacking tangentially off of Tim Mitchell’s (blog, Twitter) SSC editorial Turn a Bad Job into a Good Experience…yesterday I got some user questions about the department’s new password policy. The policy is admittedly complex, especially considering half the place had been using the “kid’s name and… Read more
One of the things about SSRS that irritates me is that in the graphical editor, you have to set the text box properties (say, to format numbers as currency) for each individual text box…unlike Excel, where you can select multiple fields, hit CTRL-1 and format them all at once. Read more
This has come up several times in the course of the last TWO jobs, so I’ll put it here for my reference (and yours).
To use a dBASE file as a source in SSIS (and I know you want to), in your new connection manager:
- Select Native OLE DB\Microsoft Jet…
24 Hours of PASS is hip, it’s new…it’s serialized.
I’m absolutely positive that I’m not the first to blog on this topic, but I haven’t seen anyone else say exactly what I want to say. So.