Even though the SQL Server Database Engine automatically sets the best possible locking hints on the underlying database objects of the various T-SQL operations that executes, there are cases where we need to manually control locking as a part of the business logic in our T-SQL script. About the NOLOCK Table Hint A popular locking … Read more…
Hi! I hope you are all doing well and having a great summer time! It’s been a while since the last time I have posted an article but hey, besides the heavy workload, it’s summer time and the beaches in Cyprus are really great! 🙂 This post discusses about a quite simple task in SQL … Read more…
The Story Behind Dynamic SQL Generator At some point in the past, in the early years of SQLNetHub, it reached 100.000 visits. Given this opportunity I decided to try to do something special, for example write a pretty cool article or even better, build a SQL-Related tool and make it available on SQLNetHub! Before talking … Read more…
In this article, we will discuss about executing heavy set-based operations against Very Large Datatabases (VLDBs) in SQL Server. Introduction Recently I had to design and execute some heavy set-based T-SQL operations against a large number of very large databases (VLDBs) within a SQL Server instance. I won’t enter the debate of Row-Based vs. … Read more…
In this article, we will be discussing about using Unicode in SQL Server. Introduction Unicode is the standard used in the computing industry for encoding and representing any text in the most written languages (…). SQL Server supports Unicode, thus allowing the easy storage and manipulation of data in the most languages. Example … Read more…
Today is a very special day! I just got re-awarded with the Microsoft MVP Award on SQL Server for the third year in a row! —————————————— Dear Artemakis Artemiou, Congratulations! We are pleased to present you with the 2011 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their … Read more…
This article, discusses about the NOLOCK Table Hint in SQL Server. About Query Optimizer in SQL Server Each time you write and execute a T-SQL Query in SQL Server, the Database Engine selects the most optimized query plan for executing the query. The SQL Server Database Engine component that undertakes this task is the … Read more…
This article, discusses how you can resolve the error “Database [Database_Name] cannot be upgraded because it is read-only or has read-only files“. About the Error Message At some point in the past, I was trying to attach some databases on a SQL Server 2005 instance. The database files were copied over the network and … Read more…
At some time in the past, I set up a maintenance plan in one SQL Server instance for rapidly tuning up a set of databases with some simple tasks such as index rebuild, etc., and I got the error message: “No global profile is configured. Specify a profile name in the @profile_name parameter”. About … Read more…
[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. T-SQL code snippets is a very handy new feature originally shipped in SQL Server 2012. Using code snippets you can save time when you write code and you just need to enter code that does common tasks. Code reuse has … Read more…
Hello and Happy New Year 2011! Wishing all the best, always in good health! Microsoft has recently released CTP1 of SQL Server 2012 codenamed “Denali“. This new version of SQL Server Server introduces many new features that increase productivity and reduce the development and administration effort. One of my main observations is that there is … Read more…
Well, I guess that’s it. It’s time to say goodbye to 2010 and welcome a brand new year: 2011! Like last year, in this post I am presenting a set of selected tweets I did in 2010 grouped into different categories. Again, it was a great experience communicating with the SQL Server Community among other, … Read more…
This article discusses about dynamically generating T-SQL statements for SQL Server database administration and development purposes. Why Dynamically Generating T-SQL Statements? So you have many databases, objects, etc. and you want to massively administer it right? In some of my previous posts I explained the undocumented stored procedures “sp_msforeachdb” and “sp_msforeachtable” that allow you … Read more…
Lately I have been dealing a lot with SQL Server development that involves among other, segmenting strings. So, I decided to post an example-based article that discusses some simple ways of segmenting strings with T-SQL mainly by using the SUBSTRING built-in function and some other built-in functions such as CHARINDEX, LEFT, RIGHT and LEN. Additionally, … Read more…
Cyprus .NET User Group (CDNUG) brings another event to you, by/for the Community! This month’s event features two sessions: Microsoft and Openness Clustering in SQL Server 2008 The first session, with speaker Andreas Hadjipanayi (Technical Account Manager at the local Microsoft Office in Cyprus) discusses how Microsoft has become more open over time. The major discussion … Read more…