Viewing 15 posts - 4,216 through 4,230 (of 49,571 total)
Do what? You're going to have to give more info.
Do you mean reducing the number of cores SQL uses?
Do you mean reinstalling Windows with the server core option
Something else?
November 23, 2015 at 5:36 am
Elapsed time will mostly be display of data if you used SSMS (it's terrible about displaying data). Try inserting into a temp table to remove that factor.
November 23, 2015 at 5:31 am
scorpman (11/18/2015)
I have a question, in terms of performance what's best in a query with LEFT JOIN:
- Put the clause in ON of the LEFT JOIN
- Put the clause in...
November 23, 2015 at 5:30 am
I'd honestly recommend reinstalling the server. If those executables have been added, it suggests that whoever got access did so at the Windows level. You have no idea if there...
November 23, 2015 at 5:29 am
Edit -> Advanced -> View White Space
November 23, 2015 at 2:59 am
John Mitchell-245523 (11/23/2015)
November 23, 2015 at 2:43 am
As written, they're identical. If you were using a LEFT join, they'd have different meanings and different results. Nothing to do with performance.
November 23, 2015 at 2:31 am
Could you explain further what it is you're looking for?
November 23, 2015 at 2:16 am
sysaltfiles is a system table, it's not accessible. What exactly do you want the user to be able to do?
November 23, 2015 at 2:09 am
In-memory as-in Hekaton tables? The thread title says "Calculated" tables (which I read as derived tables), so which exactly?
November 23, 2015 at 2:07 am
Does what not involve deadlocks?
we call this proc at front end from one of the report and this report used by different users or same user in different session...
November 23, 2015 at 2:05 am
Then leave it as-is. There's nothing you've mentioned in this thread that's a problem. As mentioned before, SQL will use all memory that it's allowed to use. This is expected,...
November 23, 2015 at 2:01 am
I wouldn't bother. If a temp table is created in a procedure, it's automatically dropped when the procedure ends, so there's no chance of getting errors if the procedure runs...
November 23, 2015 at 1:56 am
Well, you can't update identity columns, so when do you want that trigger to fire? On what operation? When what happens?
November 21, 2015 at 12:27 pm
All modification statements are part of a transaction and any trigger fires within that transaction.
If the transaction is committing, then it's because a rollback isn't running. Maybe the raiserror is...
November 21, 2015 at 1:05 am
Viewing 15 posts - 4,216 through 4,230 (of 49,571 total)