Thank you again, i will collect some statistics and will bug back ;).
Satya thank you for your reply. Due to hardware contraint and small business we have 2 RAID 5 of 7 disk each. These tables are very static and only...
Hi, I have read and worked on fulltext but everytime i stuck when there is a requirement to search database base on fulltext search and combination...
Hi, I would like to know if i can use sql server data mining feature to generate report where i need to show analytical informataion from million of...
Thank you. I was using LIKE before switching to fulltextindex, it was talking longer time (coz customer want to search words from a varchar(500)...
I think you need to add user in SQL server as Corporate_Domainusername.
5 min work [;)]. CREATE TABLE AllUserDbs (ID INT IDENTITY(1,1),DBName VARCHAR(MAX)) INSERT INTO AllUserDbs SELECT [NAME] FROM sys.databases WHERE...
Hi, I was checking if i search F18 in Google is show all related pages even it appear with F/18 or F/A18. Is it possible to perform a similar search...
Hi, Suppose your table CREATE TABLE TBL(ANS INT,MAXFANS INT) Then you fill data accordingly and run this query SELECT ANS,MAX(MAXFANS) FROM TBL...
Hi, First of all you need to see how the string is passed? You mentioned Acctid1 level1 level2;AcctId2 level1 level2;.... I understand 2 different...
Hi, When i started my current job i was in similar position. I did bang my head to find if it was SQL server problem. But when i check at my web...
What other help you need? If you can say, maybe some other forum member can help you.
Hi Bro, No offense but if you need to do your assignments, it is better to do some research and do it yourself. Here is page which show how to check...
Hi, You need to prepare statement and then use EXEC to execute it. SECTION 1: DECLARE @Date char(23) SET @Date = 'myTBL_' + CONVERT(char(23),...
Hi, I am not very old in DBA field and one of our customer has asked to provided them data-feed against hundurard of thousand of records. Now i...
Hi, Today i came across a strange issue (although i have solved it but that is not the answer of my question). I have a table with following...
Hi gadams, 1- If you have connected your both MD3000 to different servers and still MD3000 is giving error then you should call support to assist you...
'N/A' in date type column [*-)], how to do that?
Hi Ranjit, ISNULL(CODE,@CODE)=@CODE working fine. My mistake i didn't create index on ID :(. Once index created 10 million records were imported in...
Hi, I have 4 columns in a table. 1 is foreign key and other 3 columns will be matched based on the give values. Here is my table structure CREATE...
Separate names with a comma.
