Category Archives: SQL General Information

Upgrade SQL Server 2016 to Service Pack 1 faced with Exit code (Decimal): -2068380094

I wanted to upgrade the SQL Server 2016 installed on my laptop to service pack 1 last night. But the setup failed with this error:   Final result:                  The patch installer has failed to update the shared features. To determine … Continue reading

Posted in Database Administration, SQL General Information | Tagged , , , ,

Event ID 129 Reset to device, \Device\RaidPort0, was issued on Database Server

Two months ago, one of my clients called me that his DB Server is not responsive. Their Server is a HP DL580 with this specs: CPU: 4 x 12 cores Memory: 256 GB Storage:  2 x Raid 10 (8 x … Continue reading

Posted in Database Administration, SQL General Information | Tagged , , , , ,

T-SQL: Improve the Performance for LIKE Wildcard by Changing the Collation

Well, I published new article about how to tune the performance for LIKE wildcard queries… Please navigate to this article on Microsoft TechNet Wiki  I’ll also publish it on this blog soon! 🙂

Posted in Best Practices, Joy of T-SQL, SQL General Information, T-SQL Tips & Tricks

TNWikiSummit15 Presentation: Error Handling in SQL Server 2012 and 2014

  The follow text is copied from this blog: Official Blog of TechNet Wiki   Using Error Handling within the Transact SQL language needs a deep knowledge. It depends on the SQL Server version, there are various implementations for handling the … Continue reading

Posted in Best Practices, Joy of T-SQL, SQL General Information, T-SQL Tips & Tricks

Webinar: Error Handling in SQL Server

    March 19, 2015 9:45 PM GMT Saeid Hasani Structured Error Handling in SQL Server The goal of this session is to provide a simple and easy to use error handling mechanism with minimum complexity. This session is compatible … Continue reading

Posted in Best Practices, Joy of T-SQL, SQL General Information, T-SQL Tips & Tricks

T-SQL: Delete All Rows From a Table Except Top(N) Rows

I added the article which comes from a question that asked in MSDN forum. The problem is how to delete all rows from a table but remain the Top (N) rows, for example, remaining only the top (1000) rows. All Code samples … Continue reading

Posted in Best Practices, Joy of T-SQL, SQL General Information, T-SQL Tips & Tricks

[Fixed] SSMS – Create script duplicates the statements for Grant or Deny Column Permissions…

I was reported a bug in Microsoft SQL Server (all versions) that related to generate script for database permissions on August 20, 2013. Steps to Reproduce Open SSMS >> Connect to Server >> In Object Explorer expand a Sample Database … Continue reading

Posted in Database Administration, SQL General Information

SQL SERVER BACKUP Database Permission

When speaking about Permission term in SQL SERVER , It has two parts: Server Permissions Database Permissions And from another point of view, the SQL SERVER ROLE also has two parts: Server-Level Roles Database-Level Roles In fact the Security Model of SQL SERVER is a hierarchical … Continue reading

Posted in Best Practices, Database Administration, SQL General Information, T-SQL Tips & Tricks

BULK INSERT multiple Files in SQL SERVER Express

This post comes from this MSDN Forum question. Because of use SQL SERVER Express, we cannot use Integration Services(SSIS). Therefore, we  have two choices: BULK INSERT OPENROWSET(BULK…) In each statement you can insert only one column with above choices. Erland Sommarskog was … Continue reading

Posted in Database Administration, SQL General Information, T-SQL Tips & Tricks

CHECKDB

According to MOB, DBCC CHECKDB Checks the allocation, structural, and logical integrity of all the objects in the specified database.

Posted in Database Administration, SQL General Information, T-SQL Tips & Tricks | Leave a comment