My question is similar to Upgrading SQL Server 2000 to 2005 or 2008 – DTS to SSIS but I have a few restrictions that I’d like the community to consider. We have two databases that currently run on SQL Server 2000 and we are being pushed to move off of this in favor of SQL […]
Does anyone know how to insert data into a table in increments of about 1000? I have a table with thousands of records that I want to insert into an identical table on a different server.
I’m new to SQL Server reporting services, and am trying to decipher an existing report. It’s nothing too bad, but I notice it does have two report datasets defined. (They are generated via separate stored procedures) I’m trying to figure out where and how the report datasets are linked together so the Fields collection has […]
OK I’m not sure if this is valid, however I have a bug bear with SQL Server, and that is that I cannot organise objects in to a group of objects. Imagine I’m working on a new section of work in a large database and I perhaps have 15 objects that I will be regularly […]
Problem: A jar file was failed to deploy on a UAT server. Reason: Because when we are trying to rename it,it is showing “cannot rename the file it is been used by another user”. step choosen in order to solve the problem log on UAT server(xxx). we need the list of java processes along with […]
I have the following example code: create table Details( name varchar(20), age int, weight int, recordDate Datetime) –insert data ..query: SELECT a.name, a.age, a.recordDate, a.weight – (SELECT b.weight FROM Details WHERE b.recordDate = dateadd(dd, -1, a.recordDate) as subtable) FROM Details a GROUP BY WITH ROLLUP (a.recordDate, a.name, a.age) I want to see the weight difference […]
I have a bunch of employee names which need to be inserted in a table. Should I represent my data like this and use OpenXML to insert into the database:- <Employees> <Employee> Emp1 </Employee> <Employee> Emp2 </Employee> <Employee> Emp2 </Employee> </Employees> OR I should represent the Employee like Emp1,Emp2,Emp3, split the string, add to a […]
Possible Duplicate: T-SQL stored procedure that accepts multiple Id values Does T-SQL accomodate for array values as parameters for stored procedures? If so how can this be achieved.
I’m refactoring some older SQL, which is struggling after 4 years and 1.7m rows of data. Is there a way to improve the following MS SQL Query: SELECT ServiceGetDayRange_1.[Display Start Date], SUM (CASE WHEN Calls.line_date BETWEEN [Start Date] AND [End Date] THEN 1 ELSE 0 END) AS PerDayCount FROM dbo.ServiceGetDayRange(GETUTCDATE(), 30, @standardBias, @daylightBias, @DST_startMonth, @DST_endMonth, […]
I have a Sql Server 2005 database that contains many tables which are taking up a large amount of space (combined over 10 GB), and these tables have no rows in them. I can see the space and row count with right-click, properties (Data space and row count items). Any ideas?