Category: sql-server

What is wrong with Cursors?

Post author By user user
Post date February 19, 2022
Categories In cursor, data-structures, oracle, sql-server
7 Comments on What is wrong with Cursors?

SQL Server developers consider Cursors a bad practise , except under some circumstances. They believe that Cursors do not use the SQL engine optimally since it is a procedural construct and defeats the Set based concept of RDBMS. However, Oracle developers do not seem to recommend against Cursors. Oracle’s DML statements themselves are implicit cursors. […]

Simple Failover for IIS and MS SQL server

Post author By user user
Post date February 19, 2022
Categories In failover, iis, redundancy, sql-server, web-applications
4 Comments on Simple Failover for IIS and MS SQL server

I have a client with a .Net 1.0 web app that uses IIS and a SQL 2000 database. It is hosted with a shared hosting service and does get not much traffic (a few visitors a day tops). The hosting has occasional downtime, of course, and the client has asked me if I can setup […]