Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

read data (data window) unclear

yucikala's profile image yucikala posted 1 year ago in Running SQL scripts Permalink

Is's possible to read data at MSSQL with nolock when I use data window? It very help...

There can be some settings (nolock or not nolock).

Thanks

ansgar's profile image ansgar posted 1 year ago Permalink

Are you using the "Data" tab or a "Query" tab?

What exactly means lock/nolock?

yucikala's profile image yucikala posted 1 year ago Permalink

Data tab. When I use query tab, I can use nolock manualy. I Like Data tab.

Nolock query: select from Table (nolock) Normaly : select from Table e.g.: https://www.mssqltips.com/sqlservertip/2470/understanding-the-sql-server-nolock-hint/

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 1 year ago Permalink

Ah ok, you're on MS SQL - and that (nolock) is an SQL extension, right?

You should file an issue in the bugtracker for that.

yucikala's profile image yucikala posted 1 year ago Permalink

I'm not sure if not using nolock is bug. What ever using nolock make more faster reading and does not lock tables.

So - may I put it to bugtracker?

ansgar's profile image ansgar posted 1 year ago Permalink

The tracker is also for enhancements, not only for bugs. So, yes, please file an issue there.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.