Geeks With Blogs
Jim Giercyk
Many SQL developers shy away from the CROSS APPLY, because it is not very well understood. There is not a lot of documentation or examples available online; CROSS APPLY is the SQL Query’s Redheaded step-child, but also a well-kept secret. Essentially, all a CROSS APPLY does is connect 2 queries that cannot be resolved as stand-along queries. Using the ......

SQL offers many different methods to produce the same results. There is a never-ending debate between SQL developers as to the “best way” or the “most efficient way” to render a result set. Sometimes these disputes even come to blows….well, I am a lover, not a fighter, so I decided to collect some data that will prove which way is the best and most ......

Occasionally I am asked to create a report is SSRS, and there are a few common user requests that are not exactly intuitive to a developer. Since I constantly find myself looking at other reports and “borrowing” code, this blog entry is mostly for me so that I can change my thieving ways, but I hope that it helps you as well. Alternate background colors ......

In a complex SSIS Control Flow, there is often a need to have a common last step, regardless of the number of Control Flow end points. Consider the following example: In this case, we are using the Completion constraint (blue line), and an Expression to determine which path to follow. If there are records, we upload them, if not we end without doing ......

When you have an SSIS package error, it is often very helpful to see the data records that are causing the problem. After all, if your input has 50,000 records and 1 of them has corrupt data, it can be a chore. Your execution results will tell you which column contains the bad data, but not which record…..enter the Data Viewer. In this scenario I have ......

If you are like me, you dread the 3AM wake-up call. I would say that the majority of the pages I get are false alarms. The alerts that require action often require me to open an SSIS package, see where the trouble is and try to identify the offending data. That can be very time-consuming and can take quite a chunk out of my beauty sleep. For those reasons, ......

I recently created a DLL and I wanted to reference it from a project I was developing in Visual Studio. In previous versions of Windows, doing so was simply a matter of dropping the DLL file in the C:\Windows\assembly folder. That would add the DLL to the Global Assembly Cache (GAC) and make it accessible in Visual Studio. However, as is often the case, ......

One of the challenges recently thrown my way was to read an EBCDIC flat file, decode packed dates, and insert the dates into a SQL table. For those unfamiliar with packed data, it is a way to store data at the nibble level (half a byte), and was often used by mainframe programmers to conserve storage space. In the case of my input file, the dates were ......

SSRS is a powerful tool, but there is very little available to measure it’s performance or view the SSRS execution log or catalog in detail. Here are a few simple queries that will give you insight to the system that you never had before. ACTIVE REPORTS: Have you ever seen your SQL Server performance take a nose dive due to a long-running report? If ......

While working on a mainframe integration project, it occurred to me that some basic computer concepts are slipping into obscurity. For example, just about anyone can tell you that a 64-bit processor is faster than a 32-bit processer. A grade school child could tell you that a computer “speaks” in ‘1’s and ‘0’s. Some people can even tell you that there ......

Copyright © Jim Giercyk | Powered by: GeeksWithBlogs.net | Join free