Viewing 15 posts - 1 through 15 (of 15 total)
Yes, I understand that backups will not lock. I need more information on how to troubleshoot this and eventually fix the issue.
March 18, 2015 at 4:44 am
We are currently using a CLR function to make HTTP Post. Which is better?
Thanks
KRS
July 1, 2011 at 12:49 am
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...
April 28, 2011 at 3:50 am
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...
April 26, 2011 at 8:04 am
Yes, that was a great mistake to disable it. but how to rebuild index without slow down other db actions
April 26, 2011 at 8:03 am
Nice.. Just a thought striked.. NoSql in SQLServerCentral?!
April 2, 2011 at 1:23 am
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...
March 17, 2011 at 4:01 am
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...
March 10, 2011 at 3:31 am
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...
January 17, 2011 at 12:12 am
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...
January 17, 2011 at 12:05 am
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...
January 13, 2011 at 5:11 am
[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 (...
January 13, 2011 at 4:53 am
Absolutely right.. Every one has their unique values and skills.
Really motivating topic.. Thanks
August 25, 2010 at 10:56 pm
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?
July 1, 2010 at 10:27 pm
Viewing 15 posts - 1 through 15 (of 15 total)