Forum Replies Created

Viewing 15 posts - 2,191 through 2,205 (of 2,894 total)

  • RE: Need to tune SQL

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    February 9, 2012 at 6:45 am

    #1445030

  • RE: Fulltext Search syntax error

    You need to use double quotes:

    SELECT * FROM v_contactsearch where CONTAINS (searchtext, '"NEAR((WASHINGTON,DEVELOPMENT),10)"')

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 25, 2011 at 2:18 am

    #1372982

  • RE: SQL example for Procedural & Declarative

    karthikeyan-444867 (8/24/2011)

    ...

    http://www.simple-talk.com/sql/t-sql-programming/procedural,-semi-procedural-and-declarative-programming-in-sql/

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 24, 2011 at 4:18 am

    #1372447

  • RE: SQL example for Procedural & Declarative

    karthikeyan-444867 (8/24/2011)

    Procedural program - some series of computational steps to be carried to solve a problem.

    Declare @id int

    select @id = id from emp where eno = 5

    can we say it...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 24, 2011 at 2:51 am

    #1372408

  • RE: comparing ip addresses in sql

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 23, 2011 at 6:56 am

    #1371949

  • RE: SQL example for Procedural & Declarative

    Prassad Dabbada V R (8/23/2011)

    Did you heared that in T-SQL for Sql Server 2005.

    As of now I know only Procedural Language in T-SQL.

    Dividing the complex logic into small small parts...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 23, 2011 at 5:07 am

    #1371880

  • RE: object_id(what) .. returns diffrent value depending on user

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 23, 2011 at 4:16 am

    #1371857

  • RE: To create index on varcharcolumn

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 23, 2011 at 3:53 am

    #1371844

  • RE: COALESCE() - Does it calculate every value or does it stop when it gets a not NULL

    To answer your original question

    aaron.reese (8/19/2011)

    ...I am wondering, does the COALESCE() function evaluate each element in sequence and only move on to the next one if the previous one...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 22, 2011 at 8:54 am

    #1371460

  • RE: Single row to multiple columns

    Yes, you are right. It is a best technique for this sort of task.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 22, 2011 at 4:09 am

    #1371316

  • RE: WHERE clause as a parameter

    Tom.Thomson (8/20/2011)

    Eugene Elutin (8/20/2011)

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 21, 2011 at 3:06 am

    #1371131

  • RE: What's the best way to grab the Grand Total for calculation - TSQL

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 20, 2011 at 12:10 pm

    #1371079

  • RE: Query execution much slower after upgrade

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 20, 2011 at 11:50 am

    #1371078

  • RE: WHERE clause as a parameter

    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...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 20, 2011 at 11:41 am

    #1371076

  • RE: Cursor variable losing data

    kramaswamy (8/19/2011)

    Cursors are evil things ... maybe something related to cursors is causing your problem

    Try this version instead:

    CREATE TABLE #TempDatabaseNames

    (

    ID INT IDENTITY,

    DatabaseName VARCHAR(250)

    )

    INSERT INTO #TempDatabaseNames (DatabaseName)

    SELECT DatabaseName

    FROM UserDatabasesToBackup

    JOIN sys.sysdatabases...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 19, 2011 at 10:58 am

    #1370903

Viewing 15 posts - 2,191 through 2,205 (of 2,894 total)