The most interesting part of my job is performance tuning and optimization in T-SQL. The heart of performance tuning in an SQL server is proper and usable indexing on tables through the use of Sargable queries.
Notepad++ is one of the smartest editors available that programmers typically use. If you have installed Notepad++, by default the system will not set Notepad++ as your default editor. Fortunately, you can use settings that are available in Notepad++ to circumvent this issue.
Most of the time in real life, we try to find the top three scores in a class, the top five runners in a marathon, or the top 10 goals of the month. SQL server has a feature to select the TOP n records from a table.
SQL language is divided into four types of primary language statements: DML, DDL, DCL and TCL. Using these statements, we can define the structure of a database by creating and altering database objects, and we can manipulate data in a table through updates or deletions. We also can control which user can read/write data or […]
Alter Table is a DDL (Data Definition Language) statement which is used to add, drop, or alter existing columns. With this statement, you can also rename a table or column and make constraints. Using a table as an example, this tutorial demonstrates alter table statements with syntax.
Category SQL Server
While browsing the web with Google Chrome or Mozilla Firefox, many users have experienced latency issues and have complained about videos and web pages loading slowly. The best solution to this problem is to disable the hardware acceleration setting which is available in the three major browsers: Mozilla Firefox, Internet Explorer, and Google Chrome.
A replace function in SQL Server is used to replace single or multiple characters with another single or multiple-character string.
SQL Server backup and restore operations are closely associated with recovery models. Recovery models are ways to manage how transactions are logged, whether or not the transaction log allows and requires backups, and what types of restore operations are possible. Recovery models helps us to bring back and preserve a database after any unexpected failure […]
By default, SQL server has added some limitations. For instance, changing data types in design mode, adding a column in the middle of two existing columns, and changing the null-ability of an existing column are not permitted to change from design mode in SQL server management studio (SSMS) because they require a table to be […]
As the number of stored procedures increases in a database, the burden of managing those stored procedures increases, too. On a production database, thousands of procedures are executed daily, so you are required to know why a stored procedure failed at a certain time. This can be done by implementing error logging and reporting within […]