Introduction to Views
A view is a named SELECT query. Unlike ordinary tables, a view is not part of the physical schema; it is a dynamic, virtual table
Menu
A view is a named SELECT query. Unlike ordinary tables, a view is not part of the physical schema; it is a dynamic, virtual table
Transact structured query language (T-SQL) is a querying language which user can use to ask Microsoft SQL server to process request . You also can
SQL Server Optimizer is a software to check the specific SQL Server performance measures and on top of the findings it is able to generate TSQL codes for DBAs to review and execute the codes for having better performance.
Fard-Solutions Sdn Bhd understands our clients’ schedules do not allow for prolonged travel to a distant training facility, which is why we created our Training
Jan 27, 2016 Feb 25, 2016 March 24, 2016
Bursa Malaysia Berhad is an exchange holding company. It operates a fully integrated exchange, offering the complete range of exchange-related services including trading, clearing, settlement and depository services.
What is SQL Server Consolidation? You can simply assume that SQL Server databases in different instances from different servers come and reside together at one high performance
What we talk about when we talk about Data Manipulation; Part 1 “I manipulate data for a living” this sentence always ends with a sudden
The production environment is SQL Server Active-Passive Failover Cluster, our team managed to migrate SQL Server Reporting Services databases and instances into the current production
A deadlock is a special blocking scenario in which two sessions get blocked by each other. Each session, while holding its own resources, attempts to
Database optimization is the act of design and developing database systems to take maximum advantage of the resources available. For example, databases can be optimized to
You might think why Pig is related to SQL Server, at first glance it might not be related but as we know that SQL Server
Applicable on: SQL Server 2014, SQL Server 2016 What is In-Memory OLTP? New in SQL Server 2014, Microsoft added new feature called In-Memory OLTP which can significantly improve
Lots of DBAs are using third party software to control and manage their SQL Server farm within their company data center, in this post I
An index is a collection of pages associated with a table. Indexes are used to improve the performance of queries or enforce uniqueness. You can
Fard Solutions Sdn. Bhd. Company was established in 2012 in Kuala Lumpur. We are engaged in development, implementation, integration and maintenance of the most advanced database solutions and IT research & development (innovation).
Fard Solutions Sdn. Bhd. Company was established in 2012 in Kuala Lumpur. We are engaged in development, implementation, integration and maintenance of the most advanced database solutions and IT research & development (innovation).
Fard Technology Corp.
700-1199 West Hastings Street,
Vancouver, British Colombia,
V6E 3T5 Canada.
Fard Solutions Sdn. Bhd.
Level 23, NU Tower 2, Kuala Lumpur Sentral, 50430 Kuala Lumpur, Malaysia.
Join Our SQL Server E-Newsletter
Signup today for free and be the first to get notified on new updates