Login /
Register
 search
 syndication
 about
|
|
 |
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)
-
|
Under the heading of "often needed and never remembered", I decided to post a quick T-SQl example of how you can retrieve the space used by the various tables in a SQL 2008 database. Note, in my select query I am limiting to just the top 20...
|
-
|
One thing I alwys forget how to do is to add a sequential number to a query output in SQL. Using the rank function you can get this. A query such as select rank() OVER (ORDER BY accountid) as xrank, account, accountid from account Will return the accountid...
|
-
|
Working with non-nullable types in C# can be a bit of a pain. In the world of SalesLogix you may occasionally run into an error like this: The key to this error is the part about "Data value overflowed the type used by the provider ". How do...
|
-
|
I recently ran into an issue with a SQL server installation at a client where I tried to open a SSIS package using the BIDS interface but would receive an error upon the package loading that said: Microsoft visual studio is unable to load this document...
|
-
|
I was recently asked to provide the ability to extract out of a SalesLogix SQL database, all of the indexes on every table. There is no way of doing this through the SQL management studio but you can use a T-SQL script to do so. Here is a sample script...
|
-
|
Finding row counts of tables in a database
|
-
|
It seems like every time I go to run a SSIS package on a 64 bit machine I forget how to set the flag to run the package in 32-bit mode to be compliant with the 32-bit SalesLogix OLEDB provider. Here are the steps: · Open the package in visual studio ...
|
-
|
I just came up with a really cool way of doing some potentially really cool and complicated things from with the SalesLogix Word Mail Merge engine utilizing a combination of SQL merge fields and SQL functions.
|
-
|
When restoring a SalesLogix SQL database backup from one server to another, you must synchronize the database’s sysdba user to the new SQL server’s sysdba user. This can be done using a SQL stored procedure. SalesLogix provides this procedure under their...
|
-
|
I recently ran into an issue when trying to edit a SalesLogix table in the SQL Management Studio 2008. I was trying to increase the length of a field while in a table’s design mode. When I went to save my change I received this error:
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.
|
-
|
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.
|
|  |
|