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
Improve SQL Performance
by Derek Du
Recently, we were asked to improve the performance of some SQL queries that run for 15 seconds and 30 seconds. At first, we were not sure whether the performance could be improved, given that there were about 80 million data pieces in the database. I have to admit that SQL Server is really powerful as eventually we reduced the time to 2 seconds and 6 seconds!
During the proces...
Read More »
Tagged With:
SQL performance
,
SQL Server
,
trouble shooting
/ 3930 Views
Paging Data for SQL Server
by Jacky Xu
Before a new version of SQL server is released, we always implement data paging through the transact-SQL function “ROW_NUMBER” and it always needs a nested SQL script. Microsoft released new scripts “OFFSET” and “FETCH” for data paging functions. Here are two sample queries for different SQL server version paging function.
First, we query all dat...
Read More »
Tagged With:
offset script
,
fetch script
,
Microsoft
,
SQL server
/ 2769 Views
The Easiest Way to Test a SQL Server connection
by Derek Du
The other day I found an interesting way to test a SQL Server database connection. It is very easy, and quicker than what I usually do. For those of you who like moving pictures,
here is a video tutorial
.
To test a database connection, I usually make sure a port is open by using the Telnet command and then use a tool like SQL Command Line, or SQL Server Management Studio, ...
Read More »
Tagged With:
Test connection
,
SQL server
,
UDL file
/ 2775 Views
User Already Exists in the Current Database – Orphaned Users in SQL Server
by Derek Du
Today, when moving databases via backup and restoring, I had an issue of re-creating
User Mappings
on the new databases. An error, “User Already Exists in the Current Database,” prevents me from adding any mapping to the existing databases. Below is a solution:
This script shows the existing users of the selected database:
EXEC sp_change_users_login ‘Repor...
Read More »
Tagged With:
SQL server
/ 2317 Views
Export Data with SSIS, Part 2
by Sheila Zhang
In a previous
blog
, I started explaining how to perform complex data transfers. When you need to manipulate the source data much to fit the destination -- such as the ETL process (extract – transform – load) -- you can use SSDT (SQL Server Data Tool) to develop a SSIS solution.
The development language of SSIS is different from other development languages that need you ...
Read More »
Tagged With:
export data
,
SSDT
,
SQL server
,
visual studio
/ 2755 Views
Top Articles for the Week of March 14, 2014
by Kristi Feng
Here are the three most interesting articles I read this week:
1.
8 Enhancements you can find in Sage CRM 2014 R1
Find out the 8 key Sage CRM builder enhancements and how these enhancements make building custom entities and business modules easier.
2.
Applying The Scientific Method to SQL Server Performance Tunin
g
Approach SQL performance tuning from the s...
Read More »
Tagged With:
Sage 300 ERP
,
Sage CRM
,
SQL Server
/ 1999 Views
Using Windows Functions in SQL Server
by Emma Tsai
As a business analyst, I not only work with clients to get the requirements, but also perform functional testing for software applications. Sometimes, I need to work with
SQL server
to do database query and compare the results while testing. Recently, I found using Windows functions to perform data analysis computations in SQL server is pretty handy.
Basically,
Windows aggregate funct...
Read More »
Tagged With:
Windows
,
application development
,
SQL server
/ 2286 Views
Web Application ROI Testing Tool
By Emma Tsai
For the past few weeks, I introduced some integration solutions we created for our clients and gave a high-level overview about how these different applications work together and how the user interface looks. In addition to system integration, we also have strong web application development techniques and experience.
This ROI (Return on Investment) tool we developed for ...
Read More »
Tagged With:
web application
,
.NET Framework 4.0
,
IIS 7
,
SQL Server
,
web development
/ 2093 Views
Making .Net Work with SQL Server Reporting Service
By Jacky Xu
Recently, we have a project that needed to print a report through SQL server reporting service. It’s my first time to work on the SQL server reporting service, so I had to spend some time researching this. I think reporting service is a great tool to show reports, and easy to use. Below are some steps to print reports:
1. Create a new Windows Form solution in VS2010.
2.&n...
Read More »
Tagged With:
SQL Server
,
.Net
,
SQL server reports
,
Windows Forms
/ 3114 Views
Which Port is SQL Server Instance Using?
By Derek Du
When dealing with firewalls, you must have a clear understanding of which port your application is using.
Today I took it for granted that a SQL Server named instance such as \SQLEXPRESS is sharing the same 1433 port with the default SQL Server instance. Later after I found out it didn’t work, it finally occurred to me that two processes cannot listen to the same port.
Anyways...
Read More »
Tagged With:
Named Instance
,
Port
,
SQL Express
,
SQL Server
/ 2121 Views
Search
Categories
General (166)
Development (158)
Success Stories (40)
Products (29)
Uncategorized (18)
BTerrell Group (5)
Project Management (22)
Web Development (57)
Web application (33)
Integration (19)
Mobile Development (7)
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 / 17250 Dallas Parkway, Ste. 225 / Dallas, Texas 75248 / Phone:
214-647-2611
/ Toll Free:
866-647-2611
/ Fax:
214-647-2612
/
info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.