Viewing 15 posts - 2,191 through 2,205 (of 2,894 total)
kiran.rajenimbalkar (2/9/2012)
Hi Professional,Just please tell me which HINT's i need to use in the mentioned above SQL for retrieving the data fast.
Regards,
Kiran
Kiran, you have visited this site 135 times I...
February 9, 2012 at 6:45 am
You need to use double quotes:
SELECT * FROM v_contactsearch where CONTAINS (searchtext, '"NEAR((WASHINGTON,DEVELOPMENT),10)"')
August 25, 2011 at 2:18 am
karthikeyan-444867 (8/24/2011)
...
Joe Celko has mentioned something like below in his article.
...
That was bad idea to bring theoretical fanatics into our nice discussion :hehe:
Sorry, but I'm not big fan of him...
T-SQL...
August 24, 2011 at 4:18 am
karthikeyan-444867 (8/24/2011)
Declare @id int
select @id = id from emp where eno = 5
can we say it...
August 24, 2011 at 2:51 am
sqlnew (8/21/2011)
...For example: Exec IPTest 5,'179.98.120.98' should Give Positive result(say 1) as it falls in the range for LocationID 5.
...
From your example I can see that you ever want to...
August 23, 2011 at 6:56 am
Prassad Dabbada V R (8/23/2011)
As of now I know only Procedural Language in T-SQL.
Dividing the complex logic into small small parts...
August 23, 2011 at 5:07 am
Change the database 🙂
Most likely, when you logon as "same user"? you are connected to your database by default.
When you logon as SA, by default you are connected to master...
August 23, 2011 at 4:16 am
You may consider to use "CHECKSUM" method. It's inteded for buidling hash indexes, especially to improve indexing speed for indexing long character columns (as you have).
You can read more and...
August 23, 2011 at 3:53 am
To answer your original question
aaron.reese (8/19/2011)
August 22, 2011 at 8:54 am
Yes, you are right. It is a best technique for this sort of task.
August 22, 2011 at 4:09 am
Tom.Thomson (8/20/2011)
Eugene Elutin (8/20/2011)
I'm lucky...
August 21, 2011 at 3:06 am
I don't know how, but I've started to love J.Celko replies...
They actually make my day, they fill it with laughter and light. 😀
I wonder, does he really remember all these...
August 20, 2011 at 12:10 pm
As it was mention that "It is pointless posting the query here - the view has 42 joins and many of those are other views (I know - don't ask...
August 20, 2011 at 11:50 am
You are just very lucky man that J.Celko is not your 'mon papa'. Otherwise you would be caned badly for behaving coding like that :hehe:
I'm lucky same as you...
August 20, 2011 at 11:41 am
kramaswamy (8/19/2011)
Try this version instead:
CREATE TABLE #TempDatabaseNames
(
ID INT IDENTITY,
DatabaseName VARCHAR(250)
)
INSERT INTO #TempDatabaseNames (DatabaseName)
SELECT DatabaseName
FROM UserDatabasesToBackup
JOIN sys.sysdatabases...
August 19, 2011 at 10:58 am
Viewing 15 posts - 2,191 through 2,205 (of 2,894 total)