(Tony Davis and Shawn McGehee) Consider a situation where, as a DBA, a new database falls under your care. Having implemented some monitoring, you find that the log has grown massively in size, is almost full, and that there isn’t the capacity on its disk drive to accommodate an urgent database main

(Seth Delconte) We have XML data in a SQL Server database that we want to search efficiently, but are not sure of the best way to get the results we want. We need to find specific values in certain XML nodes- this will involve finding node values that match given substrings.

(BatuhanYildiz) 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.

(SQLDenis) When working with different database systems you have to be aware that some things work differently from one system to another. I already blogged a couple of times about differences between SQl Server and Oracle, those post are the following

(Nelson John) In the last post, we have discussed about non clustered index on a clustered table.In this post we will discuss about the non clustered index on a heap table.

(Craig Mullins) We all can relate to dealing with systems that have data integrity problems. But some data integrity problems can be cleaned up using a touch of SQL. Consider the common data entry problem of extraneous spaces (or blanks) inserted into a name field.

(Arshad Ali) Prior to SQL Server 2012, SQL Server had several high availability and disaster recovery solutions for an enterprise’s mission critical databases such as failover clustering, database mirroring, log shipping or combinations of these.

(Matan Yungman) Views, table variables and local variables are great in terms of programming principles.

(Manvendra Singh) We have a requirement to move one of the secondary SQL Server databases to another SQL Server instance to keep our Log Shipping configuration active. We have decided to move this SQL Server database because of poor performance and because our secondary database was hosted on very o

(Nelson John) A table can have only one clustered index as the data rows are stored in the order of the clustered key, but a table can have multiple non clustered indexes.We have discussed about clustered index structure in our earlier post . In this post let us try to understand the non clustered i