Is it possible to take both clustered and non-clustered indexes advantage at one time? Or in other word, is it possible to search data without worrying about edge key in the index?
In the previous blog post regarding SQL Server In-Memory Internals, I wrote an overview of how In-Memory OLTP engine controls the concurrency without acquiring Lock
Taking database backup is a compulsory task if your data is critical. SQL Server backup and restore operations can take from few seconds to few
SQL Server Health Check is a very challenging subject that requires expertise and in-depth knowledge about SQL Server internals, administration and development. Fard Solutions provides
I came across to install and configure SQL Server 2016 and found there are many MSSQLSERVER windows users are created in Windows Local Users. Therefore
In most advance and complex databases, developers and DBAs faces double hop security issue, which usually DBAs granting the permissions to resolve the issue but
If SQL Server Enterprise Edition is Expensive, What about Other Editions!
Sometimes we do need to disable AUTO_STATS_UPDATE or AUTO_STATS_UPDATE_ASYNC due to many reasons such as database performance impact in heavy workload environment. Updating statistics based
It is important to monitor SQL Server instances to identify potential problems early, and to help with ongoing planning. SQL Server includes built-in features that
One of the major difficulties in the process of performance tuning in VLDB is to create index on a table which can drag the tuning
Microsoft introduced In-Memory OLTP technology for SQL Server in version 2014, I would not explain about this technology, you may visit our other blog post
In the previous blog post, I already explained the advantage of using SQL Server Master Data Services feature in the end-to-end organizational BI environment. At
Sometimes it is required to return stored data in databases as XML documents. Usually, these requirements are relating to exchange data with other systems. By
One of the most important steps in working with Microsoft SQL Server data management is to understand what execution plans are, why execution plans are
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. 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.
1-1C & 1-2C Incubator 1,
Technology Park Malaysia,
Bukit Jalil, 57000
Kuala Lumpur, Malaysia.
Join Our SQL Server E-Newsletter
Signup today for free and be the first to get notified on new updates