rlcoach
Hi,
I would like advice regarding what hardware to use for a SQL Server 2005 for use in a development environment. I am the only developer and user of the database.
I develop at home, and currently use one PC, to develop the software. My PC is Athlon XP 4000, 2 Gig RAM, 1 x 160gb HD . I am developing an asp.net website along with a variety of data interface applications in C# - all on top of SQL Server 2005. This environment works/worked fine until I started dealing with a lot more data.
I now have 2 databases, each about 30 gig in size (with most of the data in a a couple of tables in each database). When I am importing data or running the website or doing intensive queries or doing sql updates that change millions of rows, I am understandably hitting performance problems. I have had to throttle SQL Server 2005 to only use 400mb, as I have so many other development applications that are open...... Everything is slowing to a halt, and I dont think SQL Server is very happy.
So, I am looking to build or buy a cheap machine to run SQL Server 2005, and take the load off my current PC. However I only have a budget of about ¡ê300/$560 - maybe a bit more at a push (I could possibly upgrade in the future).
I could do something like below, if I am going to buy a machine
Acer T180
Sempron 3200
512mb (i would upgrade to 2GB)
80gb hard disk
Or I could build my own If I do, what should I skimp on and where should I invest more. I.e. should I get the cheapest processor possible, and get a decent harddrive or 2 Should I raid 0 a couple of small drives Or have one drive for data and one for the transaction logs Or should I have one drive, and spend more on RAM
Any help would be greatly appreciated....
Andrew
SQL Server 2005 - Building a development Server
SQL Server Setup & Upgrade
-
- Previous
- 1
- Update Help Needed 05 SQL? Hey all... I'm trying to update current row values in a table having some trouble... I have this: SELECT ROW_NUMBER () OVER ( ORDER BY ( SELECT 1 )) AS GetRowNum , PropDLine FROM ProposalDetail WHERE ( ProposalDetail . PropDNumb = 123 ) AND ( ProposalDetail . PropDRevNumb = 1 ) This returns: GetRowNum PropDLine 1 1 2 1 3 1 4 1 5 1 6 1 And need to Update the PropDLine column with the row position values from GetRowNum... UPDATE ProposalDetail SET PropDLine = ( SELECT ROW_NUMBER () OVER ( ORDER BY ( SELECT 1 )) AS GetRowNum ) WHERE ( ProposalDetail . PropDNumb = '123' ) AND ( ProposalDetail . PropDRevNumb = '1' ) Any help using OVER would be very much appreciated... Thanks. Bill Tag: SQL Server 2005 - Building a development Server
- 2
- positive and negative signs i have account_entries table which has the following fields: debit_or_credit entry_amount and I want when inserting every field to check if the inserted row was assigned to (D)ebit and (C)redit it should change the entry_amount accoridanly. maybe something like trigger plz help... Tag: SQL Server 2005 - Building a development Server
- 3
- error running ssis package I run an ssis task with right click in the BIDS. the task transform data of the tables between sql2005 DB to another sql2005 DB. this is the error I get: Code Snippet An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: " TCP Provider : The semaphore timeout period has expired . ". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}" . Task failed : CopyTables2 i have a similar task, only diffrent tables that being transfered, same settings. this task run succesfully. for the task that fails it takes a long time to run (something like half an hour, maybe more) and then it falils. the task that succeeds finish fast (something like 5 minutes). the data in the tables that being transeferred in the good task is much smaller than the data in the tables in the failed task. Anyone knows the reason to the error. Thanks. Tag: SQL Server 2005 - Building a development Server
- 4
- Where did the fields go? Using Visual Studio 2003 and an ODBC connection to an Oracle 7 database I created a dataset with the following query: SELECT ITEM, REV,QTY FROM MYDB.CONTRACT WHERE CON_NUM = 'CONTRACT_NUMBER' All is well until I change the contract_number to a parameter using either or a named parameter. Report users will choose the parameter value from a drop down list generated by another query. Although the parameterized query will still run via a prompt dialog, the report field list disappears and many errors occur. Does anyone know why this happens to the fields and how to retrieve them Thanks, PH BTW: ODBC connections seem to be the only type that will accept parameter queries to this version of Oracle. Tag: SQL Server 2005 - Building a development Server
- 5
- SQL 2005 Won't Start after moving Model Database with Alter DB command I used the code below to move the Model database and Model log file to new SAN drive locations. After running the commands I stopped the SQL server and moved the physical files to the correct location. Now I am unable to start SQL server, I get error 17204 Could not open file:Access is denied I think the problem maybe that for FILENAME new_path I put "J:\SQL Server\MSSQL.1\MSSQL\Data" but did not include model.mdf in the file path. How do I correct the path now that SQL service won't start I have included the log file below. ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path/os_file_name' ) 2007-09-11 13:19:31.82 Server Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) 2007-09-11 13:19:31.82 Server (c) 2005 Microsoft Corporation. 2007-09-11 13:19:31.82 Server All rights reserved. 2007-09-11 13:19:31.82 Server Server process ID is 3264. 2007-09-11 13:19:31.82 Server Authentication mode is MIXED. 2007-09-11 13:19:31.82 Server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. 2007-09-11 13:19:31.82 Server This instance of SQL Server last reported using a process ID of 2648 at 9/11/2007 1:10:02 PM (local) 9/11/2007 8:10:02 PM (UTC). This is an informational message only; no user action is required. 2007-09-11 13:19:31.82 Server Registry startup parameters: 2007-09-11 13:19:31.82 Server -d D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf 2007-09-11 13:19:31.82 Server -e D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG 2007-09-11 13:19:31.82 Server -l D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf 2007-09-11 13:19:31.84 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2007-09-11 13:19:31.84 Server Detected 4 CPUs. This is an informational message; no user action is required. 2007-09-11 13:19:31.96 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required. 2007-09-11 13:19:31.98 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. 2007-09-11 13:19:32.00 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. 2007-09-11 13:19:32.00 Server Database mirroring has been enabled on this instance of SQL Server. 2007-09-11 13:19:32.00 spid5s Starting up database 'master'. 2007-09-11 13:19:32.09 spid5s SQL Trace ID 1 was started by login "sa". 2007-09-11 13:19:32.10 spid5s Starting up database 'mssqlsystemresource'. 2007-09-11 13:19:32.10 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required. 2007-09-11 13:19:32.26 spid5s Server name is 'SS02'. This is an informational message only. No user action is required. 2007-09-11 13:19:32.26 spid9s Starting up database 'model'. 2007-09-11 13:19:32.26 spid9s Error: 17207, Severity: 16, State: 1. 2007-09-11 13:19:32.26 spid9s FCB: pen: Operating system error 5(Access is denied.) occurred while creating or opening file 'J:\SQL Server\MSSQL.1\MSSQL\Data'. Diagnose and correct the operating system error, and retry the operation. 2007-09-11 13:19:32.26 spid9s Error: 17204, Severity: 16, State: 1. 2007-09-11 13:19:32.26 spid9s FCB: pen failed: Could not open file J:\SQL Server\MSSQL.1\MSSQL\Data for file number 1. OS error: 5(Access is denied.). 2007-09-11 13:19:32.26 spid9s Error: 5120, Severity: 16, State: 101. 2007-09-11 13:19:32.26 spid9s Unable to open the physical file "J:\SQL Server\MSSQL.1\MSSQL\Data". Operating system error 5: "5(Access is denied.)". 2007-09-11 13:19:32.26 spid9s Error: 17207, Severity: 16, State: 1. 2007-09-11 13:19:32.26 spid9s FCB: pen: Operating system error 5(Access is denied.) occurred while creating or opening file 'I:\SQL Server\MSSQL.1\MSSQL\Data'. Diagnose and correct the operating system error, and retry the operation. 2007-09-11 13:19:32.26 spid9s Error: 17204, Severity: 16, State: 1. 2007-09-11 13:19:32.26 spid9s FCB: pen failed: Could not open file I:\SQL Server\MSSQL.1\MSSQL\Data for file number 2. OS error: 5(Access is denied.). 2007-09-11 13:19:32.26 spid9s Error: 5120, Severity: 16, State: 101. 2007-09-11 13:19:32.26 spid9s Unable to open the physical file "I:\SQL Server\MSSQL.1\MSSQL\Data". Operating system error 5: "5(Access is denied.)". 2007-09-11 13:19:32.26 spid9s File activation failure. The physical file name "I:\SQL Server\MSSQL.1\MSSQL\Data" may be incorrect. 2007-09-11 13:19:32.26 spid9s Error: 945, Severity: 14, State: 2. 2007-09-11 13:19:32.26 spid9s Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. 2007-09-11 13:19:32.26 spid9s Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized. 2007-09-11 13:19:32.26 spid9s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. Tag: SQL Server 2005 - Building a development Server
- 6
- An OLE DB error has occurred - Description: "Class not registered" Hi I have a package the connection of which is defined in a config file. When the source is on SQLserver, the package executes fine but when i change the connection to Oracle then i am getting this error. TITLE: Microsoft Visual Studio ------------------------------ Error at DMND_PROBS_EXTRACT [Connection manager "DLWSDV18.PM"]: An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Error at DMND_PROBS_EXTRACT [DEMANDPROBLEMDETAILS [1]]: The AcquireConnection method call to the connection manager "DLWSDV18.PM" failed with error code 0xC0202009. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK ------------------------------ Please let me know if theres any solutions. Thanks, Vipul Tag: SQL Server 2005 - Building a development Server
- 7
- 1 Flat file to 2 destination tables with different mappings :Please Help Here is the Scenario. I have a flat file with name " Employee.txt " (Full url: C:\Employee.txt ) .The File content is like this Anil,Engineering,1997 Sunil,Sales,1981 Kumar,Inventory,1991 Rajesh,Engineering,1992 ( Note: Items are Comma Seperated ) Now, i have a SQL Server database called " EmployeeDB" which has 2 tables " TblEmp1 ", " TblEmp2". The Table is like this. TblEmp1 : Columns EmpName EmpDept EmpjoinDate TblEmp2 : Columns EName EDate Edept using integration services (SSIS) i need code(vb.net or c#) to Create a dtsx package so that i can push the flat file content to these 2 tables. And the condition is : After Executing the package Data loaded in TblEmp1 should be like this EmpName EmpDept EmpjoinDate Anil Engineering 1997 Sunil Sales 1981 Kumar Inventory 1991 Rajesh Engineering 1992 (No change in order compared to source) And Data loaded inTBLEmp2 should be like this EName EDate Edept Anil 1997 Engineering Sunil 1981 Sales Kumar 1991 Inventory Rajesh 1992 Engineering Now, i know that we need to do like this in wizard 1) Create a flat file source component. 2) Create flat file connection and set the properties of flat file (delimeters and other things) 3) Create a Multicast Component. 4) Create a Path between Flat file source and Multicast. 5) Create 2 destination component(each for a table). 6) Create path from multicast to 2 destination components 7) Create a OledbConnection and set table names for 2 destination components.. 7) Now,i have to do mapping for destination1. 8) Now, i have to do mapping for destination2( this mapping will be different from mapping done for destination1 because iam not inserting the data in the same order in which iam doing for TBLEmp1. I have done it in wizard.I need to do it through code and i know that its not complicated.Please find the attached file with this mail.i have attached a screen shot of how i have done in wizard.The main problem is Mapping differently for 2 destinations from source.for 1st one we can have a forloop for mapping.but for 2nd one iam confused!! Tag: SQL Server 2005 - Building a development Server
- 8
- Algorithm to populate a table with finite value combinations I need to populate a table which have 10 columns with four values. Each row should be a different combination of these four values and the columns can be null too. In other words how can I get all the different combinations for the 4 values that can be in 10 buckets. The final result column based on these values will be generated manually. For example , I have for grades (P,F, WP, WF) and I have 8 terms and two exams. 8 terms and two exams can have any of the above four values. Based on these grades and terms and exams I need to generate a table which wil be used to determine the student final status Pass/Fail. What will be the best way to do this and how is it possible. Is there a T-SQL or C# program for this. If I need to submit this in another forum please let me know. Tag: SQL Server 2005 - Building a development Server
- 9
- What DataType is best ... float, double or decimal? I am using sql express 2005 and sql server 2005 with C# 2.0. I am a bit confused about which data type i should be using for several fields. Right now I am declaring all of my fields in sql server as float for everything except for money fields which are using money. When loaded into C# these fields are converted to double and decimal because C# does not have a float datatype. Should I be using Decimal or Double for everything instead Here are a few examples QtyInvoiced (float) - holds the number of items invoice possible values look like this 1.0, 1.25 or 1.5 PercentDiscount (float) - holds a percentage possible values look like this 10.25, 20.50, 50.00 I appreciate the help. Tag: SQL Server 2005 - Building a development Server
- 10
- How do you make a Report Parameter Invisible??? Hi, I have 3 report parameters. If a user selects 'value1' from the first parameter list then parameter list 2 & 3 should be open for the user to make their selection. BUT if the user selects 'value2' from parameter 1 then only parameter list 2 should be open and parameter list 3 invisible. Is this possible Tag: SQL Server 2005 - Building a development Server
- 11
- Documentation of RMO and Merge Replication Hi there, In a lot of the Replication documentation it only refers to the merge agent operating in the context of a push or a pull configuration. i.e. if it is push then the merge agent is at the distributor but if it is a pull then the merge agent functions at the subscriber. I recently joined a project which is configured as a push but it uses RMO for synchronisation. This RMO application is installed on a compeletely separate server. Initially I thought the RMO was just passing requests through to the publisher/distributor/subscriber but the distributor didn't seem to be doing any of the work. It therefore seems that the merging/synchronisation is being performed on this RMO application server and not the distributor or subscriber. I therefore think it would be good (assuming I am correct of course) that the documentation reflects this caveat As a general observation Replication programming seems to be quite detached from the rest of the replication documentation. Is this a deliberate decision Tag: SQL Server 2005 - Building a development Server
- 12
- sp_send_dbmail generate ansi file attachment format In sqlmail, it uses "@ansi_attachment=true" to set up your attachment as ansi format. is there any way to do the same in sql server 2005 Tag: SQL Server 2005 - Building a development Server
- 13
- CUBE FAILING/HANGING Dear friends in my previous post i was told that analysis services 2005 does not suport "custom roll up" and hence misrcosoft had introduced 2 new functions "last non empty and first non empty" for semi additive measures. But whenever im trying to bring the semi additive measure in the browser window of my cube, the cube gets hung and i have to finally close it w/o getting any analysis....please help To clarify u can take the example of the measure "closing stock" where u want that across time dimesnion it should alwaz return the last member at the year,half year,quarter,month and day level while across other dimensions like product,customer etc it should be the normal aggregation. Tag: SQL Server 2005 - Building a development Server
- 14
- about update when transfering data from text file to sql server using dataflow how can i update a record if it exists.Is it not possible to use or call stored procedure in the dataflow. please let me know Tag: SQL Server 2005 - Building a development Server
- 15
- printing error Hi, some of my application users doesn't have Admin Privileges to their machines. When they try to print the reports, its giving a message "Unable to load client print control". Please help me how to solve this problem Tag: SQL Server 2005 - Building a development Server
- 16
- ODBC Connection Fails from cluster node I had a stand alone sql server that I upgraded to a cluster. I have an odbc connection called my_connection. The odbc test works fine. When I call the dsn from a php script it fails with this message: Warning: odbc_connect(): SQL error: [Microsoft][ODBC SQL Server Driver][DBNETLIB ]SQL Server does not exist or access denied., SQL state 08001 in SQLConnect in D :\storage\test.php on line 3 Could not connect to my_connection! This same script works fine from any other computer. Is there an issue with connecting to a virtual server from the node via ODBC Is there something I need to change in the client protocols Thanks in advance. Tag: SQL Server 2005 - Building a development Server
- 1
- Next
- 1
- Silent install using VBScript Hi, how do Silent Installation with VBscript because I have some step for user interactive. please anyone put an example about this or put a link to. thank you very much. Tag: SQL Server 2005 - Building a development Server
- 2
- Sql Server Reporting Services 2005 returns 404 not found I just installed Sql Server Reporting Services 2005 on a Windows Server 2003 R2 x64 server. I configured Reporting Services through the Reporting Services Configuration tool and everything has a green checkmark. I'm trying to connect to the webservice, but keep getting 404 not found errors. I've tried putting the following into a web browser and all return a 404 error: http://msql01/reports/ http://msql01/reportserver/ http://msql01/reportserver/reportservice.asmx wsdl http://msql01/reportserver/reportservice2005.asmx wsdl I've tried edting the RSWebApplication.config file using the following configurations (restarting IIS afterwards) without any luck: <UI> <ReportServerUrl></ReportServerUrl> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel> </UI> and <UI> <ReportServerUrl>http://msql01/ReportServer/</ReportServerUrl> <ReportServerVirtualDirectory></ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel> </UI> Any help is appreciated! Thanks, Rob Tag: SQL Server 2005 - Building a development Server
- 3
- exception handling - best practices hi all, not sure this is the correct section to post this, but couldn't find a more appropriate one. we are debating on sql exception handling usage and we could'nt have an agreement on whether we should trap constraint exceptions with a try-catch block or check them before executing insert/update/delete statements. one of my collegues insist that constraint exceptions should be considered in terms of error handling rather than exception handling and should not be handled by sql exception handling mechanism. He suggests to use "if exists" before every insert/update/delete as a constraint check inside a try block, so that only the records which are changed just after the if exists statement had executed may cause exception. Briefly, it boils down to this: begin try insert into table_with_some_constraint_that_is_about_to_be_violated t values a,b,c end try begin catch IF (error_number() == 2627) return 1000 -- our inproc. return code for duplicate. ELSE RAISERROR('error_message_here', 11,1) end catch OR begin try IF (NOT EXISTS( SELECT * FROM table_with_some_constraint_that_is_about_to_be_violated t WHERE x=a AND y=b AND z=c)) insert into table_with_some_constraint_that_is_about_to_be_violated t values a,b,c ELSE return 1000 end try begin catch IF (error_number() == 2627) return 1000 -- our inproc. return code for duplicate. ELSE RAISERROR('error_message_here', 11,1) end catch thanks in advance Tag: SQL Server 2005 - Building a development Server
- 4
- Scheduling an automatic backup Hi , I am using Microsoft SQL Server Management Studio Express 9.00.3042.00. I want to take the database backup daily at specific timing for instance, 8:00am daily. How can I take it automatically It should be take the backup on daily basis without my interference. with programatically Can anyone help me i neeed answer with clear example or screen shots. Thanks in advance Tag: SQL Server 2005 - Building a development Server
- 5
- Using Integrated Security from .Net Web to access SQL Server 2005 If I am posting to the wrong forum, please point me in the right direction. We have upgraded to SQL Server 2005 and Window 2003 from SQL Server 2000 and Windows 2000, and have been having all kinds of problems with security of our web applications. We have been forced to put the system account of the web server as a user in the database in order for the web applications to work. We have lost the ability to control security at the user/role level. Is this the way security is going to work in Windows 2003/SQL Server 2005 How do I use integrated security so that I can secure web pages and database objects Thanks Tag: SQL Server 2005 - Building a development Server
- 6
- Accessing the underlying sql query from the rdl file Our client uses the report builder to generate reports for collection of employees. We would like to use the employee records in this report to perform some additional processing (such as the list of employees gets assigned to a particular group). Programmatically, I can retrieve a byte stream from rs.GetReportDefinition( "\myClientEmpReport") and deserialize the stream into Report object (as define by ReportDefinition.xsd). I can then manually drill down and retrieve the SematicQuery xml from the commandText field. The problem is how to convert the SemanticQuery format into a T-Sql query that I can run against the view that the report model is based off of. Is this possible Thanks, Arjay P.S. Running SQL 2005 Reporting Services, VC# 2005, ASP.Net 2.0. Tag: SQL Server 2005 - Building a development Server
- 7
- IBM DB2 as Data Source Hi, I need to connect to a IBM DB2 database as a source in the Data Flow Task. However, I am not able to figure out which is the provider I should be using. It will be great if you can help me with that. Thanks in advance. Regards, B@ns Tag: SQL Server 2005 - Building a development Server
- 8
- Reporting Services 2005 Subreport issue... I'm new to Reporting Services 2005. I have a sales report that displays monthly sales figures for a sales rep. I have a subreport that displays a single cell with a value that I then need to subtract from my monthly sales figure for an adjusted total. Is there no way to return a value from a subreport I've done this using Crystal Reports before and I've looked for hours on end on the web for a RS solution. I can't believe I'm the only one that ever needed this. Tag: SQL Server 2005 - Building a development Server
- 9
- SSIS Data Conversion: Convert a String (like yyyymmdd) into Datatype dt_DBDATE or dt_DBDATE Hi All, I need a solution for the following: I have a field with datatype string, length 8, in the form yyyymmdd (f.e. 20070604). Now I need to transfer this field into a field with datatype dt_DBDATE or DT_DBDATE. I tried to perform this with a derrived column and type cast (DT_DATE) or (DT_DBDATE), but this does not work. Any hint for me!!! Thanks in Advance ulrike Tag: SQL Server 2005 - Building a development Server
- 10
- SQL Compilation and execution plan Hi all, I¡¯m having a test regarding to the image data type. The test program is written with sql native api and just update the image data type column, but I looked the SQL Compilations/sec and Batch Requests/sec counters in SQLServer: QL Statistics using Perfmon, both values are almost the same. It seemed whenever the stored procedure is called, SQLServer compiles it and makes execution plan again. But when I had a test without image data type, SQL Compilation/sec was 0. SQL version is Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) (Build 2600: Service Pack 2). Is SQL server working the way expected or am I missing something Tag: SQL Server 2005 - Building a development Server
- 11
- SQL Reporting Services - Page X of XX counts in header I have searched high and low for how to calculate page numbering in the header where the global values do not apply. I have a report that generates 300+ invoices and I need the page numbers to reflect page x of xx for that invoice only. My report page breaks for each customer invoice. I have found code to get the page number in the header and I have found code to get the total pages in the body. These two solutions cannot be combined. Has anyone found a workaround in code behind or some other method I would appreciate any guidance. Side note: thank you all for all your postings and solutions. They have been highly valuable as I am new to SSRS. Tag: SQL Server 2005 - Building a development Server
- 12
- Export to Excel Hi, When our report exported to Excel, In the Excel file it is giving some extra columns between the data columns.How to avoid those extra columns.This extra columns causes problems when we want to sort one column it is throwing sort can't be applied on merged columns. How to avoid the Extra columns. Thanks in advance Tag: SQL Server 2005 - Building a development Server
- 13
- ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available I've read about this hotfix at http://www.kbalertz.com/Feedback_933097.aspx but I can't find anything on microsoft.com about it. It sounds like a worthwhile hotfix, but I'm wondering about the absence of an announcement on microsoft.com. Anyone else know about this hotfix Thanks! Tag: SQL Server 2005 - Building a development Server
- 14
- Layout question We have a report that is printed landscape and contains a main table with values. Inside this table we also want to create a "sub-report" table based on two other criteria (charges and credits), but this data is still grouped with the main table. Here is a simple schematic of the report XXXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXX Charges XXXXXXXXX XXXXXXXXX Credits XXXXXXXXX XXXXXXXXX XXXXXXX We have placed a rectangle in the last column of the main table to accomodate two other "sub-tables": one for Charges and the other for Credits. We need to keep the heighth of each row in the main table the same (without extra white space) so we cannot move the second table for Credits below the table for charges. I hope this makes sense and anybody with any suggestions, it is appreciated. Tag: SQL Server 2005 - Building a development Server
- 15
- Flat File Data Source with variable number of delimited columns I am writing a package that will process delimited flat files that will come in one of a few different versions. Within each flat file, the number of delimited columns will be the same, but each version of the file has a different number of columns. I have tried configuring the flat file data source to expect the version with the largest number of columns, but it will then throw away rows that have less than this number of columns (warning: There is a partial row at the end of the file). Is it possible to use a single flat file data source that will work with all of the different width files Tag: SQL Server 2005 - Building a development Server
- 16
- Stuck on a Inner Query Please help, I want to do a select query selecting the ID (from table 1) for where the person is under 18 and if there has been an episode (table 2) done on the person in the last 12 months (ie. Start date). The problem I¡¯m having is that there may be more than one episode that has been done. I think I need a query something like this Select t1.id from table1 t1 Where Exists(select * from table2 t2 Where t2.start_date> dateadd(m,-12,getdate()) And T1.dob>getdate() Table 1 People DOB ID 100 23/2/1980 101 12/12/1968 102 1/1/2000 103 12/12/2003 Table 2 Episode People Start_Date 45 100 30/01/2003 46 100 12/01/2007 47 101 01/01/2002 48 103 19/2/2007 Result People ID 100 103 Tag: SQL Server 2005 - Building a development Server
- 1
- Previous
Re: SQL Server 2005 - Building a development Server
Arnie Rowland
For this purpose, I suggest something similar to a 2.0 or higher dual core CPU, 1 GB memory (2 GB would be better), 80GB or larger SATA 7200 rpm disk.
Somethink like a Dell 520 desktop would work just fine. You won't need a monitor/keyboard/mouse -you will be using a KVM (get a four port KVM to allow for future additions).
For your purposes, RAID seems overkill. If the data is critical (unlikely in a DEV environment), you could get a second drive and use the OS mirroring capability.
Re: SQL Server 2005 - Building a development Server
rlcoach
Do you think I could get away with just one disk, or do you think I should get two and seperate the data and log files
Arnie Rowland wrote:
For this purpose, I suggest something similar to a 2.0 or higher dual core CPU, 1 GB memory (2 GB would be better), 80GB or larger SATA 7200 rpm disk.
Somethink like a Dell 520 desktop would work just fine. You won't need a monitor/keyboard/mouse -you will be using a KVM (get a four port KVM to allow for future additions).
For your purposes, RAID seems overkill. If the data is critical (unlikely in a DEV environment), you could get a second drive and use the OS mirroring capability.
Do you think I could get away with just one disk, or do you think I should get two and seperate the data and log files
Re: SQL Server 2005 - Building a development Server
Arnie Rowland
I guess it comes down to money and purpose. If you have the $$, additional disks would be very useful. However, this is a development server -not a performance testing server. You can probably live with one disk, then if (and when) you decide that another disk is worthwhile, you can add one. (Or you can add another one upfront.) I have set up many development servers with only one disk.
I guess it comes down to money and purpose. If you have the $$, additional disks would be very useful. However, this is a development server -not a performance testing server. You can probably live with one disk, then if (and when) you decide that another disk is worthwhile, you can add one. (Or you can add another one upfront.) I have set up many development servers with only one disk.
Re: SQL Server 2005 - Building a development Server
rlcoach
After considering all my options in depth I have decided that I will upgrade my current machine. I looked into the problems I have been having and most of the slow performance seems down to IO. I have ordered an extra gig of RAM and couple of 160gb hard disks. I will add them to my machine and use one new drive for sql server data files and the other drive for log files.
Hopefully this will bring adequate performance, and I will be able to continue using my development machine as a sql server.
If I still have problems, I will look into buying a new machine, and will swap the 2 new drives over.
After considering all my options in depth I have decided that I will upgrade my current machine. I looked into the problems I have been having and most of the slow performance seems down to IO. I have ordered an extra gig of RAM and couple of 160gb hard disks. I will add them to my machine and use one new drive for sql server data files and the other drive for log files.
Hopefully this will bring adequate performance, and I will be able to continue using my development machine as a sql server.
If I still have problems, I will look into buying a new machine, and will swap the 2 new drives over.