When you install SQL Server, there by default system databases are created. Which are, Master … MSDB … Model … and TempDB … and Resource DB, which is not visible through SSMS (SQL Server Management Studio). All of these DBs are there for specific reason and each has particular task to perform. Master DB:- As
SQL Server … Searching Tree !!!
If by any chance you happen to know a little history of computers, you will be surprised that most of the early innovators had taken their primary field of study as Mathematics or Physics !!! At first glance, you may wonder what a mathematician is doing in field of computers right ?? But even if
SQL Server … Internals
Internal of DBMS consist of 5 core components , and we know that … it was more like logical structure … but the internals I am talking about here is how data is handled, or can say how data is read, write, stored physically specifically in SQL Server (I think Oracle does it a little
SQL Server 2008 …. Installation How To
Just I had explained in previous post, even just for learning purpose if you want to experience real power of SQL Server, then you should atleast have Standard edition of SQL Server 2008. But if you can get Developer edition then it is better, because developer edition is an enterprise edition which can’t be used
Database …. Introduction to SQL Server
After understanding of internal of DBMS, different major physical components we are now ready to move company specific DBMS product, and the product i work on is Microsoft SQL Server. Microsoft is “fresher” in database field compared to its rivals Oracle and IBM. But it has conquered significant portion of market as of today and
Windows 7 GOD MODE
If you have been playing games, you might be aware of “GOD MODE” that we use in Games. Basically it make you “GOD” and you can be killed by anyone , get all weapons and hell sometimes you can even fly in air and walk though the wall !!! No no, this god mode won’t
Database 101 … Physical Requirements
Just like any other software, any given DBMS has its own system requirements. They too have min. and recommended system requirements. Minimum system requirements are something that DBMS need to just “work” and recommended system requirements can make DBMS work well beyond OK (but having very good performance of DBMS is whole different story) But