Answer Questions

• billqu SQL Server 2005 table Partitioning

  Hi all, We are planning to use the SQL Server table paritioning in our project. There is a very large table storing 12 years of data. This table would have 25 million records with approx 2 million records per year. We are creating a index with below mentioned keys PK_ID (INT) Rec_CreateDate (Datetime) If we create horizontal partition based on the column Rec_CreateDate, I have the following questions. 1. Will this improve the performance of the DML queries on the table 2. Should I have the partitions on the same file groups or place in different file groups 3. Will the query performance improve only if I include the column Rec_CreateDate in the DML queries or the Pk_ID column itself is enough Also , ...Show All

• Programm3r SQL 2005 upgrade

  Hi all, We need to update our SQL 2000 to 2005. We plan to use it on a computer with 2 processors. Actually we update 2 servers that form a cluster, running web applications. I think there is no update version from 2000 to 2005. So we have to buy 2 full versions of SQL 2005 For our case it's probably best to buy SQL 1CPU version But we have 2 processors on each server. Is there a CPU license Do we have to buy 2 SQL 2005 1CPU plus 2 licenses for 1 (more) CPU Sorry, I am not so familiar with SQL. I am not the guy making the upgrade. I just have to order the correct version and licenses. Ok, I found out that there are processor licenses. But strange is that I don't find them in the online shops. (We are in ...Show All

• bluestar CHECKDB failed with DB ONLINE and filegroup read-only

  Hello everybody, I have a very stranger problem that I need to understand... I have one DB with 3 files and 2 filegroups (primary and FGTESTE). After to place FGTESTE filegroup as read-only, DBCC CHECKDB  (DBTESTE3) failed with error: Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively locked to perform the operation. Msg 7926, Level 16, State 1, Line 1 Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details. I noticed that if I kill all connections of the database DBCC w ...Show All

• Abarca sql Stored Procedures for MDX Queries

  Is there any way that we can write mdx queries in sql stored procedures So that we can access the stored rpocedures from asp.net. Thanks in advance You can setup a linked server to SSAS on your SQL Server and then use the OpenQuery() function to pass-through MDX queries in a stored proc. This KB article has some examples of how to do this: http://support.microsoft.com/default.aspx/kb/218592 Another alternative would be to use ADOMD.NET to query SSAS directly from ASP.NET. There is an example in the answer on this thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=374777&SiteID=1 ...Show All

• Michael Herman - Parallelspace PAE, AWE and pagefile

  Can you please consider the following scenario: Windows Server 2003 Enterprise Edition (32-bit) SQL 2000 Enterprise Edition Server with 8GB memory 1. If we enable /3GB and /PAE, the server can see and use 8GB memory, OS has 1GB, applications can use the remaining 7GB, can install 2 instances of SQL with a max server mem set to 3GB each, SQL should be able to allocate memory from the upper 4GB RAM. (True / False) 2. We only need to enable AWE if any single instance need to cache more than 4GB of data so we could for example configure one instance with AWE and set the max mem to 5GB and set the second instance to use 2GB max . (True / False). 3. 32-bit windows server OS can support a maximum of 4GB virtual memo ...Show All

• NickNotYet return columns for different sql bases

  I want in one query return columns from tables where exist in different sql bases. In MS Access can link tables from many defferents sql bases or other MSAccess bases and finally can make a simple query where return columns from tables where exist in different bases. How can i have the same functionality in Visual Basic .Net 2005 (or Visual Basic 6.0) If you are using SQL Server, you can use Linked servers (see http://msdn2.microsoft.com/en-us/library/ms188279.aspx ) or for a one time query to another database, you can use the OPENROWSET T-SQL directly in your SQL query (see http://msdn2.microsoft.com/en-us/library/ms190312.aspx ) Regards, Uwa. ...Show All

• cplusplus1 How to change sys_syslanguage SQL Server 2005 for edit column dateformat?

  How to change sys_syslanguage SQL Server 2005 for edit column dateformat. Not posible edit this column http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=955940&SiteID=1 ...Show All

• Itzik Katzav How can I generate xsd files from existing tables?

  I would like to generate xml schema files for my data model for later use with testing tools such as ndbunit. I realize that Visual Studio datasets can be used to do this, however, Visual Studio does not automatically determine table realtionships. I do not want to manually specify these relationships. I also do not have the luxury of using TeamServer for DB professionals. The Database Diagrams feature of SQL Server Management Studio seems capable of determining the table relationships on its own. However, I don't see any way to simply export a databse diagram to an xml schema definition. I realize I could write code to do this myself using the nice APIs under the Microsoft.Sqlserver.management and System.xml namespace, but I'm trying to a ...Show All

• LSepp AS 2000, Excel 2003 and calulated measures

  Hi I have created a calculated measure - which when i view in the Analysis Manager - Browse it displays what I need. In my Excel Pivot Table I cannot see the field when I Show Field List is it possible to have calc members in Excel 2003 however, my initial problem is this (and I am hoping someone can come up with a better solution): I have a fact table that is simply number of hours worked per month and linked to dimensions such as the customer. Each Customer has a budgeted time (which is on the customer dimension) - I need to include this budget. I have a separate cube that is the detail of the budget and I have tried creating a virtual cube - the problem with this is the budget is only visible if I use dimensions from th ...Show All

• Tamila Exception with ReportViewer in local mode

  I use a ReportViewer to display a report in local mode (WinForm). As long as I use VS2005 in debug mode, the report is displayed correct without any problems. If I run the compiled application directly, I get a crash message : "xxx has encountered a problem and needs to close. We are sorry for the inconvenience.".... None of the exception handlings are called (the one where the "Me.ReportViewer1.RefreshReport()" is located and the one from the application "MyApplication_UnhandledException") Thanks for help Peter Hi Panpan, I'm experiencing the exact same problem right now and I can't find out what's the cause. Did you ever figure it out If you did I'd app ...Show All

• Steve Youngs Book

  Hi, Can you recommend a book on SSIS. I am particularly interested in books which demonstrate a particular project from start to finish while going through chapters. Thanks My favourite is MS SQL Server 2005 Integration Services by Kirk Haselden. I also prefer Kirk Haseldens book "Integration Services". It covers all the relevant product features and the author knows what he is talking about. Neither book is based on a case study. If you want a case to study, Project Real is a good start, and includes good documentation. The books stand on their own as good learning and references guides. Professional SQL Server 2005 Integration Services (Wro ...Show All

• GaryPod Foreign Key Constraints

  When following a script to create some tables and constraints, it is recommended that you name the FK constraint Otherwise it appears with numbers after it. Is this the way 2005 creates them or has this always been the naming convention kat It was the case in SQL2000 too. So my original question is, should I always name my pk and fk constraints thx, Kat I suggest you to do so. It's a good habit to have a naming convention. ie: fk_CustomerId is much more meaningfull to a human then seeing letter/digit combinations. PS: Sorry for the doublepost. My browser returned as if previous was never posted. I suggest that you do, otherwise they're n ...Show All

• mtower How to programmatically create "Script Database As"-script?

  I would like to programmatically create the same XMLA-script that one gets from selecting Script Database As->CREATE To->File... in Management Studio. Any thoughts on the simplest way to accomplish this This sample code here is exactly for scripting with AMO (instead of WriteProcess method, use WriteCreate, WriteAlter or WriteDelete): http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=607442&SiteID=1 Adrian Dumitrascu Great work guys! I've used your code to create new cubes on different servers based on a cube 'template' Saved me days of work Thanks! -Tom Came up with the solution. In case anyone else is interested it is ...Show All

• Devin Multiple Select

  Hi, In my report i have a paremeter which is a dropdown list showing alla available values.Now i want to select multiple values.The parameter is not multi valued. From the following link: http://www.ssw.com.au/ssw/Standards/BetterSoftwareSuggestions/ReportingServices.aspx#RichTexbox Multiple select in Parameters Is fixed in Sqlserver reporting services 2005. Iam using 2005 version,But i can't able to select multiple values by holding Ctrl key.How to achieve this.If we able to select the multiple values,In wgich format the selected value is passed to the Stored Procedure,It is same the way as selecting multiple values from Multi valued Parameter. Please help me. Thanks in advance ...Show All

• Indcool SQL Server 2005 Evaluation Install Error

  I downloaded the SQL Server 2005 Evaluation setup .exe. When I wen to install it by clicking "SQLEVAL.EXE", I received an eror stating "There is not enough space on Drive C:\ to extract this package. I have over 50 gig of available spac eon my C drive. What gives When I downloaded the .exe, I had the Norton AntiVirus Auto-Protect enabled. Could that have caused it Also, 2 days ago, I installed MS-Accounting 2007. Could that have caused a problem I have seen this error posted on the SS2005 forums and the standard response is to look at the installation logs. I have no logs. The extraction never completed. Thanks. besides the KB I mentioned above, you might want to try to run the ...Show All