Since the release of SQL Server 7.0 in 1998, SQL Server has been on the enterprise fast track, steadily accumulating top TPC-C benchmark scores and increasing market share. Here are some exciting facts about SQL Server's growth...
Data types can hold pitfalls for folks who are new to the world of database development—and even for more experienced developers. One mistake happens frequently when novice database professionals represent numbers that contain decimal places...
Salespeople often spout the Ford Motor Company mantra, "The customer is job one." No doubt, keeping customers happy is a key factor in every company's well-being. However, customer satisfaction isn't—and shouldn't be—the primary job responsibility...
When I try to set up merge replication in SQL Server 7.0, the replication works fine, but I experience an ownership problem. Here's the scenario. A user named System owns all the database objects in an application named system. I set up...
I have a 30GB database, and I use the Full recovery model. Whenever I use Database Consistency Checker (DBCC) DBREINDEX to periodically reindex certain large tables, I change the recovery model to Bulk_Logged, then return it to Full after the...