(Pinal Dave) In this blog post we will discuss a very common problem which developer who are working with SQL Server Management Studio and VARCHAR(MAX) Datatype faces. In database table if you have over 8200 characters in a column with datatype VARCHAR (MAX) it is not easy to display them in SSMS.
Author: SSWUG Research
Conditional Aggregates
(Matt Bowler) The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a debit. We want an aggregate (over a given range) of the amounts. We need to add the credits and subtract the debits.
Top 10 Performance Features of DB2 LUW 10.5 and 10.1
(Joe Geller) DB2 10.5 is best known for BLU Acceleration, which is the new columnar store for tables. Organizing tables by column rather than row can lead to dramatic improvements in elapsed time for analytical queries.
OSB scripted export: Branch target offset too large for short
(Martien van den Akker) The weirdest thing occurred to me yesterday. I have this OSB-project in Eclipse that is working fine and can be published to the dev-server perfectly.
Wrong Result Bug using group-by placement optimization
(Marko Sutic) Last week I’ve mentioned on Twitter that we ran into wrong result bug. We found workaround quickly but I’ve decided to spend some time to reproduce error and write blog post to warn you about this optimizer behavior.
Introducing ASP.NET MVC Throttling Filter
(Stefan Prodan) With MvcThrottle you can protect your site from aggressive crawlers, scraping tools or unwanted traffic spikes originated from the same location by limiting the rate of requests that a client from the same IP can make to your site or to specific routes. MvcThrottle is compatible with
Back to the Basics – Working with Dates in VB.NET
(Hannes Du Preez) Working with Dates can get pretty frustrating sometimes, especially if you are a new or inexperienced developer. One particular mistake new developers make is that they do not realize that Time is also in fact a date – they find it hard to fathom. If you are very new to programming
Working With Stored Procedures In Entity Framework – Part 1
(Bipin Joshi) By default entity framework generates SELECT, INSERT, UPDATE, DELETE queries to perform the respective operations on the database. At times, however, you may want to deviate from this default behavior and use stored procedures for these operations. Additionally, you may want to call ar
IBM DB2 Analytics Accelerator: 5 Performance Enhancements in the New Version 4.1
(Dave Beulke) The IBM DB2 Analytics Accelerator (IDAA) continues to be improved, and the Version 4.1 enhancements really help take your SQL program performance to the next level. The following five changes within Version 4.1 of IBM’s DB2 Analytics Accelerator increase its flexibility, availability,
Determing BUCKET_COUNT for Hash indexes for Memory-Optimized tables in SQL Server
(Daniel Farina) You have migrated some tables to In-Memory OLTP, but instead of getting better performance on table operations, everything seems to be the same or even worse. What is going on? In this tip I will guide you to the answer for that question.