Lucky me (I thought), I have to convert an Oracle 8i database with about 400 tables to Sql Server 2005. So, the first thing I thought, I'll use the Sql Server Migration Assistant (for Oracle) and probably the (first part of the) migration will become a peace of cake. Gotcha! Read the story... The result of a conversion project is...
posted by
on
to
()
I recently had to deal with an environment with a lot of blocked processes. I was tiered of resolving the lock-chains with sp_who2. With the following ingredients I made a receipt called “sp_blocked6”, in Sql Server, we speak about a stored procedure. Ingredients: - I concentrated on sys.sysprocesses, the compatible view on which...
posted by
on
to
()
I want to have it about a new database-setting in Sql Server 2005: Asynchronous Statistics Updates Statistics are very important for the optimizer. The optimizer needs this information to decide which indexes to use or not. It is on basis of the statistics that an optimal execution plan is created. Now, if there are enough data changes...
posted by
on
to
()
Hi Reader, This is new to me: "blogging"; after some requests of a good friend and core-member of SQLUG.be , Bart ánd a lot of time of negotation with myself if I would find enough time to blog regularly, I decided to give it a try. In the about you can read about what my blog mainly will go about and why I choose the blogname "Por...
posted by
on
to
()