Well I have a series of sps that are running a data warehousing solution that we have developed in house. While on the most part it runs pretty good, there is one stored procedure that runs really slow. It takes about 30 minutes on average to execute. I know exactly where the bottle neck is, I just don't know how to fix it. Basically...
What is a built in database? What should I do to get a copy of my MS SQL database in the solution explorer window in Visual Studio 2008 so that when I copy the solution folder the database files will be copied with it? ...
I'm diong a typical Windows Integrated Connection from a .Net Winforms Application: Dim sqlConnetion As New SqlConnection("Server=jupiter;Database=io;Integrated Security=True;") sqlConnetion.Open() I keep getting the following error: Cannot open database "io" requested by the login. The login failed. Login failed for user 'MARS\viking...
Hi guys, I need to implement a multi-parented tree (or digraph) onto SQL Server 2005. I've read several articles, but most of them uses single-parented trees with a unique root like the following one. -My PC -Drive C -Documents and Settings -Program Files -Adobe -Microsoft -Folder X -Drive D ...
How can I read the value of a system environment variable in a T-SQL script? This is to run on SQL Server 2005. ...
I am creating a functionality where our wcf services logs all changes that are stored thru them and the changes need to be sent to other systems. After every service call with changes we store the changes in a table (the changes is serialized). Regulary we have biztalk to pull the changes from the table and delete the one that is pulled...
I have upgraded a SQL Server Express 2005 instance to Standard using the best practices described in other posts. I have restarted the SQL Server but is still appears as Express in Management Studio and when executing select @@version ...
My code generates some dataset per 10 minutes-log or per 30 minutes-log, but the DateTime Format is '1900-01-01 14:20:00'. I need '2009-05-13 14:20:00', so I want to change it. See Table1 and Table2 below. declare @date1 nvarchar(100) , @date2 nvarchar(100) , @countgap int,@count int set @date1='2009-05-12' set @date2 = '2009-05-13' ...
hi guys, Following is a storedprocedure in which iam passing DriverID=0 and DrivarCode =DD1 and DriverName =Ram. While executing control is going to fails.Control is coming to IF ((@DriverName!=NULL) and ((@DriverCode!=NULL)),After that going to fails. DriverName and DriverCode contains values.But still going to fails .What ma...
Hi there, I am working on a Linq based CLR Stored Procedure for some complex filtering and manipulation, which would otherwise require a lot of messy and poorly performant T-SQL code, if implemented in a more "traditional" Stored Procedure. This is working great, but I can't find how to set the schema of this Stored Procedure in phase ...
A related question to a previous one regarding the same subject. In a CLR stored procedure, I am bulding a collection of objects which represent a data set after a complex filtering. This collection is then "translated" in a resulset with the SqlContext.Pipe.SendResultsStart / SendResultsRow / SendResultsEnd loop and delivered. Despite ...
I am using the DatabasePublishingWizard to generate a large create script, containing both data and schema. The file it produces is ginormous so opening the script to fix any syntax errors is next to impossible and machines with less than 4gb have a hard time getting it to run! What should I do and how should I do it? Thanks everyone for...
Hi, I am developing an application that is hosted on a SQL Server 2005 failover cluster. The application (developed using C#, .Net 2.0) makes use of a number of the clustered resources (printers, file shares, etc). I would like to set up a testing environment that replicates the cluster. However, the current test environment has only...
In a part of my data warehousing stored procedures, i have a procedure that compares old project data to new project data (old data is in a table, new in temp table) and updates the old data. The weird part is that if the old data is null, then the update statement doesn't work. If i add a is null statement the update works fine. My q...
I was debugging a stored procedure the other day and found some logic something like this: SELECT something FROM someTable WHERE idcode <> (SELECT ids FROM tmpIdTable) This returned nothing. I thought it looked a little odd with the "<>" so I changed it to "NOT IN" and then everything worked fine. I was wondering why this is? This is ...
Hello Friends, I am using .Net 2008, Framework 3.5, Sql Express 2005. I am using SQL Report. I created couple of reports using dataset and create charts. Chart is create as per date range selected by user. I have problem that if user select long date range then chart is not readable (The bar is very near and number is overlap). Is ther...
Is there any way of copying a database from oracle to sqlserver 2005? Thanks ...
I am using SQL-Server 2005. I have a dev and prod database that have essentially the same data in them. When I do a compare with RedGate SQL Data Compare 5, it says that only 4 records differ. However, when I open up the tables and view them, they are in a completely different sort order. Neither table has an index or anything forcin...
Hello everyone... I have a project that consist of a system that helps to manage a bus transportations company. I have to store in my database the daily routes of all bus. How do I do that? And what can I use to help user to design routes? I'm wondering use Google Maps or something like that, to help users "design" all routes. I ca...
I thought I asked a similar question in http://stackoverflow.com/questions/462071/sql-order-by-and-left-outer-join-doesnt-have-correct-order, but this is slightly different. I am getting data from another SQL-Server 2005 database, using SSIS, and a standard data flow. The records that I get are in a different order than in the source t...