Viewing 15 posts - 661 through 675 (of 1,219 total)
mister.magoo (9/3/2013)
Surely this is a case for validation at the front end?There always used to be a rule that applications validate input...
Yes and no. First of all, it depends...
September 4, 2013 at 1:18 am
Dennis Post (9/3/2013)
I haven't been able to REPLACE the CHAR(0) nor have I been able to detect it with:
Force a binary collation:
replace(col COLLATE Latin1_General_BIN2, char(0), '...
September 3, 2013 at 4:18 pm
It seems to me that the confusion is really with:
Some designs are present in more than one table. You want to generate a list of all items in the FutureDesign...
September 3, 2013 at 4:12 pm
Your post does not give much details. Do you mean that you first run the stored procedure and it gets stuck on an UPDATE statement. Then you kill the execution...
September 3, 2013 at 4:01 pm
Your error was actually fairly trivial: you hade overlooked that the tag looks like this:
<Object Database="[bos_sommar]" Schema="[dbo]" Table="[currencies]" Index="[pk_cur]" IndexKind="Clustered" />
That is, the index name is quoted in brackets.
I changed...
September 3, 2013 at 3:47 pm
Robert klimes (9/3/2013)
September 3, 2013 at 3:30 pm
ScottPletcher (9/3/2013)
Don't forget restore damaged instance. That is the most complex recovery. Particularly test for master, model and msdb.
Very good point, Scott!
September 3, 2013 at 2:24 pm
The problem is that we don't know how consume the data. TDS is not necessarily the limiting factor - TDS just passes the bytes. To get the data on the...
September 3, 2013 at 2:21 pm
Yeah, that works too. And slicing the data in half is certainly a possibility. If you insert millions of rows, and you only have a single errors this may be...
September 3, 2013 at 2:13 pm
If I get this right, you should get it working by adding the condition
AND Levels.Level = deleted.Level
September 3, 2013 at 2:08 pm
The plot thickens...
Anyway, the stored procedure had quite a lot of INSERT statements, so why would only these two be slow? If it's a problem with mirroring, it could happen...
September 3, 2013 at 2:01 pm
As you long as your stored procedure is not part of an outer transaction, it is doable:
BEGIN TRY
MERGE ...
END TRY
BEGIN CATCH
DECLARE cur CURSOR STATIC...
September 3, 2013 at 5:14 am
I don't have much to add to Andreas's response, but I note that your spec is somewhat vague. It would help to know more about this database, and why it...
September 3, 2013 at 3:18 am
Jeff Moden (9/2/2013)
September 3, 2013 at 1:58 am
Please forgive me. I like to help you with your performance problem, but I only have fragmentary information and it is difficult to piece things together.
It seems that you...
September 3, 2013 at 1:56 am
Viewing 15 posts - 661 through 675 (of 1,219 total)