Viewing 15 posts - 136 through 150 (of 1,199 total)
I don't see why the variables would be a problem. They can be dumped with PRINT and SELECT as well. No reason to replace them with something else to debug.
(And...
June 27, 2020 at 8:18 am
It's over 15 years since I gave up using an SQL debugger. I found that I spent more time to get to work than I actually got out of it....
June 26, 2020 at 7:49 pm
First of all, take out those NOLOCK. You may be a gambling man, but gambling does not really have a place in database systems.
The reason you lose the rows is...
June 22, 2020 at 4:01 pm
So did you try our solutions? And more to the point, did you try to augment any of them to fit this slant of the problem?
June 17, 2020 at 6:44 am
If this is being used in the SELECT list of a query,
Jeff, if that is part of a SELECT list, what SQL dialect would that be? I...
June 15, 2020 at 4:22 pm
SELECT ID2, SUM(Amount1), SUM(Amount2)
FROM (SELECT ID2, Amount AS Amount1, 0 AS Amount2
FROM Table1
...
June 11, 2020 at 6:39 am
Indexing could help a lot! Or not at all, all depending on what your memory pressure is due to. It could be that you are scanning a 100 GB table...
May 9, 2020 at 7:25 pm
If it is a web application that uses an application login, don't add users as logins to SQL Server at all. If you already have, drop them.
TDE requires nothing special...
May 9, 2020 at 8:33 am
Please elaborate on your question. We don't know your system. Is it a web application? A fat Windows client? And what do you mean with the second sentence?
May 9, 2020 at 8:11 am
If you have a working loop for SQL 2008, stick with it. And consider my piece of code a kick in the rear parts to get you ahead for an...
May 6, 2020 at 6:21 am
By the way, thank you for proving CREATE TABLE + INSERT and even the sample data with INSERT statements. Far too few people do that.
May 5, 2020 at 8:53 pm
I realise that this is the SQL 2008 forum, this may not work out; the code below requires SQL 2012 or later. Then again, the sad story is that the...
May 5, 2020 at 8:52 pm
The DELETE statement is deleting multiple rows with the same (nConn, HashId). I would guess the other process is trying to insert rows with the same key values. It seems...
April 25, 2020 at 4:02 pm
I didn't study this in detail, but one thing I have noticed that people miss in deadlock analysis is that the processes may be involved in a multi-statement transaction. Look...
April 25, 2020 at 3:16 pm
This question was also posted to microsoft.public.sqlserver.programming. For convenience I repeat my answer here:
All sorts of reasons:
1) Long-running query plan.
2) Infinite loop.
3) Blocking.
There may be more, but those are the...
April 22, 2020 at 7:13 pm
Viewing 15 posts - 136 through 150 (of 1,199 total)