I am really new to SSIS and struggling. I have to create a text file apending the output of several queries. How do I use SSIS to create this text...
We want to set up mirroring. We are using Standard SQL Server 2005. Where is the best web page or book to learn about how to do it?
When is the next version of SQL Server coming out? I was thinking it was going to be 2011 but then SQL Server 2008 R2 came out (SQL Server 2010). So...
I have a JAVA developer asking me this question. I am not sure how to answer him. I am not sure I understand his question. He is using JAVA to...
We have a SQL Server 2005 default instance set up on a server. I was requested to install a named instance and to use a static port number. What is...
Reporting Services is absolutely new to me. I have been requested to followed the steps in this blog...
I have learned that to execute a SSIS package from a procedure you can use the following code: dtexec /SQL "PackageName" /Decrypt "abcde"' In...
Today I set up Snapshot Replication to replicate some tables from production to development. Then another individual went to rename one of the...
I have set up Snapshot Replication from one server to another and I believe that I have set it up correctly. However, I am getting the following...
I have a very large select statement. I was hoping to somehow take out the repeated code that is used and store it somewhere and access it through...
Here is an example of my table. LBound and UBound are numeric where Label is a varchar. LBound UBound Label 0.00 0.25 <.25 0.25 0.50 .25 to .5 0.50...
Background: Our SSIS packages have been deployed to the MSDB database of the default instance. We have jobs on this default instance that run these...
I was asked to research and implement a new replication strategy to keep the development database in sync with production. Also, this functionality...
When installing Integration Services do you need to have IIS installed on the server? Years ago I remember that I had to install IIS inorder to get...
In SQL Server Profiler I have selected the event "Missing Join Predicate" to see if we have any issues with queries missing a join. However, it does...
I originally set up a backup device as EXEC master.dbo.sp_addumpdevice @devtype = N'disk', @logicalname = N'countermind_staging_backup_fri',...
Is there a dynamic view or system table that collects information on whether a procedure has been used or not? For example, for indexes there is...
Our LAN Team has bought a new Dell Server with 2.5 Solid State Drives. I was wondering if anyone could point me to a web page for more information...
We have a 64Bit Server. The rule use to be that the paging file should be set 1.5 times. Thus, the paging file would be set at 96GB. However, 96GB...
Separate names with a comma.
