(Pinal Dave) I cannot get enough of working with TempDB and the learning never stops. Previously, when I wrote about SQL SERVER – Is tempDB behaving like a Normal DB?, SQL SERVER – Inside Temp Table Object Creation and Difference TempTable and Table Variable – TempTable in Memory a Myth many did ask
Other News
ngSwitchWhen Priority Is Higher Than ngRepeat Priority In AngularJS 1.3
(Ben Nadel) This is a really minor post about a change in directive priority in AngularJS 1.3. The other day, in my post about using multiple templates in a single ngRepeat directive, Boris Litvinsky brought it to my attention that ngSwitchWhen now executes at a higher priority (1,200) than the ngRe
Working with Someone You Hate
Working with Someone You Hate Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to learn...
Why To Choose Java
(Anas Chaudhary) This article highlights the advantages of Java and builds your affection for Java Technologies.
Data purge algorithm: Efficiently delete terabytes of data from DB2 for Linux, UNIX, and Windows
(Saurabh Agrawal) Big data introduces data storage and system performance challenges. Keeping your growing tables small and efficient improves system performance as the smaller tables and indices are accessed faster; all other things being equal, a small database performs better than a large one.
Oracle SQL regular expression – check for numbers or special characters
(Tobias Arnhold) We all know the regular expression syntax is fast and you can do amazing things with little code snippets. But we do know as well that whenever you need it then you have no idea how to write it down. To be able to find a solution for your problem you use the WWW.
Pulling Large Database tables in R
(Brendan Tierney) As the volume of the data in your tables grows, particularly in the big data world, you may run into some memory issues or package restrictions with pulling down the tables to your R environment.
Reading MAF iOS Simulator Logging Output
(Andrejus Baranovskis) It could be very handy to know how and where to read MAF logging output from iOS simulator. This is not that obvious to find logging output on Mac OS system. All log is written into application.log file, this file is located inside temporary application directory.
New Option to Stop the Server If Binlogging Fails in MySQL 5.6
(Sujatha Sivakumar) In this post I will try to explain the new MySQL binlog_error_action server option. This new option is available from MySQL 5.6.22 and later.
Using Templates With SQL Server Management Studio
(Thomas LaRock) I love learning new things. I feel like a kid again at times, my eyes get wide as I imagine new possibilities using whatever things it is I have found. This is how I felt last week when I came across a feature of SQL Server Management Studio (SSMS) that I had not seen before despite