Recursive Relationships in Databases
One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to itself. … Continue readingRecursive Relationships in Databases
To upgrade or not to upgrade XAMPP 1.7.3
XAMPP is just another package of… … Continue readingTo upgrade or not to upgrade XAMPP 1.7.3
Paging records in MS SQL Server 2005
After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL). … Continue readingPaging records in MS SQL Server 2005
MS SQL Server: Temporary Tables
Just a way of using temporary tables in Microsoft SQL Server, if you want to duplicate one or more records quickly, you can use commands like this… … Continue readingMS SQL Server: Temporary Tables
MS SQL Anomalies 3
For those who are still using ancient data types such as CHAR be careful if you are also using REPLACE function in MS SQL servers… … Continue readingMS SQL Anomalies 3
Broken SQL objects: Views, functions, stored procedures, triggers
Designing a perfect entity relationship diagram for our database together with a marvellous table structure is never good enough… … Continue readingBroken SQL objects: Views, functions, stored procedures, triggers
MS SQL Server: Anomalies 2
We had a database in MS SQL 2000 server. The server/database was configured NOT to use recursive triggers. … Continue readingMS SQL Server: Anomalies 2
MS SQL Server: Using Remote Servers (Linked Servers)
Sometimes I need to have a quick way of transferring data from one database to another running on a separate machine, especially when the table structures are identical or similar, it saves time. M$ SQL Server 2005 has a feature called linked servers. … Continue readingMS SQL Server: Using Remote Servers (Linked Servers)
MS SQL Server: Anomalies
Backup/restore databases: After the restore, you must revoke (sp_revokelogin) and grant access (sp_grantlogin) to users again, esp. if you are restoring the database on a different machine. … Continue readingMS SQL Server: Anomalies