Forum Replies Created

Viewing 15 posts - 601 through 615 (of 761 total)

  • RE: can i use replication ? what is your idea?

    Nothing could be better than having all the data in one server. Both Linked Servers and coding from the front end would be more or less the same in terms...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 6:50 am

    #1479653

  • RE: can i use replication ? what is your idea?

    Larry Page(Ehsan.Akbar) (4/26/2012)

    in fact my servers have different subset of data ,so you think i should use linked servers?

    Yes, I think you should use Linked Servers. Replication is when you...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 6:39 am

    #1479638

  • RE: # of characters

    ChrisM@Work (7/26/2011)

    DECLARE @WordToCheck VARCHAR(30) = 'SQL SERVER'

    SELECT Letter, COUNT(*)

    FROM(

    SELECT Letter = SUBSTRING(@WordToCheck, n.n, 1)

    FROM (SELECT TOP 30 n = ROW_NUMBER() OVER(ORDER BY [Name]) FROM sys.columns) n

    WHERE n.n <= LEN(@WordToCheck)

    ) d

    WHERE...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 5:41 am

    #1479602

  • RE: Foreach in Creating a View

    *btw: Is there a way to boost your point up thru your answer? I'm kinda new here in this forum.

    What point?

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 4:40 am

    #1479566

  • RE: Foreach in Creating a View

    brally123 (4/26/2012)

    [font="Courier New"]Hi all,

    I'd would like to ask some help from you gurus here 🙂 I'm fairly new in this so please forgive me.

    I have two tables:

    --------------------------------

    | ...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 4:10 am

    #1479550

  • RE: Trace a particular sp

    This particular OP give me the feel that he/she thinks that he/she owns us. :angry:

    Read a lot of posts from him/her. Its the same everywhere.

    No Offense Riya Dave. Just what...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 3:48 am

    #1479543

  • RE: Replacement for Cursors

    Thanks Eugene.

    As simple it may be....but that was what I was looking for. 😎

    Thanx for all the replies. Just climbed up a few steps on the learning curve and its...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 3:26 am

    #1479533

  • RE: Replacement for Cursors

    Thanks Eugene.

    As simple it may be....but that was what I was looking for. 😎

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 3:20 am

    #1479529

  • RE: User Activity

    Run the profiler as a server side trace to know all user and server activities

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 3:08 am

    #1479524

  • RE: Replacement for Cursors

    The way I work allows me to get this down long before I start coding.

    Step 1. I start with pen and paper and jot down a few algorithms. Normally, I...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 2:45 am

    #1479518

  • RE: Best Practice in setting up sql server access to DBA's:

    capn.hector (4/25/2012)

    method 1. one its bad to share passwords. what happens when some one leaves?? you have to change the password and that can get anoying. and...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 1:28 am

    #1479497

  • RE: Replacement for Cursors

    Thanx again Dwain.

    You're examples were very helpful and have definitely taught me some ne stuff. As far as the Dynamic SQL part goes....you can't have everything always...right??

    There are uses for...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 1:15 am

    #1479493

  • RE: sql query to read xml elements from xml file

    This might help:

    read-data-from-xml-file-in-sql-server

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 1:00 am

    #1479491

  • RE: please give the solution for this

    SQLKnowItAll (4/25/2012)

    vinu512 (4/24/2012)

    MAAAAN!!!!...He really knows it all....lol 😀

    +1 SQLKnowItAll....I agree.

    Hehehehe... I certainly don't! Of course, that's what makes it a clever name for my blog. Anyone want to buy...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 12:34 am

    #1479484

  • RE: get local variable value

    What was the answer??....:w00t:

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 26, 2012 at 12:26 am

    #1479480

Viewing 15 posts - 601 through 615 (of 761 total)