Tag: sql-server-2005

Hooking up Reporting Services 2005SP2 to SQL Server 2008

I am trying to configure Reporting Services 2005SP2 on a machine with SQL 2008 on another hosting the ReportServer DB. When I create the ReportServerDB the DB is created as version C.0.9.45: When, afterwards, I try to initialise Reporting Services, I get an error about an incorrect version number. Reporting Services created a ReportServer DB […]

SQL Server 2005: Detecting cycles in hierarchical data

I have a typical table of hierarchical data in id, parentId form. CREATE TABLE Hierarchy (Id int, ParentId int NULL, Name varchar(128)); INSERT INTO Hierarchy VALUES (1, NULL, ‘1’); INSERT INTO Hierarchy VALUES (2, NULL, ‘2’); INSERT INTO Hierarchy VALUES (3, NULL, ‘3’); INSERT INTO Hierarchy VALUES (4, 1, ‘1.1’); INSERT INTO Hierarchy VALUES (5, […]

can I configure hibernate properties to connect without using an instance name to sql server 2005?

Can I configure hibernate properties to connect without using an instance name to sql server 2005? I need to force it to use localhost as the hostname and not specify the instance (same as you can do with the sql server enterprise manager). Ta! T

What bcp format file that I'm gonna used to insert 59 columns?

First Observation, limitation with this BCP format file Data File: (Continuous up to three lines) 1;a;b;c;d;e;f;; 2;d;e;f;g;h;i;; 3;g;h;i;j;k;l;; 4;j;k;l;m;n;o;; 5;m;n;o;p;q;r;; 6;p;q;r;s;t;u;;What bcp format file that I’m gonna used to insert 59 columns? Format File: 9.0 9 1 SQLCHAR 0 0 “” 0 x “” 2 SQLCHAR 0 0 “;” 2 col1 Latin1_General_CI_AS 3 SQLCHAR 0 […]

Use APPLY with an UPDATE statement as the row source

I tried to perform the following in order to update a psuedo-identity value at the same time as using the value to create new rows, but APPLY does not like UPDATE statements as the right table source. What’s the most elegant alternative outside of simply using an identity column? create table Temp1( id int not […]

T-SQL Process Design and Execution Plan (UDF Parameter Sniffing?)

On SQL Server 2005, I have a complex multi-level allocation process which looks like this (pseudo-SQL): FOR EACH @LVL_NUM < @MAX_LVL: INSERT INTO ALLOCS SELECT ‘OUT’, * FROM BALANCES(@LVL_NUM) INNER JOIN ALLOCN_SUMRY(@LVL_NUM) INSERT INTO ALLOCS SELECT ‘IN’, * FROM BALANCES(@LVL_NUM) INNER JOIN ALLOCNS(@LVL_NUM) INNER JOIN ALLOCN_SUMRY(@LVL_NUM) Where ALLOCS is seeded with direct allocations and then […]

How Do I create a log using performance monitor in SQL?

A company I deal with have their own server, and a couple of sites using SQL server 2005 on it. They are getting random, intermitten freezes and its pointing to SQL Server so the company who they got the server from said to “create a log using performance monitor in SQL” I have RD Access… […]

2005 SQL Reporting Services Dataset filter with OR not AND

Under Dataset Filters Tab, I want to use OR not AND but when I add a second Filter the AND appears in the And/Or column with no way to change it. Am I missing something?

ORM and database indexes

What approach do you have towards creating and maintaining database indexes when using ORM such as NHibernate/Hibernate. Since the ORM is generating the queries, are there any tools you could recommend that could analyze query plans of those and suggest the kind of indexes that should be created? My current approach is … wait until […]

SQL Server Service Broker to insert data on a SQL Server 2000

I have two servers, the first one with SQL Server 2005 and the second one with SQL Server 2000. I want to insert data from the 2005 to the 2000 and I want to do it unsync (without distributed transactions because “save transaction” are used). Once the information is inserted in the tables of the […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.