Does anyone have a good refrence for setting up an SSIS package stored in MSDB as a datasource. Some that describes the security setup for running...
I'm trying to create a linked server to an Excel file. However, the file is password protected, but can be opened for read only. How can I...
I'm importing data from VFP via OLEDB Provider in SSIS. However, the OLEDB Source task is not reading the correct length from the VFP table and...
Caught in a loop trying to find info. I need to read a value from a datareader source and based on that value I need to dynamically create a SELECT...
Unable to connect remotely to a default instance of SQL2k5 developer edition. I've enabled "local and remote connections" via TCP/IP, but still can...
quote:Originally posted by mmarovic Why don't they use version control system for executables? That way when they are connected replication updates...
quote:Originally posted by Adriaan With ASP.NET the client app runs in a web browser, and the web server connects to the database and returns the...
quote:Originally posted by Adriaan quote:Originally posted by JLDominguez quote:Originally posted by Adriaan Why not use a true middle-tier...
quote:Originally posted by Argyle It depends on how the application is built. Has the application been tested in any large scale environments with...
quote:Originally posted by Adriaan Why not use a true middle-tier application? This app will be using merge replication with some end users being...
I have a good one for you. I wanted to toss this out and get your feelings about a particular development paradigm some of our developers are...
Thanks for the info quote:Originally posted by satya Yes and for final confirmation check with SP_WHO2. Satya SKJ Moderator...
Would this mean that the locks aren't really there? quote:Originally posted by satya We have had such problem on one of the heavily used database...
We have a VB application that seems to be generating a bunch of ##Lockinfo entries in the the tempdb. Also, while the spid is sleeping the locks...
Thanks- That's what I needed to know. quote:Originally posted by Argyle A while loop on a temp table will be faster than a cursor.
The records come in to fast- 2/sec. Reading the table this many time would probably cause locking. I agree this type of processing belongs on the...
What is the real difference in performance between using a cursor and using a temp table to process records individually? Will there be a noticeable...
Well- I need to process each record as it comes in. The business requirements requires processing one record at a time when it comes in. I don't...
Basically is there any advantage to replacing a cursor with a temp table. I would sill need the functionality to process one record at a time but it...
What is the real difference in performance between using a cursor and using a temp table? Will there be a noticeable difference in performance...
Separate names with a comma.
