Solving tech problems

22.12.2013

Top 10 query optimizing tips for MS SQL Server

During my 15 years of experience and working on various projects that involved using MS SQL Server in combination with C# programming language, and also gathering knowledge from different conferences, especially from the last one that occured today at SQL Saturday by ApexSQL where Miloš Radivojević showed some tips, I tried to summarize this knowledge in a small list of recommendations that you should be aware of when writing the Transact SQL queries… 1. Using local defined variables When possible always try to use direct values instead of variables (this…read more

20.11.2013

How to create Linked MS SQL Server in Management Studio?

Databases

Creating MS SQL Linked Server means that you can access your remote MS SQL database (on other server) like it is local. Syntax to access some data is as simple as that: [linked server name].[database name].dbo.[table name] Official Microsoft documentation is really sometimes hard to use. A lot of information but none practical example of usage. Google search also didn’t helped much on the first try. After few tries I finally found out how you can add MS SQL Linked server to your existing database server. So, you need first…read more

23.07.2013

How to find quickly specific table in DBML designer in Visual Studio

Databases

I spent a lot of time in my life working on complex web, mobile and desktop projects in Microsoft Visual Studio and dealing with databases and I always wanted and easy way to find specific SQL table in DBML designer in Visual Studio. This is how DBML designer looks like: This is only one prt of DBML and if ou don’t have 30″ screen it is really hard to find specific table. Usually, after changing just on column in specific table, or adding/deleting some column, it is easier to delete…read more

MongoDB vs MS SQL Server Comparison

Databases

We are using both databases for our projects and we can finalize some thoughts on both of them… Mongo Facts Free – official website is here and you can download it here Because it is using NoSQL concept it is really extremely fast when it comes to the inserts into database. It is almost fast as writing directly into the disk. It is at least 10 times faster when doing inserts. Because is is using NoSQL there is no scheme, you just store your object into database (JSON serialization is…read more

31.05.2013