Hi, I was trying to do a database mirroring( for learning purposes). But the mirroring process failed. I am currently having sql server 2005...
Hi Mayur, The joined columns are correct. Is there a solution? Please Reply
Hi, I am having a table( a Junction Table aka Cross Reference table ) named XrefList, This table is holding TableIds Which are the primary keys of...
Got this interesting article. http://www.sql-server-performance.com/articles/per/ranking_functions_performance_p1.aspx
Hi, This is not much related to sql server 2005; but I hope some one among You might have encountered such problem in his/ her experience. I am...
Thanks for the solution Frank. Also I am thankful to all of the other people who helped me.
Hi Madhivanan in the second last method ( method 5th) Select min(num) from (select top 5 num from @number order by num desc) T I think it should be...
Hi kboodu, I think I should be having order by DESC here Does order by work for numeric column? (I think it works for varchar or Nvarchar but won't...
Hi, I am having a newbie question here which was asked in an interview: How to find the fifth largest salary from an employee table where the salary...
<p> </p><p>Thank You, very much for the reply. Looks like You are working too much or are SQL alcoholic <img...
It is a Identity Column I will be using Stored Procs to Insert the values in the tables(parent- child) rather than using triggers.
No, because I am just breaking a big table into logical groups, also the employee in question can be shifted to different team, but won't be a...
Hi Frank, actually I am trying to create a database to manage teams, like there is a table employees for a company and another table which has the...
Hi, Is there any performance benefit from a self referencing foreign key, If I have a choice for reference from other table or the current table;...
Hi Adriaan, If I am not wrong You are suggesting that I should be making a primary index (non clustered ) on natural key(key that has a bussiness...
hmm.... I am using IDENTITY COLUMN AS A primary key; then according to You I should not be using primary key AS an IDENTITY? Then what else...
Hi Frank, I don't know if IDENTITY_INSERT ON is possible if we actually create a new column. can You please improve this script: (where should I...
Hi, I need help regarding the identity column. I have a column whose Identity seed was 1 when the column was initially created. Now I have to change...
Oh Thanks, Nicely explained Thank You very much again
Hi Adriaan, Can You please elaborate more on this.
Separate names with a comma.
