Hi, I have installed the sqlxml 4.0 sp1. Need help on how to start programming and advanced performance issues faced. Is there a book on this? Can...
Can somebody please guide me to get download of SQL Server 2000 Reporting Services. I am unable to gert information as to how to obtain it. I have...
Hi, Could we Insert Multiple Rows within a Single Round Trip? IF so can you guide me please. Thank you. Usha Rani
Hi all, In a DB I have found an nvarchar code field which needs to be sorted as follows: 1,2,3,4,5,6,10,100,200,2000,A1,A2,AB1,AB2,ABC1,ABC2 Is...
Hi! Please help me restore my database to the prior time. I have no uptodate backup. This is a test server database. I have run script as: RESTORE...
Could you please tell me what to do in case of timeout error. A particular query is generating this error. Please suggest. ------- Timeout expired....
Could you please tell me if a dynamic sql, created with different order by clause passed as parameter, be efficient interms of execution plan reuse?...
How do I capture record count into a variable, for a table name passes to the procedure as input parameter? --- as an example. Create Proc someProc...
Please tell me if there is another better way to do the following. COmpanySales ------- compSalesID int, i_company_id int, i_year int, i_quarter...
Dear All, Can anybody give me a query to return top row from each group of records returned by a query. A group can be based on a product....
Hi! Am looking for information on implementing Category Hierarchy in SQL Server using Data Structure - Graph. Would like to know: 1) Which is the...
Dear all, If any of you know about best way to design for text search please let me know. Take Google Search as example. 1) Search Doccuments for...
Dear All, I need to calculate Current Date - Date of Join in months, exact till date, and perform query on that to restrict rows based on number of...
Don't we need to look at the answers sought by us? I need to get back to the topic I have opened after a month or more, I know the content but not...
Dear All, We are using VB.Net and SQL SERVER, All Images are stored in Binary. But loading them on a page is taking time. How do I load them...
Dear All,<br /><br />What is the easiest way to get the details of Server COnfiguration?<br />Oops! am I asking a stupid question? [<img...
Dear All, I have taken up tuning SQL/PL-SQL and the Database already in production. Kindly bare with me and help me. A particular query is...
Dear All, Forgive my ignorance in asking you this. The uniqueidentifier's length is only 38 characters right. Irrespective of nationality and the...
Hi, My query returns only one row. estimated row size is 5478. All other queries run fine but this particular query is throwing...
Hi, I know the functionality of Functions,StoredProcs and Views. I wan't to know the performance issues. I heard that views are really bad for...
Separate names with a comma.
