I didn't mention any bulk loads or massive operations. My problem is not keeping the transaction log file small, the problem is that CHECKPOINT...
One of my databases (SQL SERVER 2000) Transaction Log file is growing and never truncates. This started in the last few days (last time the server...
Transaction Isolation Level is the default (Read Committed). How a transaction can help here? can you give an example? thanks
Hi, I have multi-thread application that runs the same stored procedure parallelly. Here is an example: IF OBJECT_ID('dbo.CustomerTotals', 'U') IS...
I don't like this type of writing at all, there is no logical transaction handling in this procedure and you update the same record several times...
No difference, you can check the execution plan
How did you schedule it? we are not mind readers...
I agree with mmarovic
Hey Null...<br /><br />1. I made some tests and checked the execution plan, but there was no difference.. <br /><br />2. I don't use * on my...
Hey All (:<br /><br />I have some views gathering data from monthly tables (same definitions) with UNION ALL.<br />for example:<br /><br />CREATE...
The solution i used is something like that:<br /><br />SELECT *<br />FROM<br />Users U<br />INNER JOIN UserPermissions UP<br />ON (<br...
Thanks, I like this one <img src='/community/emoticons/emotion-1.gif' alt=':)' />
thanks. i hoped to find a simple solution , i guess that the only way is to query the table twice.
Hey all I want to write a join condition which depends on the DATA in the joining table, I'll explain: Let's sat my first table is the users table...
Separate names with a comma.
