Viewing 15 posts - 4,216 through 4,230 (of 49,552 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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2015 at 5:29 am
Edit -> Advanced -> View White Space
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2015 at 2:59 am
John Mitchell-245523 (11/23/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 23, 2015 at 2:31 am
Could you explain further what it is you're looking for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 21, 2015 at 1:05 am
Viewing 15 posts - 4,216 through 4,230 (of 49,552 total)