Login /
Register
 search
 syndication
|
|
 |
Note: this subscription applies to the current blog only.
You will receive each new post via e-mail. Your e-mail
address will not be used for any other purpose.
Browse by Tags
All Tags » SQL Server ( RSS)
-
|
How to determine the size of database objects using a T-SQL script
|
-
|
ERP Link will not work with SmallInt data types, even though they are a valid SalesLogix data type and can be selected when adding a field to the database in the SalesLogix Workgroup Administrator.
|
-
|
This is a continuation of part 1 and part 2. Part 1 I discussed setting up a SQL environment for importing and Part 2 talked about how to load in a source file into the import environment. In this post I am going to discuss actually transforming the data source so that it is in the format of SalesLogix.
|
-
|
Recently I ran into a problem where I was unable to load a SSIS package into a SQL 2005 Server instance. I received the following error: The SQL Server specified in Integration Services service configuration is not present or is not available...
|
-
|
This is a continuation of this article in which I begin to discuss importing data into SalesLogix using SQL DTS. Importing the Source File SQL offers an import wizard that is useful for importing data into a SQL database. Alternatively you can import...
|
-
|
One of the useful stored procedures in MAS 500 that I have used quite a bit is spsoGetCustDflts. This stored procedure allows you to pass in customer parameters and have the system return to you nearly all of the customer attributes you would need to...
|
-
|
While SQL DTS has now been replaced by SQL SSIS, I have always wanted to write up this post about how you can use DTS to import data into SalesLogix. This post also describes some general concepts that can be used in SQL servers at 2000, 2005, or 2008...
|
-
|
MAS 500 has many, many stored procedures that allow various actions to be performed while enforcing business rules, such as adding, updating, or removing records, or retrieving values from the system. This article will describe one of the more useful...
|
-
|
A great feature, introduced in SalesLogix 7.0 is the ability to embed SQL views in SalesLogix, just as if they were a standard SalesLogix table. SQL views, can be a tremendously flexible solution to roll-up/aggregate data from various data sources into...
|
-
|
In my last post, I talked about how you can look at a specific screen or query and analyze it using the SQL index tuning wizard. But what happens if you don't know which screen or query are causing issues? Well there are two additional ways you can monitor the system at a higher level to gain insight into the activity occurring against the SQL database.
|
-
|
OK, so my first post on the Integration Blog, isn't exactly about integrations but it is something I have been working with lately and have had some questions about so I thought it was a good jumping off point.
With SalesLogix and its ability to extend the database structure to support customizations it often grows in scope beyond what was originally designed, as far as the SQL back end is concerned. It is important to consider what the implications on server performance are when adding large data tables that require extensive lookup or query activity against them. SQL utilizes indexes to increase search performance. Without properly designed indexes on large data sets, SQL performance on a system can be decreased enough to cause a system wide slow down in applications utilizing the SQL server.
|
|  |
|