Theobald Xtract IS DeltaQ
Fri, 19 Feb 2010 06:11:02 -0800
Hi,
During a project I gained a lot of knowledge of using the Theobald Xtract IS
DeltaQ component, which I like to share with you all.
I have written five blog entries on my blog that give a detailed explanation
of using the Theobald Xtract IS DeltaQ component
in an SSIS project. I hope this will help you a ...
|
Generic parameter in a function
Fri, 19 Feb 2010 01:11:48 -0800 (PST)
what is the generic type on MSSQL? I want to create a function that
takes anything, and returns anything. Kind like NULLIF(anything,
anything), or ISNULL(anything,anything)
I want to create
IIF(expression,anything,anything) Returns anything
I undertstand expression could be of BIT datatype
but what is th ...
|
How do I determine if msdn or license volume copy is installed
Thu, 18 Feb 2010 17:39:01 -0800
I want to verify if the SQL 2005 enterprise is installed using a MSDN or
volume license copy disc
If MSDN was used, will it expired? Version shows 9.00.3042.00.
Thanks,
Tnt ...
|
Snapshot agent uses all available memory on server
Thu, 18 Feb 2010 18:55:16 GMT
I have a SQL server. SQL 2005, Service Pack 3, Cummulative update 5. Version
9.00.4230. Default server settings for memory. Server has about 3.5 gigs of
memory.
I have set up transactional replication to be it's own distributor on this
sql server, it is set for a push subscription. I have placed the repldata
...
|
Serializing concurrent updates
Thu, 18 Feb 2010 20:41:55 +0200
Hi all!
I would have a question regarding serialized updates. We have a table as
follows:
CREATE TABLE MyTable (
ID INT NOT NULL PRIMARY KEY CLUSTERED,
Value INT NOT NULL
)
INSERT INTO MyTable VALUES ( 1, 1 )
There are two types of transactions for the MyTable table. Writer
transactions and ...
|
sqlservr.exe writing to wrong path
Thu, 18 Feb 2010 12:17:51 -0500
Hello-
Has anyone heard/seen an instance where SQL 2005 (64-bit on Windows 2008) has some
WriteFile operations that are displaying the incorrect path when viewed through Process
Monitor?
Process Name PID Operation Path
ex: sqlservr.exe 2016 WriteFile C:3\DBDir\blah
the Path value in this case should be ...
|
query in sql server CE without FIRST, LAST and TOP
Thu, 18 Feb 2010 17:49:36 +0100
Hello everybody,
the functions first or TOP are not working with CE.
I have a table with a structure: Id integer, weight single, MadeOn datetime.
In this table the weights of persons are saved. Now I would like to get all
persons
whose last value of weights > someVariable.
With the sql server it runs fine wit ...
|
|
|
sql server blocking/locking issue
Thu, 18 Feb 2010 08:12:45 -0800 (PST)
hi guys,
I have a procedure to delete old records by id (clustered index) from
the a big table (delete about 150k records at a time comparing to 30 M
total in the table) and at the same time, some procedures will insert
or update data in this table by id as well. When I did the tests, I
found the first proced ...
|
join tables in a view
Wed, 17 Feb 2010 18:27:28 -0800 (PST)
I am not "a sql" gal and need some help creating a join
FROM dbo.[z-SL] INNER JOIN
dbo.[POFooter] ON dbo.[z-SL].ListName = dbo.
[POFooter].[invnum] AND
dbo.[z-SL].ProdCode = dbo.[POFooter].[ProdCode]
SL.ListName is text nvarchar(50)
POFooter.invnum is num ...
|
Programmatic Maintenance Plan Update SQL 2008
Wed, 17 Feb 2010 17:12:32 -0800
Hi,
In SQL 2008 Maintenance Plans, most of the Tasks have a "Databases:" drop
down where there is an "Ignore databases where the state is not online"
option. That is very useful when one wishes to use options like "All
databases" or "All user databases." However, I have a lot of read-only
databases, and ...
|
