I recently restored a database from tape. However when I go into SQL Enterprise Manager, I see the recently restored database showing "loading". I assumed that this was a good indication however it has been loading now for the last 12 hours. The database is about 17 gig. Is this normal or ...more >>

I have a database which is 54GB in size and currently utilizes a single file group. What is the best way to split this database so that I can back it up maybe piece by piece? I am unable to back the database right now coz' it takes a long time....more >>

I have to recover a database and redirect it to another server with the same database name. Every time I run the job, I get "Unable to attach to <servername>. A network connection to the device could not be established." What am I missing? How can I redirect a SQL restore to another serv...more >>

Hello, I'm pretty new at SQL Server, so please bear with me. I have 4 customer tables each of which have different Primary keys (customer numbers). Each of these tables is receiving new records daily and there may be duplicate records contained between them. I have been given the task of cre...more >>

We are looking at deploying a data warehouse solution soon that has been being developed for a few months. The development team has been working on developing this for the company. Soon they will be turning this over to the DBA group to do some level of integration testing with the rest of our p...more >>

Can any of you who have started or evaluated usage of SQL Server reporting services please share your experiences. How come there is still no thread on microsoft.public.sqlserver.* on Reporting services will it be implemented at some stage. Regards Simon...more >>

Can you please share with me if you are aware of any good books on SQL Server reporting services. Many Thanks Simon...more >>

I'm trying to build a cube. I am using a view for my account dimension. Here is the definition: ALTER VIEW DemandAccounts AS SELECT * FROM dbo.Account WHERE AccountKey IN (SELECT DISTINCT AccountKey FROM Demand) I only want accounts in my dimension that have made demands. I have verif...more >>

Hi dear all, Anyone have news about the future of BI Accelerator in Yukon SQL version? What do you think about SQL BI Workbench announced by Microsoft? ...more >>

HOw to set the field (Password) in sqlServer database to '*' For example I key in VB : 12 In SqlServer database should appear : ** Yoir help will be appreaciated daniel....more >>

All, When I process a new cube, I receive this error: Analysis Server Error: More than the maximum of 64,000 dimension member children for a single parent (dimension 'Retention SC Account'S', level 'Account Number', member '1234567890').; Time:12/18/03 9:58:28 AM The underlying fact t...more >>

All, When I try to "Design Storage" for a new cube, I get a "Fact table size can not be 0" message. (I am in the Cube Editor...) If I focus on the fact table and select "Browse Data", the data is displayed as it should be. So, the fact table size clearly is not "0". From Query Analyzer...more >>

Hi, We have created a System which does over 1000 transaction every fives minutes with the database. Mostly they are insert and udpdate commands. We have noticed that the transaction log keeps increasing in size (in GBs). We have used the Shrink command at various stages but at some point of t...more >>

All, When I try to process my new cube, I receive the following messages: Unable to count the members of 'LineOfBusinessLevel4' level. Unable to open the record set. Error: Timeout expired. I went into the ODBC administrator and increased the connection pooling timeout to 360 an...more >>

I run a fairly large SQL 2000 db (50GB), processing between 1MM-2MM new event records (time series) per day....spread out evenly throughout the day. With this application once I roll to a new month, the data from the prior month is useless and I need to get it out of the db quickly and efficientl...more >>

Hello, Does anyone know of MS roadmap regarding Yukon's support for real spatial data types (like Oracle's SDO_Geometry) and support for spatial functions? We need a monolithic database for both geospatial and regular,non-geo data. I'd hate to have to convert from SQL Server to Oracle just for ...more >>

Looking for info on the noted error message received: General network error. Check your network documentation. [SQLSTATE 42000] (Error 11). The step failed. Basic file import INSERT job failed on data warehouse. No reported network or backup problems ... Thanks in advance, ericggordo...more >>

I have a created a ragged dimension on OLAP manage but it is not being displayed properly in Excel. Whereever empty level is there, excel displays same value as parent. Any idea why it is happening ? ...more >>

We are currently in the process of looking into setting up a Data WareHouse in SQL2000 so that we can use Cognos to report on the data. I am looking at what hardware to run SQL2000 on just for the DWH. On all of our other SQL2000 servers we have a very VERY simply hardware config of a single R...more >>

Hi, I have a tech interview coming up for a team lead position for the data warehouse/OLAP team. I was wondering if some of you wouldn't mind posting technical questions (anything related to SQL Server/Data Warehouse/OLAP) for me to use as practice. Thanks. ...more >>

Does anyone know of a way to tell when a particular row in a table was last changed. We're doing some trouble shooting and the info would sure come in handy. Thanks, jr...more >>

Does anyone know of a tool that will allow you to submit an MDX query string and get a result set? Maybe there is one that is installed with AS and I am just missing it. Thanks, Asa Monsey...more >>

We have a large number of (Crystal) Reports ( based on Stor Proc ) running against our OLTP database (SQL Server). Instead of reports running against OLTP database I would like to create Cubes and create production reports against them. Is it possible to do that? Are there any client application...more >>

We have a large number of (Crystal) Reports ( based on Stor Proc ) running against our OLTP database (SQL Server). Instead of reports running against OLTP database I would like to create Cubes and create production reports against them. Is it possible to do that? Are there any client application...more >>

Hi There, I have to build a Fact table, and I have this situation. My OLTP database, keeps always the last image of the record. Table Incident(IncidentId, CreationTimme, StatusId, PriorityId, rankId, Description, ..) My Log Database, keeps a table per field and tracks all the chang...more >>

Hello all, Myself and few other guys are working on this problem from past few days but no break-through yet. We are trying to figure out calculating "Median" Here is the business problem: In "Foodmart" database (standardly delivered with MS SQL server Analysis Services) 1. I picked a...more >>

How have other tackled the Inventory Cube? I am thinking along the lines of these two strategies 1. 1 and only one snap shot at a time that we decide accurately reflects realistic inventory levels. Meaning not necessarily at the end of the month when they could be low. or 2. Tak...more >>

Hi, I'm having a problem with following: Firstly my date field in excel is in form of "200311204". I need to pump this date field to a SQL datetime field called 'dt' What I've tried is format Excel date field to text & define SQL field as a char(8) and the transfer is fine OR Excel as n...more >>

How to load JPG images into SQL SERVER 2000...more >>