4 -5 years ago, I started my career as a translator translating the MetaTexis CAT (Computer Aided Translation Software).
It's amazing to see all the improvements that have been made until now, but recently I found some problems regarding
databases:
I heard that ACCESS databases volume is limited up to 2 GB and that SQL 2005 databases volume is limited up to 4 GB, but I think this information is wrong, or at least I was only able to import 10% of that amount.
Speaking in words, 2 GB doesn't represent a database with a volume of 125,000 segments/sentences (for ACCESS) and 4 GB a volume of 250,000 (for SQL 2005).
Concrete, my "mega.mxtm" database has "only" 359 MB and suddenly I refuses to import more sentences. Is that normal? (MICROSOFT SQL 2005)
Question: Is the new SQL 2008 also limited? Is there any way to "free" or increase the volume capacity?
Point 2: As I updated the SQL 2005 into 2008 I am not able to open the "old" "mega.mxtm" anymore... : (
We are in the process of moving existing clustered SQL server databases to AWS. There is one major database that has intensive reads and writes transactions. I'm wondering what is the best design to optimize the performance for both R/W since we have constant issues historically with the current environment when massive updates are happening. Reads shall have higher priority over writes.
I am copying data from database to an excel file through SSIS. database is MS SQL 2005 and BIDS is also 2005.However, the job doing this task fails every time.As per investigation, the result of the query is more than 100,000 rows and we know that excel has a limit of 65000 rows of data.Is there a way of setting the limit up? or something? a better approach maybe so that everything will be copied to the excel file successfully.
The PrimeOutput method on component "Source - Query" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error Error: 2015-10-22 04:34:58.05 Code: 0xC0047021
Source: Data Flow Task Description: SSIS Error Code DTS_E_THREADFAILED.
Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:30:00 AM Finished: 4:35:05 AM Elapsed: 304.844 seconds. The package execution failed. The step failed. "
Hi, I€™m working in a DWH project the source system have data from passed 30 years and the total number of records from the source system is 10 million.
I€™m need to do the estimation for the data base for the up coming 10 years of data. As I can predict that the 30 year of data is 10 million then expected data for 10 years would not be more then 3 million.
The ETL tool I€™m using is SQL Server Integration services and the reporting tool is Business Objects.
Can any one guide me on the implementation plan, mean memory taken for ETL jobs (As SSIS use large amount of memory) database and business objects.
I am Gokul, I am using SQL Server MSEE 2005 (Free ware). Currently I am involved in the development of an application where I am using SQL Server MSEE 2005 and VB.Net. My incomming data size ranges from 5 GB to 7 GB per day. Can I use SQL Server MSEE 2005 as Data base with any licensing or have to get any license for storing larger capacity data.
I am just starting to build my apps in asp.net 2.0. I have build apss in v. 1.x before using sql server 2000. However, before i make the shift, I would like to know the advantages and disadvantages of using the sql server 2005 express edition then using the sql server 2000. for example;+ How many data can it store?+ How many concurrent users it supports.+ Advantages and disadvantages of using sql server 2005 express ed.+ Any other relevant information that developers should know / beware / watch out for when using sql server 2005 express edition. Note: I am not asking about the actual SQL Server 2005 but the express edition! Regards and thanks in advance
To implement the new SQL 2005, I plan to make the environment easy to manage. The environment should be simple to document and be automated via scripts. Therefore I plan to use mount points as described below.
On a typical SQL server with multiple drives like C, D, E, F, G, H. Where each drive will have various folders to hold SQL code, data files, transaction log files, tempdb files, snapshot files, and other types of files. This typical environment is not pretty and is hard to write scripts for.
So I plan to standardize on one standard directory structure via volume mount point. On all new SQL 2005 servers, we should see drive E as the one and only SQL Server directory. Other drives will be mounted to drive E as shown.
E:
SQLSERVER local folder -sql code for each db instance
SQLSHARED local folder -sql shared tools for all db instances
SQLTLOG1 Drive H -db transaction log
SQLSNAP1 Drive F -db snapshot files
SQLTEMPDB1 Drive H -tempdb main data file
SQLWORK Drive D - DBA work area
SQLDATA1 Drive G -db data files
SQLDATA2 Future Drive -if SQLDATA1 is too large for any direct attached drive, or to get more I/O throughput.
With this implementation, I can easily write scripts to manage the environment. Also if any mounted volume is out of space, we can swap the based drive without doing any change to database configuration. We can also switch from direct attached drive to SAN in the future.
Do you think mount point is safe to use with SQL 2005? I know it is supported.
Do you have a standard directory structure for your environment? How do you do it?
We are creating an enterprise application for fuel, and I am fighting with my DBA about the proper way to store volume and currency in the database. We have 2 main arguments. The first argument is whether we should store costs in the database in $ and convert in the presentation layer, or to store the amount and currency in the database. We sell product from the US in dollar but depending on the customer we may invoice in Euro. Our second argument is the same, execept with volume and UOM. We often purchase product by BBL but sell/transfer by gallon, or Ton.
i am doing a research about high volume database treatment (maybe a database with tera bytes volume) , so is there any optimization or specialization for queries deal with such database? !!
While trying to find a folder on SQL an OLE DB error was encountered with error code
0x80004005 (Login failed for user 'sa'. The login is a SQL Server login and cannot be used with
Windows authentication.).
- Start SQL Server Agent Job (Stopped)
- Execute SQL Server Agent Job (Stopped) -------------------------------------------------
The attach/detach route also fails with the same message. Although I create a SSIS proxy, the Copy Database Wzard shows only the SQLServerAgent as the proxy. Why? ---------- Does copy database wizard use OLEDB for the transfer? Does it mean you must have both Source and Destinaton with windows authentication?
1) I can't get the 'copy database' function to work from SQL Server 2008 to SQL Server 2005. I connect ok. Everything goes to the last step and then it fails.2) I cant get a SQL server 2008 backup to restore on SQL SEerver 2005 either. The only way I know that works is to script the creation of all tables then export and import. This does work. How can I get the 'entire' database, structure and data, from 2008 to 2005? ThanksSQL newbie.
Hi, any1 know how many records can be stored in a table in sql server? is there any way to maximise it? will table capacity (number of records) vary due to our table stucture or database structure? is there any documentation bout tis? Cheerslife's Ng
hi, can any one tell me what is the meaning of capacity planning and where do I get info about it,and how does this help me in sql server admin role thanks
Our development team is doing some stuff in ASP. They are interested only in char and varchar data types. They clearly told us that they are not going with text and image data types.
Is it possible to make a row size behind 8060 bytes in a table without text and image data types?.
We need to do capacity planning for our SQL server database server. Capacity planning is interms of CPU usage, Memory usage and disk usage.
Can anybody help me with how should I start and what are the guidlines to do it? I have started executing perfmon utility with some counters but still not sure what to do next. Please help me. Thanks in advance.
Regards Sachin
Don't sit back because of failure. It will come back to check if you still available. -- Binu
We need to upload over 100 GB file into SQL Server using SSIS. I want to know whether SSIS can upload such huge file in to a table. If yes, How ?. If not is there any work around to achieve this.
Hey - I know that xp_fixeddrives gives me the amount of free space on a drive. Is there a similar (xp) function that will give me the capacity of a drive??? Any help is appreciated. Even if you can just point me in the right direction. Thanx in advance. Billy
I just completed my graduation and eventually i got a proposal from a company to develop a software for database management. I have some doubts about licensing the back-end database. My doubts are:
1. If I'm using Sql Server as the backend and the .sql file placed on the server where this .sql file will be accessed by about 20 clients, will the customer (company) have to purchase a license for the sql server? If yes, how this can be done? Does the company have to purchase a license for each client and server for accessing contents of the .sql file? Actually, there will be only 1 server and abt 20 clients.
2. Does the developer need to purchase a seperate license for distributing the .sql file?
3. Also, wat is the maximum capacity of an sql database size? I'm asking this because as per my requirements, the company will be using the database at a rate of 1GB per month. So, by end of a year, it will be 12 GB.
NOTE: No Sql Server Software will be installed on client machines.
In brief, my doubt is: Do we need license for reading and writting to .mdb or .sql file contents and do we need seperate license for distributing them?
Please, somebody can help me for the licensing information and also for the database size?
I dnt know if this is the right place. I'm sorry for that.
WEll, I just completed my graduation and eventually i got a proposal from a company to develop a software for database management. I have some doubts about licensing the back-end database. My doubts are:
1. If I'm using Sql Server as the backend and the .sql file placed on the server where this .sql file will be accessed by about 20 clients, will the customer (company) have to purchase a license for the sql server? If yes, how this can be done? Does the company have to purchase a license for each client and server for accessing contents of the .sql file? Actually, there will be only 1 server and abt 20 clients.
2. Does the developer need to purchase a seperate license for distributing the .sql file?
3. Also, wat is the maximum capacity of an sql database size? I'm asking this because as per my requirements, the company will be using the database at a rate of 1GB per month. So, by end of a year, it will be 12 GB.
NOTE: No Sql Server Software will be installed on client machines.
In brief, my doubt is: Do we need license for reading and writting to .mdb or .sql file contents and do we need seperate license for distributing them?
Please, somebody can help me for the licensing information and also for the database size? the database will be also used for remote access.
We are currently developing a E-Com research site where subscribed members can conduct market research. The web site is developed and ready to go, however we are undecided what is required on the Database side and could do with some of your expert help.
Users will be conducting research on our MS SQL database. The database holds every product sale made by a select number of consumer good companies. The database holds 12 million records at any one time, however overall the database is very static and is not updated online. We intend to only store 1 months data, therefore on a weekly basis we delete old & add new records.
We are offering three categories of searches on the DB. 1. By Seller 2. By Category (i.e. Hair Care, Laundry etc) 3. By Sale.
The first two searches are not performance intensive as they are compiled and stored in the database - therefore no need for calculation online. Our main concern is the 3rd report. This report is where we allow the user to search for a specified search string. Therefore in the main table that holds all the sales, we have a full-text index for the field "Product Description".
What we are unclear on is the Capacity requirements regarding providing such functionality. I.e What server do we require?
We have researched many articles and have absorbed all the information regarding multiple disk controllers, lots of memory etc.. etc.. However we still have not been able to obtain an idea on what Server would serve our purposes. For example: would the following server do the job?
2 x 2.4Ghz Hyper-threading Xeon CPUs with 512Kb Cache and 400MHz System Bus 2GB Samsung RAMBUS 800-45 Memory (RIMMS / RDRAM)
A lot is determined by the usage, i.e. how many queries are executed per minute etc. At present we do not have a clear idea on the number of users. However we are not truely concerned about this as the 3rd report needs to execute and return within a short period of time. That is our main concern.
Therefore our question is as follows: If you were going to host a database that consisted of 12 million records & full-text indexing which had to be queried in a few seconds, what would you purchase?
We ask you to consider that funds are extremely tight and although the new latest server may do the job, it is most likely out of our budget. We are looking for the most cost effective solution but still statisfying the purpose.
I have been working on SQL Server Capacity Planning for a few weeks now and have gathered a lot of materials, but non of thes materials contain recommended best practices on SQL Server capacity planning and also they do not contain operational guidelines.
I would be glad if anyone can recommend a website or book that contain information on SQL Server Capacity Planning Best Practices.
I installed sql server 2005 sp2 including business intelligence development suite , however I got a message some client components not compablitable .This morning I searched my programs and found that I have new visual studio 2005 on my computer (before I just had vs 2008) as well as business intelligence developer (which does not work) It seems I I would like to get rid of vs 2005 also fix business intelligence studio . Previously I deleted vs 2005 express off my computer........(I have vista and I would only like to keep tools meant for sql standard 2005 reporting services etc here is a list of my sql sp2 install package By the way I doubled clicked sql_tools.msi and did not run as administrator Does that make a difference? I wonder if this is a problem with vs 2008 and sql 2005......
Time: 05/06/2008 20:49:23.437 KB Number: KB921896 Machine: BILLPREC690 OS Version: Professional (Build 6000) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Passed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.00.1399.06 x86 Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD Reporting Services (MSSQLSERVER) ENU RTM 9.00.1399.00 x86 STANDARD Notification Services ENU RTM 9.00.1399.00 x86 STANDARD Integration Services ENU RTM 9.00.1399.00 x86 STANDARD SQL Server Native Client ENU 9.00.3042.00 x86 Client Components ENU RTM 9.00.1399.06 x86 STANDARD SQLXML4 ENU 9.00.1399.06 x86 Backward Compatibility ENU 8.05.1054 x86 Microsoft SQL Server VSS Writer ENU 9.00.1399.06 x86
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID SQLWriter Microsoft SQL Server VSS Writer Service 2700
********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Reboot Required Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 3010 Error Description : ---------------------------------------------------------------------------------- Product : Analysis Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Reporting Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB921896_sqlrun_rs.msp.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Notification Services Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : SQL Server Native Client Product Version (Previous): 3042 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Reboot Required Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log Error Number : 3010 Error Description : ---------------------------------------------------------------------------------- Product : SQLXML4 Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Backward Compatibility Product Version (Previous): 1054 Product Version (Final) : 2004 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Microsoft SQL Server VSS Writer Product Version (Previous): 1399 Product Version (Final) : 3042 Status : Success Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log Error Number : 0 Error Description : ----------------------------------------------------------------------------------
We have a 4 processor 350 Hz NT 4.0 SQL server. Currently we have an application that is inserting rows one at a time, each row insert is a separate transaction. Currenty we are averaging 2500 rows a second with each row ( 56 bytes wide). The data and the log are on one string of Raid disk. We plan to get another controller and raid string to separate the data and the log onto separate controllers. The developer is modifying the application to insert the data in blocks. What is the impact to the transaction log? He seems to think that by inserting page blocks on rows there would be less data going into the transaction log. Why would this be so? Does anyone have any information on practical limits for inserts and log truncation with similar machine configurations. He would like to try to get around 150,000 rows a second. Has anyone accomplished inserts at this rate? What type of machine configuration?
I have a summary table with a 9 field composite primary key. Every 10 minutes, my system generates 2 files of 500,000 to 750,000 rows to be summarized into this table. I first Bulk insert those into a temp table, and then trigger an inner-join update query to do the updates, followed by a left-outer join to do the inserts. As the day goes on, millions of rows in my summary table, this process is too slow. Any ideas about causes/solutions???
I Have not been able to solve this problem from quiete a while now.
I am using sql server 2005.
I have got a table which contains these columns - start date, end date and volumes if the month in the start date is same as that of end date, the volume remains same, else if the months in the two dates are different, then i have to distribute the volume in such a way that some part will go in the first month and the rest in the other month.. i have to somehow calculate (or prorate) the volume according to the no of days in each month
I have to perform a query on this table so that I can group the volumes for different months and different years.
