Hi, I'm managing a very large data warehouse (>1 TB) based on MS SQL 2005. I would like to create a solution for the users to present data from the cubes on-line (web interface). Right now they are using Office Web Components, but it's not so good. I don't have any controls over the reports that they create. I googled, and there are so...
I am connected to my company's SQL 2005 server over LAN. How do I find out the host? ...
I have the following VBScript, which is supposed to connect to a SQL Server 2005 database. But, my connection is failing. Why? Set dbConnection = CreateObject("ADODB.Connection") dbConnString = "Provider=SQLOLEDB.1;Data Source=srv\test1;" & _ "Initial Catalog=tset_DB;user id ='abc';password='abc'" 'Open the connection d...
In an table I have the following. ParameterID (int) ParameterValue (XML) ------------ -------------- 1 <USER><User ID="1" Name="Billy"/><USER> <USER><User ID="2" Name="Billy"/><USER> <MANAGER><User ID="1" Name="Billy"/><MANAGER> 2 <USER><User ID="1" Name="John"/><USER> ...
I'm trying to understand how SQL Server 2005 replication works, and I'm looking at the views titled Msmerge_[Publication]_[Table]_VIEW. These views seems to define the merge filters, and are pretty straight forward, except for one line of sql in the WHERE clause: AND ({fn ISPALUSER('1A381615-B57D-4915-BA4B-E16BF7A9AC58')} = 1) What do...
I have some reporting services reports in 2005. The use a shared data source in a rds file Ideally I want them to use a connection string that is passed in from a configuration file, ideally via ASP.NETs ReportViewer control. Is this possible? ...
I have a table A that has a startDate and an end dateDate as 2 datetime columns besides some more other columns. I have another table B that has one datetime column call it dates column. This is in SQL Server 2005. Here the question: How to best set up the indexes etc to get the following: select .... from A , B where A.startDate >= B...
I'm investigating the possibility of upgrading our SQL Server from SQL Server 2000 to either 2005 or 2008. There's a lot of concern over whether or not 2008 is really ready for us to use because the database is so critical to our product. What are the compelling reasons to use 2008 over 2005? Have you had good or bad experiences with 200...
We have a database housekeeping operation that the SQL Server agent runs overnight (SQL Server 2005). Basically it compiles a table of record ID’s that are old enough to be deleted and then first deletes any child records before deleting the main record. Recently after adding a new table dbo.IssuePrice, which has a foreign key reference...
I have a very large (millions of rows) SQL table which represents name-value pairs (one columns for a name of a property, the other for it's value). On my ASP.NET web application I have to populate a control with the distinct values available in the name column. This set of values is usually not bigger than 100. Most likely around 20. Ru...
Our system needs to store tiff images of about 3k each in size. We received about 300 at a time, and need to process them pretty quickly. Later, once we have received say around 100,000 of these, there are transferred off to another archival system or purged. Would storing the images in SQL Server or the file system give us better per...
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 server 2005 (We do not have 2008, it isn't an option). We have...
I have MS Access 2007 Databases and VBA modules associated with it. I Now want to upgrade my project so as to use Sql Server 2005 and Vb.net using visual studio.net. Can any one suggest Complete details on the transfer without much hassle or data loss.? Thanks In Advance ...
Hi I'm new to SQL and I'm trying to figure out how I'm going to get the top 5 "bands" with most friends (userId) and this is what i have; a usertbl with userId as PK then a bandsTbl with bandId as PK then I have a table bandfriends with FK userId and bandId. bandfriends userid | bandId --------------- 1 | 1 1 | 2 1 | 3 ...
My "FeedbackSummary" table structure is GivenBy varchar(50) GivenTo varchar(50) Points decimal(15, 2) Sample Data Alice Janet 4.50 Alice Bruce 3.50 Bruce Alice 2.87 Bruce Janet 4.75 Janet Alice 5.45 Janet Bruce 3.78 What I am trying to achieve GivenBy_GivenTo Alice Bruce Janet Alice NULL 3.50 4.50 Bruce 2.87 ...
I have 4 SQL Server 2005 db's that I want to move to SQL CE. I know I cannot keep the SProcs,Views, and Functions(Differences Between SQL Server Compact and SQL Server) but I would like to keep everything else. I have tried this app, SQL Server to SQL Server Compact Edition Database Copy but it errors out on me. I have the source and ...
I have a table in a database in SQL server 2005.one of the column is of XML datatype.the content of the columns is like <info>This is a sample information .Anyone can help </info> Now i want to query the data in the table with a part of the column value as response. ie : My desired output is "This is a sample " What should be the...
I'm wondering whether such query could be potentially optimized. I've hugely simplified it, and you see the core of it. with Rec (Id,Name,ParentId) as ( select Id,Name,ParentId from Departments where ParentId is null union all select d.Id, d.Name, d.ParentId from Departments d join Rec r on (d.ParentId=r.Id) ) select q....
Hi. I am starting a new project, and I am considering using alias data types in my SQL Server 2005 database, for common table columns. For e.g. I would define an alias data type to hold the name of an object, as follows: CREATE TYPE adt_Name FROM varchar(100) not null Then use it for the definition of table columns, ensuring a...
I have two date values: 08/6/2009 00:00:00 and 10/6/2009 23:59:59. How do I get the difference in hours in a query in SQL Server 2005? ...