CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


Overview of a Data Warehouse Logical Design - Schema

by Sheila Zhang
Databases designed for businesses typically focus on data manipulation. Normalized relational databases tend to increase the amount of tables, to reduce the space required for data storage, while being updated to reduce redundancy. For example: a customer table holds the customer ID and address information for each customer, and the sales order table only keeps the customer ID, not...
Read More »

On December 4, 2013 in Development, Project Management, Web application, Web Development [Post:by] Comment 0
Tagged With: Data Warehouse, MSSQL, Schema / 7115 Views

How to Query Using Microsoft SQL Server to Create XML, Part II

by Sheila Zhang
This blog is a continuation from my previous blog: How to Query Using Microsoft SQL Server to Create XML, found here. 

Another great query using Microsoft SQL Server to create XML is using this process:

You can manually define your selected SML format by using the PATH option of the FOR XML clause.  In the PATH mode, the standard XML XPath, which describes the path...
Read More »

On November 11, 2013 in Development [Post:by] Comment 0
Tagged With: MSSQL, SQL, SQL Query, XML / 6080 Views

How to Query Using Microsoft SQL Server to Create XML

by Sheila Zhang
Using Microsoft’s SQL Server 2012 makes querying with XML a lot easier.  Microsoft’s SQL Server allows you to create XML with a SQL query or shred XML into a data table format.  I have shared with you below examples of achieving this query process faster.

When you use the "FOR XML" clause in the "SELECT- T_SQL" statement, you convert a query record set to XML...
Read More »

On October 28, 2013 in Development, Web application, Web Development [Post:by] Comment 0
Tagged With: MSSQL, SQL query, XML / 3385 Views

Best Practices to Consider When Writing Queries with Microsoft’s SQL Server

by Sheila Zhang
I query databases almost every day. The database I work with most often is the SQL server. Microsoft recommends, as a best practice, writing standard queries. While I agree that writing standards makes code more portable, due to the ease of beginning work with new platforms, I also want to share some examples below in the Microsoft training kit that allow you to dec...
Read More »

On October 11, 2013 in Development, General, Web Development [Post:by] Comment 0
Tagged With: Best Practice, MSSQL, SQL query / 4544 Views

Manipulating SQL String Functions

by Sheila Zhang
I recently reviewed SQL character functions in SQL 2012. One thing I learned is that these functions also work in SQL 2008.
Commonly, I need to combine several string type fields into one in your select statement. So, I may write something like this:
“SELECT empid, country, region, city, country + COALESCE( N',' + region, N'') + N',' + city AS location FROM HR.Employees&...
Read More »

On September 27, 2013 in Development [Post:by] Comment 0
Tagged With: application development, character function, MSSQL / 3146 Views

Tools to Analyze Query Performance

by Sheila Zhang

If you need to monitor a system that has performance problems, start using Extended Events. It is a very lightweight performance monitoring system.

SQL Trace is an internal method for capturing events. You can set it up either manually or through SQL Server Profiler. Currently, it is supported by SQL 2012 and next version. After the next version, it might be discontinued.

SQL Se...
Read More »

On September 17, 2013 in General [Post:by] Comment 0
Tagged With: Extended Events, MSSQL, SQL Servr Profile, SQL trace / 1845 Views

The Logic Process of a SQL Statement in a Database Engine

by Sheila Zhang
Have you ever tried to write a T-SQL statement, for example, to get a list of customers whose open amounts that are more than a specified amount? It would be good if you could write the statement like this:


The answer is no, you cannot do it. You will get an error message:
...
Read More »

On September 5, 2013 in Development [Post:by] Comment 0
Tagged With: MSSQL, T-SQL / 1858 Views

Search

Categories

  • General (166) rss
  • Development (158) rss
  • Success Stories (40) rss
  • Products (29) rss
  • Uncategorized (18) rss
  • BTerrell Group (5) rss
  • Project Management (22) rss
  • Web Development (57) rss
  • Web application (33) rss
  • Integration (19) rss
  • Mobile Development (7) rss

Archives

  • 2015
    • January (5)
    • February (7)
    • March (6)
    • April (5)
    • May (2)
  • 2014
    • January (13)
    • February (12)
    • March (13)
    • April (12)
    • May (11)
    • June (12)
    • July (11)
    • August (13)
    • September (10)
    • October (8)
    • November (6)
    • December (4)
  • 2013
    • April (73)
    • May (22)
    • June (20)
    • July (20)
    • August (22)
    • September (19)
    • October (13)
    • November (12)
    • December (7)

Tags

.NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
ABOUT US / CONTACT US / NEWS & EVENTS
CodePartners / 16200 Addison Rd. STE 270 / Addison, Texas 75001 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.