MSSQL

Common error after installation of MS SQL server 2012

After installation of MS SQL Server 2012 on Windows Server 2012, I had gotten these errors in Event Viewer on execution server:The server was unable to initialize encryption because of a problem with a security library. The security library may be missing. Verify that security.dll exists on the system.TDSSNIClient initialization failed with error 0x139f, status […] Read more»

SQL and databases

Get records with empty binary items

There’s a column Photo with type “Image” in MS SQL table (database – MS SQL Server 2008 R2). The task is to get all the records where Photo is empty. Values of empty images is “0x00000000”. Read more»

SQL and databases

Count rows in result of SQL query

To receive quantity of rows of the returned records of SQL query, you should use function @@ROWCOUNT. Function @@ROWCOUNT returns the quantity of rows, which were used in a query. Read more»

SQL and databases

Saving changes is not permitted in MS SQL Management studio

Figure 1. Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created

When you modify columns of a table in MS SQL management studio, you got the message “Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created … ” (Figure 1). The reason of this is re-creating of table. It’s really important for productive environment but not […] Read more»

SQL and databases

Rename table in MS SQL Server

Rename table in MS SQL Server: sp_rename 'old table name', 'new table name'   Read more»

SQL and databases

Conditions IF ELSE in Transact SQL

In this post I will write about SQL conditions. It seems to me that construction “IF … ELSE” you can find in any language. Transact SQL is not exclusion. Let’s see IF … ELSE in action on the sample below. Read more»

SQL and databases

Convert datetime columns in Transact SQL

There are two functions for converting SQL data types from one to another. They are CAST and CONVERT. The second function is the best solution for converting datetime to format you need. Read more»

SQL and databases

MS SQL. Add autoincrement field

Field with autoincrement is very useful thing and it’s often used in MySQL. In MSSQL you can also need to use this tool. There are two ways to do it. Read more»

SQL and databases

Move SharePoint site collection to another Content Database

If you have some site collections but your database grows every day. In  MSSQL size of database should be less than 200 Gb. So if your content database size less than 100Gb you can easily use only 1 database – it’s easier to backup and restore it. Read more»

SharePoint

Popular Posts