Browse by Tags
All Tags »
SQL Server (
RSS)
Sorry, but there are no more tags available to filter with.
Variable Declaration Enhancement in SQL Server 2008 By : Kasim Wirama, MCDBA In this posting, I would let you know how SQL Server 2008 introduces enhancement in variable declaration. 1. Assign new value of newly declared variable In previous SQL Server...
Introduction of XML Data Type in Practical Use (Part 2-finish) By : Kasim Wirama, MCDBA This second part posting, I would like to share by example about XML query and data manipulation. Query XML data Several XML methods are used for query XML data. They...
Tip Querying Using SQL Server Management Studio By : Kasim Wirama, MCDBA Starting from SQL Server 2005, functionalities of Enterprise Manager and Query Analyzer are united into one application, which is called SQL Server Management Studio (SSMS). For...
Installing SQL Server 2008 (RTM) without any issue By : Kasim Wirama, MCDBA I have downloaded SQL Server 2008 (RTM), but when I installed the RTM, the installer didn’t permitted me to install successfully because my Visual Studio 2008 was not patched...
Introduction of XML Data Type in Practical Use (Part 1) By : Kasim Wirama, MCDBA Beginning from SQL Server 2005, XML becomes first class citizen with any other native data type. In this first part of XML posting, I would like to show by example how to...
Execution Plan Optimality through Statistics Information By : Kasim Wirama, MCDBA As we know that index is used for fast query response time. What causes index could speed up fast query response time? It is because index helps optimizer to generate good...
Welcome to SQL Server Knowledge Centre I name my blog as knowledge source for SQL Server, hopefully someday it will become SQL Server knowledge portal, not just portal. So, I welcome you guys to visit SQL SERVER KNOWLEDGE CENTRE . Share this post: | ...
Common Mistakes in SQL Practice By : Kasim Wirama, MCDBA Some common mistakes are always found in all projects when I have ever involved. Here are points I would like to share with you. Data file and transaction log file put in same drive. For development...
Tips to Detect Suboptimal Execution Plan By : Kasim Wirama, MCDBA This posting, I would like to give important points that need to consider when reviewing an execution plan. With this information on this posting, you can assess whether your execution...
Examine Database Backup Size By : Kasim Wirama, MCDBA I have seen Idera products several times intended for SQL Server use through several advertisements at SQL Server Magazine. One of its products is SQLSafe which has backup and restore functionality...
Dealing with Cardinality Estimation Issue By : Kasim Wirama, MCDBA This posting, I would discuss about cardinality estimation issue that leads to suboptimal execution plan in SQL Server. It applies to all SQL Server versions. Generally, SQL Server always...
2 Stored Procedures for generating index information By : Kasim Wirama, MCDBA To enhance performance of slow running queries, usually a DBA implements index. When a database consists of hundreds of tables, job for maintaining indexes doesn’t seem easy...
Bitmap Operator By : Kasim Wirama, MCDBA This posting, I would like to dissect other operator that might show up in query execution plan of SQL Server, i.e. bitmap filtering. As the name implies, bitmap filtering will use bitmap as the way to mark rows...
Parallelism in Hash Join By : Kasim Wirama, MCDBA In this posting, I would talk about parallelism in hash join. If you would like to know algorithm in hash join, you can refer to my past posting titled Nested Loop, Merge Join, and Hash Join Algorithm...
Parallelism in Merge Loop By : Kasim Wirama, MCDBA This posting, I would discuss about parallelism in merge loop operator and its impact to performance. Parallelism involves two or more threads. And in merge join for single thread, the algorithm works...
More Posts
Next page »