(Ashish Kumar Mehta) While looking through the features in SQL Server 2008 Management Studio (SSMS), I noticed that SSMS only shows the Top 1000 rows when selecting data and the Top 200 rows when editing data for a table.
Other News
Do you write SOLID code?
DBTechCon – Spring 2011 DBTechCon starts today. If you are registered to attend, be sure to check your schedule for the live High Definition Streaming presentations. Do you write SOLID code? SOLID is an acronym from Robert Martin defining five basic principles of object oriented programming. If you are writing code in any object oriented languages such as Java, C++, […]
DBTechCon – Spring 2011
DBTechCon – Spring 2011 It’s finally here…In fact this is the last day to register to attend what is going to be the most valuable Virtual event of the year. This conference features over 20 speakers with names that have become synonymous with their areas of expertise. These experts and professionals will give you practical insights you will be able […]
Transaction Semantics in RDF and Relational Models
(Orri Erling) As a part of defining benchmark audit for testing ACID properties on RDF stores, we will here examine different RDF scenarios where lack of concurrency control causes inconsistent results. In so doing, we consider common implementation techniques and implications as concern locking (pe
Generating New Knowledge by Deductive Reasoning using Schematron
(Roger L. Costello) Here are 3 methods of reasoning or drawing conclusions:
jQuery: XML and CDATA sections
(Gabriele Romanato) One of the main abilities of jQuery is its advanced XML parsing during an AJAX request. All of this preprocessing lies under the hood, but becomes more evident when it comes to XML CDATA sections.
Disabling SQL Server Table Constraints
SQL Server databases should be configured with foreign key constraints to maintain referential integrity and check constraints to ensure that table data is always valid. Occasionally these constraints can be a hindrance and may be temporarily disabled.
DISTINCT Keyword in SQL
(Mike Chapple) The DISTINCT keyword in SQL allows you to select only those records that contain unique values for the columns requested in a SELECT statement. Duplicate values are ignored and only displayed once.
SQL SERVER – Transaction Log Impract Detection Using DMV – dm_tran_database_transactions
(Pinal Dave) Just a few days ago before I received the email from blog reader asking if there is any DMV which can provide details about the effect of a transaction on the transaction log file. Absolutely! Here is a quick script which can provide the necessary details:
Writing My First Node.js Module And Event Emitter
(Ben Nadel) Last week, I started to experiment with Node.js, a server-side Javascript runtime environment. In my example, I created a one-page web service that created an HTTP server and listened for CRUD-style requests on a cached data collection.