pratchev.blogspot.com
Zen of SQL: Refactoring Entity-Attribute-Value Design
http://pratchev.blogspot.com/2010/07/refactoring-entity-attribute-value.html
Tuesday, July 27, 2010. Ntity-Attribute-Value (often referenced as EAV) table design is one of the “wonderful” things that newcomers to the SQL land discover very quickly! 160; Example is storing all employee information in 3 columns: key column to identify employee ( entity. Attribute key column ( attribute. To identify the attribute stored (name, birth date, SSN, date of hire, etc.), and value column ( value. To store the actual value. Normally the value column has to be of some large length characte...
pratchev.blogspot.com
Zen of SQL: Defensive Database Programming
http://pratchev.blogspot.com/2011/01/defensive-database-programming.html
Friday, January 28, 2011. Efensive programming is a much avoided topic by developers. Rushing to deliver features is almost always prioritized higher than spending time to defensively program code for robustness. Especially in the database world where this concept is much misunderstood. This is why it was real pleasure to read Alex Kuznetsov's book Defensive Database Programming with SQL Server. Posted by Plamen Ratchev. February 7, 2011 at 9:41 AM. I dont think this guy needs an extra buck a month.
pratchev.blogspot.com
Zen of SQL: Import XML File to SQL Table
http://pratchev.blogspot.com/2008/11/import-xml-file-to-sql-table.html
Friday, November 14, 2008. Import XML File to SQL Table. Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized table format. This example requires SQL server 2005 or SQL Server 2008. First, the following XML is saved to XML file C: Products.xml. Next, a table named Products is created to store the XML data. Sku, product desc.
pratchev.blogspot.com
Zen of SQL: The Power of Simplicity
http://pratchev.blogspot.com/2010/08/power-of-simplicity.html
Friday, August 13, 2010. The Power of Simplicity. Olving a problem very often results in unnecessary complex solutions. One of the first lessons I learned from my math teacher was to scrap any solution that exceeds a page. She would urge me to start all over and look for simpler way to resolve it. In her world there was always a short and simple solution, it was only a matter of seeing it. What are the rules to simplicity? There are no rules! I like to use the following quotes as guidelines:. 160; &...
pratchev.blogspot.com
Zen of SQL: Refactoring Ranges
http://pratchev.blogspot.com/2010/02/refactoring-ranges.html
Monday, February 15, 2010. Refactoring is misunderstood so many times, mostly by developers living by the motto. If it's not broken don't fix it". But in most cases this is invalid argument and leads to keeping inefficient and difficult to maintain solutions around. With tools and languages evolving, as well as knowledge about specific technology, there are so many opportunities to improve existing code in a way that will make a huge difference in many aspects. As Sir Winston Churchill said. Ranges by tr...
pratchev.blogspot.com
Zen of SQL: Column Aggregates
http://pratchev.blogspot.com/2009/08/column-aggregates.html
Friday, August 21, 2009. We all know how to use the aggregate functions MIN, MAX, COUNT, etc. to calculate aggregates across rows. For example, using MAX we can determine the maximum value for group of rows. But what if we want to see the maximum value for each row across columns? There is no aggregate function that accepts list of columns…. Let's look at example to illustrate this. Here is sample table with four data columns:. Max across columns with XQuery. Keycol max col max val. Keycol cnt non zero.
zdravs.blogspot.com
Zdrav's Tips & Tricks: Crystal Reports - How to remove old DB source from Report or Subreport
http://zdravs.blogspot.com/2007/01/remove-old-db-source-from-report-or.html
Zdrav's Tips and Tricks. Wednesday, January 17, 2007. Crystal Reports - How to remove old DB source from Report or Subreport. To remove an old DB source from report or subreport - there should be no fields in use from these source. If there are still red-checked fields in the source - follow:. Remove all fields of these source from all report sections. Remove all fields of these source from all Formula Fields. Remove all fields of these source from all Fields formula properties. Labels: Change DB Source.
sqlstudio.blogspot.com
SQL Studio Team WebLog: Welcome
http://sqlstudio.blogspot.com/2007/01/welcome.html
SQL Studio Team WebLog. Sunday, January 14, 2007. Welcome to our team Web log! We dedicate this space for posting technical information, tips and tricks, and how to articles about SQL Studio Data Compare. Any comments and ideas are appreciated. Technical articles about SQL Studio Data Compare. View my complete profile. Compare Data Using The Command Line Utility. How to Compare Data in Tables. How to Compare Data in Databases. SQL Studio Data Compare. Compare Data Using The Command Line Utility.