Browse by Tags

All Tags » sql server (RSS)
Sunday, January 13, 2008 8:23 PM

My first book - Building a Web 2.0 Portal with ASP.NET 3.5

My first book " Building a Web 2.0 Portal with ASP.NET 3.5 " from O'Reilly is published and available in the stores. This book explains in detail the architecture design, development, test, deployment, performance and scalability challenges...
Posted by omar | 41 comment(s)
Filed under: , , , , , , , ,
Wednesday, September 19, 2007 8:46 AM

A significant part of sql server process memory has been paged out. This may result in performance degradation

If you are using SQL Sever Server standard edition 64 bit on a Windows 2003 64bit, you will frequently encounter this problem where SQL Server says: A significant part of sql server process memory has been paged out. This may result in performance degradation...
Posted by omar | 19 comment(s)
Filed under: , , , ,
Saturday, January 20, 2007 5:47 PM

Think you know how to write UPDATE statement? Think again.

When I was a kid, my mom used to read me UPDATE queries every night before I went to sleep. I heared many stories about updating objects to database where most of them were the same old: UPDATE [ Table ] SET Field1 = Value1, Field2 = Value2, . . . WHERE...
Posted by omar | 21 comment(s)
Filed under:
Sunday, September 17, 2006 7:04 AM

Large log file can bring SQL Server down when transaction log shipping runs

We were having very poor performance when we turned on transaction log shipping on our SQL Server. We are using SQL Server 2005. The transaction log file was around 30 GB because the database was in Full Recovery mode. The server became very slow, every...
Posted by omar | with no comments
Filed under:
Friday, September 15, 2006 11:01 AM

How to setup SQL Server 2005 Transaction Log Ship on large database that really works

I tried a lot of combinations in my life in order to find out an effective method for implementing Transaction Log Shipping between servers which are in a workgroup, not under domain. I realized the things you learn from article and books are for small...
Posted by omar | 22 comment(s)
Filed under: