Useful tips for everyday
How are callbacks still used in Node.js? Callbacks are still in use, and package developers still design their APIs around callbacks. One common Node.js issue…
Should I use SQLite or SQL Server? Microsoft SQL Server is a powerful, full featured SQL system that supports entire ecosystems. While SQLite is a…
What is the natural order of strings? In computing, natural sort order (or natural sorting) is the ordering of strings in alphabetical order, except that…
How do you escape a keyword in SQL? To escape reserved keywords in SQL SELECT statements and in queries on views, enclose them in double…
Are graph databases fast? Distinct from NoSQL and relational databases, a graph database is built for super fast access to complex data sets common to…
What causes a server to have a mirroring time out? Failures Due to Soft Errors. Conditions that might cause mirroring time-outs include (but are not…
How is cumulative calculated in MySQL? MySQL doesn’t have a function for calculating cumulative total, also known as running total. You need to write an…
How to limit resource usage using Resource Governor? Resource Governor announced with SQL Server 2008. We are able to limit resources of a session using…
How do I SELECT different values from the same column? The SQL SELECT DISTINCT Statement The SELECT DISTINCT statement is used to return only distinct…
What is cardinality and selectivity in Oracle? oracle oracle11g cardinality. According to this: Selectivity is the value between 0 and 1, and it is the…