Last Updated on Tuesday, 28 May 2013 01:05 Written by David Bauernschmidt Friday, 31 May 2013 12:00
When working with a large amount of objects in sql server there are times when you want to know what columns or fields are used in other objects (views, stored procedures, triggers, functions, etc). In SQL here are two queries that you can run to determine what if any dependencies there are.
Just replace the ‘%LastName%’ with whatever you are looking for. The only thing you have to remember is if you have multiple table names with the same named column then you will get a result back with both tables. To prevent this then you might what to fully qualify the table names in your objects and then search for them that way. For example; if you a salesman table and a customer table with ‘LastName’ fields then this could be a problem.
Last Updated on Tuesday, 28 May 2013 01:04 Written by David Bauernschmidt Wednesday, 29 May 2013 12:00
Last Updated on Monday, 27 May 2013 01:24 Written by David Bauernschmidt Tuesday, 28 May 2013 12:00
It is always amazing to me to download a PDF from a site and compress it using several different tools. Before I get started let me preface that I have absolutely nothing against the author or the document(s) they present but this is just showing you what you can gain by spending a few extra minutes. This document contains a lot of images. It seems that the more images you have inside a PDF the greater compression ratio you can achieve. By using different tools online as well as the wide range of options from each site you can achieve some amazing results. I also admit that some of these might not be acceptable alternatives for this kind of document but in general you can achieve great results for a small amount of effort.Learn More
Last Updated on Tuesday, 21 May 2013 02:03 Written by David Bauernschmidt Wednesday, 22 May 2013 12:00
If you are like me I frequently use cursors in sql, but the other day I had created a piece of code like below. Before telling me I could do this a different way, I want to show you what I found.–Go with me…Learn More
Last Updated on Saturday, 11 May 2013 06:14 Written by David Bauernschmidt Thursday, 16 May 2013 12:00
Branding a site can include a wide range of initiatives. Some can take a large amount of time and energy (graphic designs, target marketing, etc.) while others can take just a few minutes. Today, I am going to show you a way to add branding to your site without paying a dime and take less than 15 minutes. You don’t need to pay anyone and can do this completely online for free. The only requirement is that you have a company image. When you get this then follow the steps below.
Go to a site that will allow you to upload your image and tweak the image likeLearn More