Sudarshan And Korth Online Book Of RDBMS
Sep 1, 2004Can anybody give me information that where i can found he online edition of Sudarshan and Korth's DBMS book
Regards
Praveen Kumar Pandey
ADVERTISEMENT
Free Online Book For Sql Server 2000
Mar 7, 2006i am new to sql. plz let me know from where can i get free book to study sql server 2000.
View 3 Replies View RelatedRecovery :: Server Cluster Resource Fails To Come Online And Pending Online State
Nov 3, 2015We have SQL cluster installed on top of windows cluster on VM environment. Node1 and Node2 under Windows Failover Cluster. SQL instance is currently on node2 the instance is up and running, but SQL Cluster service remains online pending and it restarts the instance on every 5 minutes.
SQL Browser service are running successfully.TCP/IP ports are enabled and configured.If we start the SQL server agent it is on for seconds and stopped immediately .Cluster Service is attempt to connect to the SQL service every few minutes (setting in SQL cluster resource) for the IsAlive check, if this fails then the SQL resource is restarted even if the instance was online. Hope this is what happening exactly.
[sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 ERR [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00001024.00053314::2015/10/30-19:57:50.772 ERR [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server
Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books
Online. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 INFO [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] Could not connect to SQL Server (rc -1
Write The Following Queries In SQL (was Very New To RDBMS)
Mar 9, 2005Trying to work on INNER and OUTER JOIN. Can someone help me to write to SQL statements.
Thanks
Sam
Consider the following schema:
suppliers(sid: integer, sname: string, address: string)
parts(pid: integer, pname: string, color: string)
catalog(sid: integer, pid: integer, cost: real)
Write the following queries in SQL:
1. Find the pname of parts for which there is some supplier.
2. Find the snames of suppliers who supply every part.
3. Find the snames of suppliers who supply every red part.
4. Find the pnames of parts supplied by Acme Widget Suppliers and no one else.
5. Find the sids of suppliers who charge more for some part than the average cost of that part.
6. For each part, find the sname of the supplier who charges the most for that part.
7. Find the sids of suppliers who supply only red parts.
8. Find the sids of suppliers who supply a red part and a green part.
9. Find the sids of suppliers who supply a red part or a green part.
10. For every supplier that only supplies green parts print the name of the supplier and the total number of parts that she supplies.
11. For every supplier that supplies a green part and a red part, print the name and price of the most expensive part that she supplies.
What So Special About PostgreSQL And Other RDBMS?
Jul 20, 2005Beside its an opensource and supported by community, what's the fundamentaldifferences between PostgreSQL and those high-price commercial database (andsome are bloated such as Oracle) from software giant such as Microsoft SQLServer, Oracle, and Sybase?Is PostgreSQL reliable enough to be used for high-end commercialapplication? Thanks
View 49 Replies View RelatedHow To Handle Large Outputs From RDBMS
Nov 30, 2014Obviously Excel is the tool of choice for most people but with it's limited ability to leverage RAM (32 bit) and it's limitation with rows at just over 1 million what other choices do we have for viewing data?
My bosses boss created several OLAP universes and they seems to fly a lot fast than regular relational database. This still doesn't work with the fact the data can't be worked with unless you have a strong front end that can handle processing all those rows.
Using Non-SQLServer RDBMS Data Sources
Jul 3, 2007We're looking at using SSRS for all our new reporting requirements. However, we use SQLServer(2000 and 2005), Ingres and Postgres DBMSs. Ideally, we'd like to use SSRS against databases within all 3 DBMS. Ingres can be accessed via ODBC, JDBC, and has a .NET data provider, but no oledb data provider. Postgres can be accessed via ODBC. Reading some of the threads on this forum, there appears to be some limitations on the features of SSRS that can be used when accessing a database via ODBC compared to OLEDB. I'd like to understand these limitations if they exist so that we can work round them. Could anyone point me in the direction of a document that covers this issue, or outline what the issues are.
Many Thanks
Tony.
Creating Company's RDBMS Development Review Group
Feb 22, 2008Hello,
I've proposed to the head of IT at my organisation to head an database development export group to:
- Provide assistance in improving the performance of existing relational databases
- Provide assistance for the development of new database, e.g. correct construction of indexes; data contention, etc.
- Creation of database development standards
- Enforce the above standards for new databases so that the database is not deployed to production servers until it passes the standards.
I'd really like this to be a success as it should improve our rather crappy databases, basically because the people currently creating the databases don't know much about relational design.
Can anyone please post their experiences of setting something like this up, or working on such an expert group where they work? I'd really like to hear the good and bad experiences and what and (what not) to avoid.
Thanks
FLAT File Indexing Vs RDBMS Indexing
Sep 22, 2006Hi
I want to know is a flat file faster than a RDBMS for indexing for example a search engine indexing would a flat file be better in terms of performance, scalability etc than a RDBMS?
Get Db Online
Mar 16, 2006Hi
I have made a small mistake while restoring the DB I selected the 3rd option in the em
Leave the DB read-only and able to restore additional transactional logs
I have just realized that all I have is a complete back up to restore & no transaction logss...
I see the Db in a Read-only state & when I try to get it online It says
Error 5063 : Db is a warm standby. A warm standby db is read-only
Alter DB statement failed.
sp_dboption command failed
Please Help
DTS Book
Jul 19, 2000Can anyone recommend a good book on DTS?
View 1 Replies View RelatedNew DTS Book
Feb 23, 2001For those of us struggling with DTS, you've probably all seen
Professional SQL Server 2000 DTS
Mark Chaffin, Brian Knight, and Todd Robinson
WROX
ISBN 1-861004-41-9
This is brand new:
Microsoft SQL Server 2000 DTS
Timothy Peterson
SAMS
ISBN 0-672-32011-8
I have both and they're both worth owning.
I also just found a reference to the following, but I haven't seen it so I count vouch for it. (I also wonder why I haven't stumbled across it previously...)
Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NA and DTS
Frank Miller & Rachelle Reese
WROX
ISBN 1861002807
Book
Jul 27, 2004I read alot of Technical books on SQL and I have found that SQL for dummies is actually a pretty good book(nice reference)
View 1 Replies View RelatedGot Done W/ Book, Anyone Want It ?
Mar 9, 2004I really like to pass my books on, for small price to anyone who could use them, since I no longer need 'em. I've got one , the SQL 2000 Administrator's Companion. Please take a look, I put it on ebay:
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=36313&item=3593450436
Thanks
/rob
BEST SQL BOOK
Apr 15, 2008Ok, look. I could sit here and ask about 1,000 different queries that I would like to have. I'd much rather prefer to find it on my own however. Could someone please recommend a book that will tell me all I need to know about performing different kinds of queries? I have limited Mysql, JavaDB experience. A beginner compared to most of you. Thx in advance for any replies.
View 2 Replies View RelatedBook
Sep 6, 2007Hi
Which is the best book to refer for SQL Server 2005
thanks
The Best Book
Jul 20, 2005Hi to all, I ask to everybody which is the best book of the MS SQl Server 2000.I search in particulary a book complete and advanced.ThanksAlex Palermo
View 6 Replies View RelatedBook
May 30, 2006It seems that there are only two books on SSIS
The Rational Guide to Scripting SQL Server 2005 - BETA preview
Professional SQL Server 2005 Integration Services by wrox
Has anyone read these or any other ones out there?
Any thoughts on which to get?
I am very new to SSIS.
Thanks
Book
Feb 4, 2007Hi,
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
E-Book
Nov 14, 2007Hi I tried to download the E-Book that is located on the benefits page, when i click to save it to hard drive it just sits and nevers start the process. What can I do to correct this matter. Thank you for you time and effort.
DKB
DBA 101 Book
Feb 26, 2008I'm looking for a good book to teach me the basics of SQL Server DBA - installing, daily routine tasks, basic best practices, etc. I'm a DBA newbie so I want beginning level.
View 4 Replies View RelatedBook
May 25, 2006Can you recommend a book on Integration services in sql server 2005?
Thanks
Can You Use SQL For Online Games?
Jan 8, 2008I know MMORPGs take tons of special servers, but what about a simple 2D minorly-multiplayer online game, say with 3-5 players- could that be run through an SQL database or is it still too slow?
View 2 Replies View RelatedSQL Reference Online?
Jan 21, 2004Hi,
I'm looking for a good reference guide online as I am more used to mysql (and stil quite limited vocab at that)
I create table outside of a database by accident and I'm now looking for the sql syntaxt for moving tables, but I can't find it anywhere?
most simple guides don't seem to provide the syntax to do this. :(
Best OnLine Backup
Sep 29, 1999Can someone share with me their experience or thougts on whether it is better to :
1) backup db to the disk first, then to the tape OR
2) use online backup which backup the database on realtime basis to the tape.
Any excellent software for online backup?
Make SQL Available Online
Sep 28, 2005Can anyone tell me how I would go about making my SQL server accessable from the Internet, or know of any good tutorials to get me started, I haven't had much luck looking on google.
I need to access an SQL database from one server on another server for a web application.
Thanks
Need Online Tutor
Jul 1, 2007Dear fellows,
I need online database tutor whom I can pay and he makes my database concepts from scratch. Is there any such facility available
Regards
Online Sql Interpreter
May 16, 2008Hi,
I have started to learn SQL, I need to practise those commands through online sql interpreter. Is there any web page available to do so? or where can i down load it for free?
Books Online
Aug 10, 2005How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?
Thanks!
Online Graphics
Dec 15, 2007Hello all! Im new to SQL2005. If it is possible to see realtime graphs from tables? For example current sales result?
Thanx
SQL Online Backup...
Jul 20, 2005Dear Friends,I don't know anybody has asked this question before or not.But I needa support urgently.How to take online backup in MS Sql server 2000.ThanksArijit Chatterjee
View 2 Replies View RelatedHow To Get Datafile Online Again?
May 23, 2007Hi need to something like this:
"alter database modify file (name=<name>, ONLINE)",
but it isn't possible.
Here what I did:
alter database bdj add file (name ='bdjfg1', filename='d:db
djfg1.ndf' )
to filegroup bdjfg;
alter database bdj modify file (name='bdjfg1', OFFLINE);
alter database bdj modify file (name ='bdjfg1', filename='d:db
ewdestdjfg1.ndf' );
--Msg 5056, Level 16, State 4, Line 1
--Cannot add, remove, or modify a file in filegroup 'bdjfg' because
the filegroup is offline.
alter database bdj modify filegroup bdjfg READWRITE;
--Msg 5056, Level 16, State 3, Line 1
--Cannot add, remove, or modify a file in filegroup 'bdjfg' because
the filegroup is offline.
Yes, yes and should have read the cautions section saying:
"Use this option only when the file is corrupted and can be restored. A file set to OFFLINE can only
be set online by restoring the file from backup. For more information about restoring a single file,
see RESTORE (Transact-SQL)."
But I have not an backup of the datafile, but I have the datafile itself!
What can I do to get it online again, the old location could be fine, but it would be better on an new location (thats is the reason for all the trouble, the original drive has not much space left, so I wanted to move the datafile)
What can I do, HELP
/Bjorn
Good SQL Book
May 30, 2007hello
i am just starting to learn sql and know the basics, but now im looking for a good book to learn some more. A book that covers stored procedure would be very useful. If possible a book with q and a would be very good because i feel this tests if u understand what was just explaned. but if there is a good book without this it is ok. All sugestions welcome
NubNub