Does anyone have a method to understand complex SQL statements? When reading structural / OO code there are usually layers of abstraction that help you break it down into manageable …

If you are a kinaesthetic learner (learn by hands on participation), I've found this to be the best way of familiarizing yourself with the new database...as nice as an automated system is to …

Nov 19, 2013 · One great way to learn how to layout your database tables and columns is to use the EDMX Designer in Visual Studio 2010. You can create the Entities you want, define …

The other thing you might want to do is profile your SQL Server execution stack and find out if all the queries are indeed the correct ones, e.g., if you are using just one query which returns …

Feb 9, 2012 · I would recommend to use nvarchar(max) if you plan to use JSON features on SQL 2016 or Azure SQL. If you don't plan to use those features, you could use varbinary(max) …

I'm writing an SQL Query, where a few of the columns returned need to be calculated depending on quite a lot of conditions. I'm currently using nested case statements, but its getting messy. …

Mar 8, 2012 · The Python tutorial is actually pretty good. There's also a video series on showmedo about python. Between those two resources, you should have more than enough …

Closed 5 years ago. I found that SQL stored procedures are very interesting and useful. I have written stored procedures but i want to write well crafted, good performance tuned and concise …

We have a large application mainly written in SQL Server 7.0, where all database calls are to stored procedures. We are now running SQL Server 2005, which offers more T-SQL features. …

Sep 15, 2011 · As a programmer I would like to get a strong hold on writing queries. In my college years I've read a few sql books and rest I've just learned working as a programmer for last …