Sometimes we need to change Collation after we have done SQL Server Installation. I will do my warning from the beginning. After changing Collation, …

  The File Table uses the technology of File Stream. It keeps file system data as a table. That is, you can access the data …

  Cellcli can be used to change e-mail alert settings on cell servers.   To find out the current situation: [crayon-676f8b5e34828638058046/]   To change: [crayon-676f8b5e3482d368408841/] …

  Full-text Search used to search for columns with large text, such as varchar (max). You can do the same with LIKE, but LIKE will …

ERROR: When a query is executed, an error “ORA-04030: out of process memory when trying to allocate nn kilobytes” is being received. SOLUTION: Decrease pga …

  The File Stream structure keeps the BLOB objects (document, image, video, etc.) integrated with the database on the NTFS File system on the server. …

ERROR: When opmn services are started, the following error is being received. BIND (Address already in use) x.x.x.x: 393478144 – listener BIND failed [crayon-676f8b5e353c9434495262/] When …

In this article, we will install SQL Server 2014. Other versions can be installed in similar ways. Stand-Alone means installing only one instance on a …

  You can encounter this problem on HP-UX platforms. PROBLEM: Many trace files are being created with the error “Ioctl ASYNC_CONFIG error, errno = 1”. …

  Assume that the default temp table space of the system is TMP. ERROR: ORA-01187: can not read from file because it failed verification tests …