Forum Replies Created

Viewing 15 posts - 1 through 15 (of 15 total)

  • RE: Query timeout during database backup

    Yes, I understand that backups will not lock. I need more information on how to troubleshoot this and eventually fix the issue.

  • RE: Make HTTP posts / request from within SQL

    We are currently using a CLR function to make HTTP Post. Which is better?

    Thanks

    KRS

  • RE: Insertion using linked server.

    Hi all

    I have a similar scenario, two servers and when data is inserted into 1 database table, it has to be inserted into table in other database,

    Now, i...

  • RE: Enable index - urgent

    Can i use CREATE INDEX WITH DROP_EXISTING.

    It is an non-clustered, non-unique index. When I try rebuild, the database itself is locked and no other actions can be performed.. Pls...

  • RE: Enable index - urgent

    Yes, that was a great mistake to disable it. but how to rebuild index without slow down other db actions

  • RE: Improving SQLServerCentral

    Nice.. Just a thought striked.. NoSql in SQLServerCentral?!

  • RE: Common SPs and UDFs, some default tables

    Sorry. I need to give more info on the environment. The common database and all databases ( 4 or 5 ) using the common database are in the same server...

  • RE: Getting part of file names

    How could i get the filename in package variable defined. I need folder name also.

    Basically I try to insert data from excel to sql table. Along with the data, the...

  • RE: Better looping - replace for cursor

    Thanks for the comments

    1. @clauses are valid and safe, I'm sure

    2. No.. Couldn't do that, the first IF check is to skip the execution and direct selection, but with the...

  • RE: Better looping - replace for cursor

    Thanks for the reply.

    Sorry I missed the 'Order by' clause. The select is ordered by the clauserank column.

    Yes. This is not actual code. I cann't publish it.

    The whole Idea...

  • RE: Better looping - replace for cursor

    But here the clauses are ordered by clause rank. If the highest rank does not satisfy only, we will move to the next clause.

    Also, I should know the row...

  • RE: Better looping - replace for cursor

    [Code]

    declare @tablevar table ( tvid int, clause varchar(100), clauserank tinyint, val int )

    insert into @tablevar select * from vallookup

    select top 1 @tivid=tvid, @clause=clause, @clauserank=clauserank, @val=val from @tablevar

    while (...

  • RE: using

    Will this give performance boost

  • RE: Individual Contributions

    Absolutely right.. Every one has their unique values and skills.

    Really motivating topic.. Thanks

  • RE: PRINT vagaries

    Thanks.. Now I understand.

    I was wondering what happened to '-'

    Also, why not it work like this:

    '-' being string,

    other two can implicitly convert to string?

Viewing 15 posts - 1 through 15 (of 15 total)