OK Got it... But i m always try to avoid the use of UNIQUEIDENTIFIER column in the table.(if possible). Any ways, As a DBA what are the other things that i have to keep in mind ?? Thanks again for reply......

Hi Jacob, Thanks for the reply, but i have one doubts as you said - > there are chances that you fix the excessive fragmentation by tweaking the schema I don't understand, i mean what do you mean by "tweaking the schema"? Thanks...

Hello Experts,I need your suggestion / feedback regarding automation of database rebuild / reorganize indexes. For the frequently updated database, should i have to manually rebuild / reorganize the indexes as per the Total fragmentation or i have to ma...

You can refer below link. [http://beyondrelational.com/modules/2/blogs/28/posts/10399/tsql-lab-9-how-to-find-the-dependency-chain-of-a-database-object.aspx][1] [1]: http://beyondrelational.com/modules/2/blogs/28/posts/10399/tsql-lab-9-how-to-f...

Hi Nakul, Sorry for late reply... I was using - Microsoft SQL Server 2008 (SP2) - Enterprise Edition, and i upgrade it to **SP3**. After upgrading it, i m not getting any error as mentioned in my above post. Thanks a lot for reply......

Hi Saket, Plz check below Query: > SELECT ap.App_Name , STUFF(( > SELECT ',' + Server_Name FROM > dbo.App_Table WHERE App_Name = > ap.App_Name FOR XML PATH('') ), > 1, 1, '') AS Server_Name FROM > dbo.App_Table AS ap GROUP BY ...

Its better if you use like this: string str1=string.Empty; string str2 =string.Empty; the difference between String.Empty and “” are pretty small, but there is a difference. “” actually creates an object, while String.Empty creates no object. Che...

Hello Experts,Today morning, i have encountered this type of error message when i try to update one record. The Query is as below:Update dbo.Table1 set edit = 1 Where Id = 1234And the error is : Normal 0 false false false

Hi all, I had developed one in-house CRM(Customer relationship management) application. Its developed in ASP.Net 2.0 and we are using Sql server 2008. In this application marketing manager generates lead and assign to its executive. after assigning th...

Hi all, I had developed one in-house CRM(Customer relationship management) application. Its developed in ASP.Net 2.0 and we are using Sql server 2008. In this application marketing manager generates lead and assign to its executive. after assigning t...