Welcome to the first article of the weekly #thresqlips series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary: Continue reading #Thresqlips series Metadata, XML & Text files – Episode 1
Category Archives: Sql Server Tutorials
How can you find tables without indexes?
In order to find all the tables without indexes just run the following query in the Query Editor:
Sql Server Interview question: What is a covered index?
Question : What is a covered index?
A covered index can satisfy a query just by its index keys without having the need to touch any data pages. When an Index covers the query in this way it is a called covering index. Continue reading Sql Server Interview question: What is a covered index?
Sql Server Interview question: Data deletion / Size reduction
Question: When you delete data from a table, is SQL Server reducing immediately the size of that table? Continue reading Sql Server Interview question: Data deletion / Size reduction
Sql Interview Question: What is SQL CLR?
SQL CLR (SQL Common Language Runtime) is a technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment.