Whats the limitations of data storage in sqlserver DB. How will be the perforamcne if i have database which will get a data of 400 GB per year and all the data should be there in the table the whole year and then it can be archived.
View 2 RepliesI am a Windows developer for the IBM Tivoli Storage Manager Server (TSMS) product.
Our product installation is built with InstallShield and uses the Windows Installer.
On a new installation of Windows 2003 x64 Storage Server R2, at a customer's site, the TSMS product fails to install.
The install of the OS has version 3.01.400.3959 of the Windows Installer and I see no newer version that installs.
Part of our product is 32 bit (console) and another part is x64 (server).
When installing I can see that the install's default is being redirected/reset to C:Program Files (x86)TivoliTSM after it is explicitly set by a custom action to ..Program Files.. . I further observe that our custom actions to write 64 bit registry entries are being refused.
REGSAM samMask = KEY_ALL_ACCESS;
if ( regIsWow64Process () ) samMask = samMask | KEY_WOW64_64KEY;
lStatus = RegCreateKeyEx( hLocalConnectKeyRoot,
szSubkey,
0L,
NULL,
REG_OPTION_NON_VOLATILE,
samMask,
NULL,
hKey,
&dw ) ;
The above fails to create the key.
We have tried four versions of our TSMS spanning many changes but the install acts the same.
This does not happen on any other Windows OS we test on but we do not test on Windows 2003 Storage Server R2 being that it is an OEM product. We did test on Windows server 2003 R2 x64 and do not see this problem.
Do you have any suggestions on how to tackle this problem?
I have full installation traces but can only see that the registry work is being refused. I can't see why.
Here are my planning details:
RAID 1:
2 disks RAID 1 for OS and BINS
2 disks RAID 1 for Backups.
RAID 10
4 disks RAID 10 for data
4 disks RAID 10 for log
4 disks RAID 10 for TEMPDB
Should i put the master and other system database on RAID 10 along with TempDB.
Or what else a guru fellow will advise in above setup.
thanks,
With regards to time zones, daylight savings, and web users, is there a best practice for storing date & time information in a database?
For example, my databases are hosted in Time Zone A, but the web users are in Time Zone B. Then, when I create a rss feed (which is displayed in GMT), I add a third time zone into the mix for the same data. To date (no pun intended), I have been entering the date/time data in the time zone of the database server (Time Zone A), and then converting it using an application setting in the web.config file (i.e. TimeZoneBOffset = -1, GMTOffSet = -5). In other words, each time I display a date I calculate what it should be using the time-zone offset in the web.config. This also enables me to account for changes in day light savings, etc.
My concerns are three fold: 1. What if I move the database to another server and the time zone changes? 2. Right now the users are in only 1 time zone. If I expand it to several then the offset will have to be by users, which is do-able, but something I haven't had experience with in the past. 3. It is likely more efficient to calculate the time zone once on input into the DB, rather than in each use like I'm doing now. What time zone baseline for insert into the db should I use?
Thanks in advance for your help!
PS My application is primarily looking at 'smalldatetime' data - down to the 'minute' level.
How to implement distinct storage tiers on SQL Remote BLOB Storage (RBS)?
I want to use this SQL Feature to move files(images, videos, pdf files) from a database to a distinct database dedicated to RBS. Then I want to have several storage tiers, where objects will be saved and moved according access frequency. Old data will be arquived in cheap storage, but it must be always accessible if needed.
Description:
- 1st and main tier: new and frequently accessed objects stored in high performance storage;
- 2nd tier: automatically move older or less accessed objects to an inexpensive and different storage tier;
- in all cases, all objects must be accessible to all users, but accessing to archived objects(2nd tier) will be much slower;
I am having a problem backing up my database and TLog files due to alack of local diskspace. The db file is about 30GB and the TLog isabout 20GB each on a different hard disk. Each disk doesn't haveenough available space to accomadate a backup. I also can't shrink thefiles because part of that procedure would require a backup.Question: Can I use a redirected drive for the backup media? Is therea way to trick SQL into allowing this? If the answer is no, doesanyone have a suggestion as to want I should do? I am in the processof requesting more disk space,but that could take a while.Thanks,
View 3 Replies View Relatedyes,I have an error, like 'The database file may be corrupted. Run the repair utility to check the database file. [ Database name = SDMMC Storage Cardwinpos_2005WINPOS2005.sdf ]' .I develope a program for Pocket Pcs and this program's database sometimes corrupt.what can i do?please help me
View 4 Replies View RelatedHi,
As SQL Server XE can run on one PC maximum, does it mean that it can't support multi users??? I mean could it be installed on one server and to be used by multiple users connected to server with their PCs?
thanks in advance
what are the limitations in MS SQL Server Express (for a network application)?
hi,
I have a database whose mdb and ldb files are located in C drive.
I need to change these files to D drive.When i go to the database properties
and try to change the location it does not allow me.It has given me a message(The database physical file cannot be changed once it is created).
I can drop the table and recreate it from a BackUp but is there a better way
to do this.
Thank you,
Hi all.
I develop a app on PPC 4.20 using SQLServer 3.1. I developed a o/r mapper whitch auto-creates the Database and Tables using attribute-decorated objects. That all works fine - as long as my Database is in \MyDocuments .
Trying to store the Database in \Storage Card\test.sdf, whitch is absolut neccessary because it will become to big for storing onto device, I get error 25113, "A not supportes operation to host was called" (Translated from German)
When I trie to copy a Database to the SD-Card, inserts are not commited.
Is it not supported to store Databasefiles on a Flashcard?
My development-environment is .net 2.0 sp2, device-emulator v2, Windows XP, vs2005. In the emulator, i have linked a windows-based directory as storagecard.
What am I doing wrong??
class SQLManager
{
private static SQLManager instance = null;
private SqlCeEngine m_cEngine = null;
private SqlCeConnection m_cConn = null;
private SQLManager()
{
m_cEngine = new SqlCeEngine(
"Data Source = \Storage Card\test.sdf");
bool bCreated = false;
if (!File.Exists("\Storage Card\test.sdf"))
{
bCreated = true;
m_cEngine.CreateDatabase();
}
m_cConn = new SqlCeConnection(
"Data Source = \Storage Card\test.sdf");
m_cConn.Open();
if (bCreated)
DoInitialDatabaseSetup();
}
....
}
I was looking around, and I found this info on SQL Server Express:The 4 GB database size limit applies only to data files and not to log
files. However, there are no limits to the number of databases that can be
attached to the server.Does this mean I can use several different databases in my website, like one separate db containing forum entries, and one with user details and related stuff?
We are primarily a DB2 and Oracle shop. There are movements towards SQL Server for smaller applications. We would like to know if anyone out there has shop standards in determining which database should go with what type of application. What we are looking for are possibly database sizes, number of concurrent users, hardware and software cost, network infrastructure, security, scalability, and development tools. Any information would be appreciated.
View 1 Replies View RelatedHi all,I'm looking for some ball park estimates on when SQL Server might startto break down, and can't find any reliable info. Any insight is appreciated.Basically, the situation is this: The database structure is very simple;just one table with about 15 columns and about 60-75 million rows. There'sno need for massaging data or complex relations, just simple searches onmaybe a max of 5 columns. Out of the gates we'll be looking at having 30concurrent users and rapidly expanding to about 300-400 concurrent users.I might need to rebuild the database on a daily or weekly basisdepending on how often changes are made to a master file. In the past I'vebeen bit in the butt with the absolute crappiness of SQL Server'sreplication, so I'm going to try to avoid that path if I can (plus I alreadyhave some scripts written to delete and rebuild a similar database on anightly basis). Would it be practical to destroy and rebuild a database thissize on a daily basis?The big question is if searching 60-75 million records is practical inSQL server. If so, what kind of machine would I need to get a nearly instantresponse time per search (.2 second or so) when everyone's banging on it atonce? How many concurrent users can I expect to be able to practicallysupport before SQL Server will start to bog down? Thanks for your thoughts,-Ringo
View 3 Replies View RelatedWhy is it, Microsoft manage to write operating systems and officeapplications with every bell and whistle facility known to man. Yet,even after years and years of development they still cannot produce adecent version of MS SQL Server, one without a plethora of flaws andlimitations? Personally I'd sack the MS SQL Server Chief Architect,start addressing some fundementals and do what MS do best - copy thebest functionality of their competitors.Here's a few reasons why I feel MS SQL Server is still a load of crap,and will never be many developers RDBMS of choice :1. Can't use domains in Multi-statement table-valued function tabledefinition2. No concept of table.column.datatype MYTABLE.MYCOLUMN%TYPE forfunction / proc parameters, variables. Schema evolution will requirechanges to dep functions / procs.3. Cannot call non extended user defined procedure from within storedproc - prevents code re-use4. No create or replace for functions / procs. Changes to procsrequire either a change from create to alter, or drop then create5. Functions must return result on final statement - requiresexcessive use of local variables. Why!!!???6. No user specifiable date format routines - must use convert withlimited options7. No treewalk mechanism, not easy to traverse hierarchical structure8. Calling procedures with out parameters require user to alsospecifiy which are out params9. Stored Proc recursion limitations to only 32 nested levels, ratherthan monitoring by stack size.10. No on delete set null referential integrity, this is fundementalin relational databases, has to be done by trigger. Yuk.11. No partitioning on db tables12. Cannot raiseerror in stored functions. No way to inform user ofincorrect parameters etc.13. No facility for sub - procs / funcs - for localised codenormalisation.14. No function overloading15. No concept of grouping similar procs / functions into a collectivepackage - can mean 1000s of procs rather than a handful of packages.16. Non standard func / proc calling - proc non parenthesised but,function defined and called with parenthesis17. Limited column name length in table variables / Multi-statementtable-valued function table definitions18. No intersect, minus operators to complement union and union all19. No exception handling - need I say more about this fundementalrequirement?20. No handling for select statements using proc parameters passed inas null e.g.create procedure sp_test.............select @MyID = IDfrom mytablewhere parent_id = @parent_id.If @parent_id is null, select will not return anything even if valuesfor null parent_id exist.21 No boolean type for use in stored procs / funcs. SQL standards doallow booleans (null, FALSE, TRUE)22 No repeat until - (post predicate loops), while loops can performthis but one extra check often has to be performed23 No equivalent to cursor or table %ROWTYPE, when fetching from amany column cursor, all bind variables have to be declaredindividually24. Declarative Delete cascade in SQL Server is at best rubbish - e.g.No table can appear more than once in the list of all cascadingreferential actions that result from the DELETE or UPDATE. Almost allother RDBMS I've tried seems to manage it.Create Table ForKey(MyID int not null identity primary key,MyText varchar(30))goCreate Table Refs(SomeID int not null primary key,RefID1 int not null foreign key references ForKey(MyID) on deletecascade,RefID2 int not null foreign key references ForKey(MyID) on deletecascade)Server: Msg 1785, Level 16, State 1, Line 2Introducing FOREIGN KEY constraint 'FK__Refs__RefID2__1BFD2C07' ontable 'Refs' may cause cycles or multiplecascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, ormodify other FOREIGN KEY constraints.Server: Msg 1750, Level 16, State 1, Line 2Could not create constraint. See previous errors.25. Domains cannot be altered without dropping all dependencies(stored procs / funcs) even if type isn't changed but say scale andprecision- this is ridiculous. What is the point of domains?26. No "for loop", while loops can perform this, but resultant code isnot as clear or tidy27. Can't use CURDATE() inside stored procs / funcs. How crap isthat?Don't try and make excuses for MS as I have hundreds, anyone else haveany?Jeager
View 13 Replies View Related
I have ran into a problem making a database where i have two versions of a book , one in russian and the other in English. The english part worked but when i input the data for Russian it gets replaced each time with question marks. Is there something i have to enable for the SQL database for it to be able to store Russian Text, or is it a DataType i have to set???
THANKS IN ADVANCE
Hello everybody
My office gave me assignment to find out the scope & limitations of the two Microsoft database applications - MS Access and MS SQL Server. After the findings, we have to chose the more appropriate database for our new project, which will have a humble start but may grow big in a year or two.
I will apreciate the info in facts & figures (not only in general).
Hi,
I am currently using the SQL Server Express edition with the intention of upgrading to the full version in the future.
I know the size limitation on the Database is 4GB - however does this include the log file as well? Nothing I read says the log file is included however if anyone can give the definitive answer I would be grateful.
Also my log file maximum is set to 2GB what issues are there with reducing this to say 500MB? I assume SQL Server automatically drops the old log data to add new data when the maximum is reached.
Thanks for your help.
Andrew
I have a Web site that has a database backend, which stores user information. I would like to encrypt the user information in a granular way.
View 16 Replies View RelatedI've created a database design and I'm trying to figure out if it's workable or not. I have 2 tables in particular that are sparse (20 columns, but only a few have data - about 100 bytes/row) but will grow very large - to the tune of 700 million rows.
My question is whether or not there is a problem with SQL Server 2005 having 1.5+ billion rows of data even though it will likely only take up 100 gigs or so on disk. Anyone have experience in large numbers of rows like this? We're still doing testing as far determining how slow queries will get.
Thanks,
Craig
I have a SQL server with multiple instances on it and would like to move one of them to a drive with more storage.
I have SQL 2010 on a server with 2 partitions.
The database is located on the C: drive (original build) but the drive isn't partitioned to handle a db of the size that this one will grow to. I would like to move the full DB instance to another partition.
Hi, I'm not sure if this is where I should post this, but I'm trying to find out what the limitations of SQL Server 2005 Developer Edition (DE) are. I've gone through the Microsoft SQL Server site and they have very little information about the developer edition.Is there a connection limit for DE like 2000 did?
View 3 Replies View RelatedDear,
I'm building an ASP.NET application using C# language and SQL Server 2000. This application is dedicated to be hosted on a VIsta Machine.Unfortunately Vista does not supports SQL SERVER 2000 so i must migrate to the SQL SERVER 2005. Since the application is a small application, we couldn't afford buying an SQL SERVER 2005 License so i decided to use SQL SERVER 2005 Express Edition. But i would like to know exactly what are the Limitation on the Express Edition to see if it will work with my application or No. Please Can anyone refer any document that describes in details all the limitation of the Express Edition ??? Thanks a lot.
Hi,
Apologies for the generic subject heading but I have a client who at my suggestion has implemented a reporting solution using SSRS. However, we are now finding serious limitations with this solution, primarily regarding exporting matrix data to Excel. The major concern is that after exporting matrix data you cannot sort, filter or format properly as we cannot repeat the group data, merged cells is also another big problem.
They are now seriously looking at bringing in different technology to address these problems and I was wondering if anybody had any positive ideas, as to how I can provide a way forward and overcome our issues?
Can I easily add an add-in to the existing export options, does SQL 2008 offer any improvements, are there any 3rd party offerings out there?
Grateful for any advice.
1) SSRS export to Excel functionallity has an important limitation... is terribly slow when exporting huge amount of data to Excel.
2) Subreport are not supported to export in excel. This is some known issue and limitations of SSRS.
I have software that uses SQL Server Express as it's database. I am only able to import so many records until it stops and fails to allow me to import anymore.
I'm very new at this but, is there some type of limitation on Table size that's preventing me from importing anymore data?
I'd really appreciate it if someone could help me,
Thanks... Bill
I'm having an issue in encrypting large documents. I know that previous editions ENCRYPTBYKEY had a maximum size of 8,000 byte limitation. Does SQL Server 2014 have any new features that overcomes this limitation?
Using
SQL Server 2014 Std
Symmetric key with AES_256
The 2.0 version of ASPSTATE is slightly different than the 1.1 version in that one table has one additional column and another table uses a different data type and size for the key. The 2.0 version also has a couple additional stored procedures.
We'd like to manage just one session state database if possible so we're trying to figure out if Microsoft supports using the new schema for 1.1 session state access (it seems to work, but our testing has been very light).
Is there any official support line on this? If not, can anyone comment on whether or not you'd expect it to work and why?
Thanks.
I'm in the situation where we are suffering of poor performance on our SAN storage (VPlex) but it is mainly due to the quantity of data of different types which are on it (other applications, other I/O profile, bad storage usage...). As we plan to dedicate an ESX for SQL Server, we decide to have a new storage type. So we will go with NETAPP Clustered Data ONTAP on NAS technology.
Storage team want to enable only NFS protocol, so I'm wondering how SQL Server will handle that ? I read that NFS wasn't optimize for SQL Server and that block level (SAN) should be preferred.
I need to bulk insert very large amount of data into several MSSQLtables.The first Data model definition used identities to mantain relationshipbetween those tables but we found that natural keys (compound) arebetter forbulk insert (there is no need to obtain the identity first)My question is, changing the identities to natural keys (in some tablesinorder of 4, 5 attributes) will enlarge my database storage?I think MSSQL implements relationships with pointers (or hashcodes), sothestorage size will be similar, right?Regards,
View 3 Replies View Relatedhello forum friends,
i need to know where the database table stored in,
where to find the data table without distrubing the
sql server editor.whtr it is possible to get it from
"C:Program FilesMicrosoft SQL ServerMSSQLData"
or some where else.
Regards
prathap
Does SQL Server 'pre-format' the storage prior to performing the restore and if so where can I find doumentation on the topic.
Thanks,
Scott
I Run All checks for Validation cluster.I get Error On Disk Lists And Validation failed.With This error : Failed to prepare storage for testing on node "server name" The security account manager (SAM) or local security authority (LSA) server was in the wrong state to perform the security operation.
View 2 Replies View Related