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...
I am creating a SQL Server Replication using a script. When I try to execute The job failed. Unable to determine if the owner (STAR\moorer7) of job L3BPT2M-Atlas-14 has server access (reason: Could not obtain information about Windows NT group/user 'STAR\moorer7', error code 0x5. [SQLSTATE 42000] (Error 15404)). This is a job created...
I am using a dataset to insert data being converted from an older database. The requirement is to maintain the current Order_ID numbers. I've tried using: SET IDENTITY_INSERT orders ON; This works when I'm in SqlServer Management Studio, I am able to successfully INSERT INTO orders (order_Id, ...) VALUES ( 1, ...); However, it doe...
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...
Please, can someone PLEASE give a simple, straight-forward way to enable ASP.NET > Kerberos > Sql Server? We have clientMachine > webServer > databaseServer. The client is insistent that the site must pull the windows login and not prompt, hence the need for Kerberos and Integrated Authentication. It also MUST impersonate the user onto...
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 ...
Hi Is there any way to check Date(like isDate function in TSQL) column in SSIS package derived column expression after extraction from Sourcefile before loading to target dtabase? Thanks ...
Currently, I have two database servers (s1 and s2). both server contains the same database MyData and data only update on s1. What I want to do is that I want both databases contains same data all the time in both server. Could anyone point out the good way to do this without slowing down s1? ...
I have an old .net 1.0 webapp that needs a bit of maintenance done on it. I've used the auto-upgrader to upgrade it to .net 3.5 (and also later tried 2.0) but now it can't connect to the database. On the surface this looks like a noob connection-string problem, but I'm thinking it's more likely to be related to some subtle problem from ...
Can anyone tell me what the difference is between a "Residual" and a Join predicate. If I haven't missed a subtlety they are exactly the same. If so why confuse noobs such as myself by using two different words for the same thing. ...
Hi, I'm trying to achieve the following: I have a measure: [Measures].[Sales] and a time dimmension: [Time].[Year - Month - Day]. I would like to add new measure: [Measures].[Sales SPLY] to work in the following way: MONTH-----------------Sales--------------Sales SPLY 2009 January--------120 000,00--------110 000,00 2009 February ---...
I have scheduled sql agent task which runs an SSIS package. I want to be able to run the SSIS package from .net. Is there a way to either run the SSIS package directly or at least run the SQL agent task which would in turn run the SSIS package. If it helps it is for a .net 3.5 web app written in C# Thanks! ...
I have just installed the excellent Search Server Express 2008 onto one of our servers. As a default all the databases created are put into locations on the c: drive. Does anyone know where all the databases are located and how they can be safely moved. ...
Hi, I currently have a table with a column as varchar. This column can hold numbers or text. During certain queries I treat it as a bigint column (I do a join between it and a column in another table that is bigint) As long as there were only numbers in this field had no trouble but the minute even one row had text and not numbers in t...
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...
As per subject, i am looking for a fast way to count records in a table without table scan with where condition ...
Hi is it faster to search with index ? if I have this table: MEN: ID|Fname|Age how I insert index to this table how i can search all the person that the age between 20-30 using index ? I work with sql server 2008 thank's in advance ...
Hi all, I'm using the SQL command below to update a column called Address, the value contains line feeds and I want to replace them with a semi-colon. In Query Analayzer the preview looks perfect but when I check the data in Enterprise Manager (MS SQL 2000) I still see the squares i.e. the line feeds. Am I not commiting the change? Wher...
Hi I'm having a production database and its replicated report database. How to shrink the transaction log files in the production database as the log file size is increasing. I had tried DBCC SHRINKFILE and SHRINKDATABASE commands but it does not work for me. I can't detach and shrink and attach back as the db in replication. Please hel...