Which one is better? PERSISTED Column or XML Indexes?

I had a chance to work on the XML area. The customer had a performance issue with some queries which were related to XML data. The customer was using a banking application called TEMENOS T24 on Microsoft SQL Server. The tables in the databases have just 2 columns RECID and XMLRECORD which has all the…

0

How to find busy tables in SQL Server?

There is a performance issue on the system. You check the sys.dm_os_wait_stats and you see that PAGEIOLATCH wait type is at the top. You know that it is related to disk performance. It may be because of the high IO issue or disk related issue itself. You collect the performance counters “Avg. disk sec/Read” and…

3

Guest user account in SQL Server

It is recommended to disable guest user in every database as a best practice for securing the SQL Server. Guest user permits access to a database for any logins that are not mapped to a specific database user. The guest user cannot be dropped but it can be disabled by revoking the CONNECT permission. The…

2

Autogrowth option for SQL Server database files

It is not recommended to keep “In Percent” File Growth option for database files. If “In Percent” option is used for any database file and if the file size is very big, it may cause performance degradation during the file growth phase. It may not be a very big problem if “Instant File Initialization” is…

11

SQL Server Builds

How to identify SQL Server version Open SQL Server Management Studio and run of the following queries. First Query: SELECT SERVERPROPERTY(‘productversion’),        SERVERPROPERTY(‘productlevel’),        SERVERPROPERTY(‘edition’) Second Query: SELECT @@VERSION To view all versions click the link [more] Builds SQL Server 2012 SQL Server Version Builds Released On Download RTM 11.0.2100.60 RTM + CU1 11.0.2316.0 April…

0