Blogs about: Index Database
Featured Blog
SQL SERVER – How to work with Row Constructors , inserted and deleted tables and Handle Result Set
There are many ways to track changes made to the table in SQL Server one of the method is to use inserted and deleted tables and get the result set and use in code appropriately. Step 1: Creating Tabl… more →
Exploring SQL SERVER With Dilip Kumar Jena
Troubleshooting media database corruption
— 1 comment
wrote 7 months ago: This post is about how to repair simple media database corruption, and media database compression … more →
Solve your top 5 SQL Server performance issues with SQL doctor
wrote 10 months ago: Do your SQL Servers need a check-up? Call the SQL doctor! SQL doctor analyzes your SQL Servers to … more →
The path for the index location is not valid
wrote 1 year ago: “The path for the index location is not valid” I recently faced this issue with the Shar … more →
SQL Interview Questions
— 12 comments
wrote 1 year ago: These are the most common yet tricky questions that you can expect in a .NET/SQL interview. 1) … more →
Do tables in a SQL Azure Database need to have a primary key?
— 2 comments
wrote 1 year ago: Answer: No. Though SQL Azure does need that a table has a clustered index. So to this end, Let … more →
Full Table Scan / Sequential Scan in MySQL: Understanding when this happens with EXPLAIN statement and avoiding optimizer’s choice of incorrect table scan
wrote 1 year ago: Post @ http://singztechmusings.in/full-table-scan-sequential-scan-in-mysql-understanding-when-this- … more →
Forum Q&A: Best method to Migrate on premise to SQL Azure
wrote 1 year ago: Question: What is the best method to use for copying an “On Premise SQL DB” to SQL Azure … more →
Documentum Full Text Index Server
wrote 1 year ago: For faster and better search functionalities EMC has developed a Full Text Index Server which is ins … more →
SQL SERVER - How to work with Row Constructors , inserted and deleted tables and Handle Result Set
— 1 comment
wrote 1 year ago: There are many ways to track changes made to the table in SQL Server one of the method is to use ins … more →
We have a table with a CHARACTER data type field. We apply a ">" row comparison between this field and another CHARACTER field in another table. What will be the results for records with field value of NULL
— 2 comments
wrote 2 years ago: This is something so many asked me because I also faced the same situation before, so having a … more →
SQL SERVER - What is the basic difference between a join and a union
wrote 2 years ago: A join selects columns from 2 or more tables. A union selects rows. Reference : Dilip Kumar Jena ( h … more →
SQL SERVER - CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above statement
wrote 2 years ago: Non-clustered index. Important thing to note: By default a clustered index gets created on the prima … more →
SQL SERVER - what are the DBCC commands that are commonly use for database maintenance
wrote 2 years ago: DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATAB … more →
SQL SERVER - What is @@Rowcount, @@Error and @@Identity
wrote 2 years ago: @@Rowcount is used to display the number of rows affected by last SQL statement. @@Error displays th … more →
SQL SERVER 2008 - How to rename a column
— 1 comment
wrote 2 years ago: There are many ways where in we can rename a column but what I prefer is using predefined stored P … more →
SQL SERVER - What is the difference between group by and order by
wrote 2 years ago: Group by controls the presentation of the rows, order by controls the presentation of the columns f … more →
SQL SERVER - What is the difference of a LEFT JOIN and an INNER JOIN statement
wrote 2 years ago: A LEFT JOIN will take ALL values from the first declared table and matching values from the second d … more →
SQL SEREVER - What is a View and An Indexed View
wrote 2 years ago: A view is a virtual tables that is made up of one or more tables. It can be used for security purp … more →
SQL SERVER 2008 - What is the difference betweeen Execute and sp_executesql
wrote 2 years ago: sp_executesql and Execute statement are used to execute a sql stored Procedure. The execute statemen … more →
