Read our high-quality articles on SQL Server development. Learn how to efficiently develop data processes in the world’s biggest DBMS, that is SQL Server.
In this article, we will be discussing about, how you can easily list all tables of a linked SQL Server database. Introduction There are many scenarios in the DBMSs world where you might need to use a linked server between two different SQL Server instances in order to execute direct queries between them. However, the majority … Read more…
Good evening (or good morning) friends all around the globe! Wherever you are, whatever you do, wishing you a nice rest of the day (or night!) 🙂 This is the last of a series of posts that deal with the task of importing and exporting unstructured data in SQL Server. The first article of this … Read more…
A few weeks ago I posted an article on how to import and export unstructured data in SQL Server by using the “image” data type. In this article I will show how you can manipulate unstructured data in SQL Server 2008 or later by using the FILESTREAM feature. FILESTREAM allows storing unstructured data (i.e. music, … Read more…
In this article, we will be discussing about, how to import and export unstructured data in SQL Server, using the IMAGE datatype. Introduction Importing and exporting unstructured data from a database is a common practice, especially in large applications. SQL Server 2008 introduced the FILESTREAM feature that allows storing unstructured data (i.e. music, video, documents, … Read more…
SQL Server programmability objects such as stored procedures, functions, assemblies, etc. are widely used, especially in cases of a major database design where you want to have a well-structured database with code reuse and performance. The need to know where are Programmability Objects Stored in SQL Server Even though many of us use these … Read more…
This post, is actually a T-SQL tip, on how to easily insert leading characters to a string. The Scenario for Inserting Leading Characters Consider that you have a fixed-length table column for which you want to add leading characters, so that all its records, values with the same number of characters. How to Insert Leading … Read more…
Earlier this month, on the 22nd, another Cyprus .NET User Group event took place. The event featured two hourly topics dedicated to the Microsoft Cloud and its services. The first topic was on Windows Azure for Developers and the second on Windows Azure SQL Database, formerly SQL Azure. The event was also live streamed and … Read more…
We live in a Data World. I cannot tell you whether this is a good or a bad thing but I can tell you for sure that this is a fact. Everything works based on data. In the enterprise, this data needs to be stored into powerful, scalable and robust data platforms (Relational Database Management … Read more…
[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. We are very happy to announce the general availability of version 2.0 of Snippets Generator. Snippets Generator allows the user to easily create T-SQL snippets for SQL Server 2012 and later! You can create a snippet from scratch or … Read more…
Yeah, I know, who would ever want to do that (!) but the purpose of this post is not to illustrate how you can actually get all the records from all tables in all user databases (even though it shows how to do it) but rather to provide an example of how we can dynamically … Read more…
OK folks, it did happen at some point, to get this error message: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. Reproducing the Internal Query Processor Error Message I was trying to execute the following query: SELECT * FROM dbo.tbl1 WHERE tbl2ID=(SELECT … Read more…
When you try to run a string function directly on a text or ntext column, in this example the “LEFT” function, you will get the following error: Argument data type ntext is invalid for argument 1 of left function. Similarly, if you try to run the REPLACE function against a text or ntext column, you will … Read more…
If you are looking for a T-SQL tip, on how to create a simple linked server between SQL Server instances, then the below tip might come in handy. T-SQL Example for Creating the Linked Server The below T-SQL code does just that: — –Note: The Entire Operation Takes Place on the Local Instance — … Read more…
In this article, we will be discussing about Sequence objects in SQL Server 2012 and later, and see a relevant example. In an older article on our blog, we wrote on how someone can mimic the operation of Sequence Objects using other alternative ways. However, since SQL Server 2012 and later, Sequence Objects are available … Read more…
In an older post, we have discussed about, how you could rebuild all the indexes of a database in SQL Server by making use of the undocumented stored procedure “sp_MSforeachtable”. Retrieving Table Size Info using sp_MSforeachtable Another common task is when you want to retrieve size information for all the tables in a database. … Read more…