Clustered Indexes in SQL Server
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
Menu
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
Installing SQL Server on Linux was a great experience for me, that I would like to share with you the challenges and some of the
StretchDB is a new feature of SQL Server 2016 to archive/migrate cold data from on-premise to Azure SQL Database. We as consultant put the following
Big Data World Show Malaysia 2014 will be launched on September 9 – 10! The event is recognized as a prestigious platform in the industry with the largest scale, most professional attendees, richest content, most advanced experience and most senior speakers in Asia-Pacific region and around the world.
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?
Due to the growing adoption of SQL Server and the mission-critical aspects of databases, many organizations face the challenge of hiring and retaining qualified administrators and developers.
As a Microsoft SQL Server Service Provider with deep-rooted SQL Server expertise, Fard Solutions is the perfect partner to fill the gap, reduce the ongoing administrative burden and maximize your SQL Server investments with a predictable monthly operating expense.
Most SQL Server DBAs believes that TempDB always recreated once SQL Server service is restarted and makes a clean copy of TempDB database. therefore, it
As a service provider, it happens all the time that some companies request our services or in need to have immediate solution for their current problem
Aggregate functions are mostly used in our queries to find out SUM, AVG, COUNT and so on information from stored records for analytical purposes. In
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.
Sometimes happens that we may install both the Reporting Services Windows service and the Report Catalog on the same server (Not Best Practice). However, some
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.
A database that is not maintained can become sluggish, and cause problems with everyday use. Database backups, data recovery, solution clean up, and database optimization are services
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
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