How is your skills with Linq? The reason I ask is because I find a lot of set problems work nicely in Linq much as they do in SQL. You can do joins, grouping order aggregation filtering and much more. The concepts are very similar to SQL, but different enough that it takes a little amount o f work to […]
Other News
Tips for using constraints in SQL Server 2014
Tips for using constraints in SQL Server 2014 Use CHECK constraints instead of rules. Rules are provided for backward compatibility and have been replaced by CHECK constraints. Constraints are much more efficient than rules and can boost performance. Rules have some restrictions. For example, only one rule can be applied to a column, but multiple CHECK constraints can be applied....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Making jQuery and Boostrap 3 and ‘hide’ class work together
(Billy) One of the problems with using jQuery’s show and hide methods is that they are no compatible with the provided Bootstrap css classes “show” and “hide”.
Blooms
(David Fitzjarrell) In Oracle releases 10.2.0.x and later join processing can be made more efficient by the use of Bloom filters, primarily to reduce traffic between parallel query slaves. What is a Bloom filter? Named after Burton Howard Bloom, who came up with the concept in the 1970s, it’s an eff
Calculating HTML ID for ADF UI Table Row
(Andrejus Baranovskis) Each row in ADF UI table is assigned with ID, this is how rows are referenced in HTML. I had a blog post describing how to set a focus for newly inserted row – Improving ADF UI Table CRUD Functionality with Auto Focus. I’m getting ID for selected row using getClientRowKey meth
How To Create Read Only CheckBox In ASP.NET
CheckBox control is standard ASP.NET control, used to take user’s input when user should choose between two opposite options like yes/no, checked/unchecked, true/false etc.
ASP.NET GRIDVIEW CLIENT SIDE VALIDATION
(taditdash) We will explore the technique in jQuery to validate the ASP.NET GridView.
Features Of ES6 Part 6: Destructuring
(K. Scott Allen) To destructure an object is to dismantle or tear apart an object.
Query Cached Execution Plans
(Derik Hammer) Often I need to examine an execution plan from a production server. Just as often, I can’t re-run the stored procedure in that environment. There are several techniques for simulating the environment on a test server such as exporting statistics and using the un-documented DBCC AUTOPI
SQL Server Cluster resource fails with ‘Data source name not found and no default driver specified’ error
(Pradeep Adiga) Last week I had worked on SQL Server 2008 R2 installation on a Windows Cluster. The installation would go fine until the installer tries to bring the SQL Server resource online. At that time it would fail with the following error message,