Delete Horizontal White Space in SQL Serve
When you are required to import data received from different different file format such as .txt, .csv., or excel files, sometimes you see a white spaces along with the data, which may create a problem…
192 total views, 1 views today
SQL ROLLBACK Transactions
SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If savepoint is specified then it rolls back the transaction to a savepoint within the transaction. Basically, it…
1,358 total views, 7 views today
SQL Server Computed Columns
A computed column is a virtual column which is used to add a new column to a table with the value derived from the values of other columns in the same table.
Computed column is not physically stored in the table, unless column is marked PERSISTED and it is persisted only if its expression is deterministic.
226 total views
Identify Blocked Processes or Long Running Query In SQL Server
Blocking occurs when a process hold a lock and other process has to wait till the first process completes.
966 total views, 6 views today
SQL Server CUBE
CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.
396 total views
Temporary table / temp table in SQL Server
Temporary or Temp tables are tables that exist temporarily on the SQL Server.
462 total views, 1 views today
SQL SERVER Interview Q & A QUIZ on SUBSTRING()
SQL interview question and answer on Substring function
407 total views, 6 views today
SQL Q & A on SELECT Statement
Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as Output 1> NULL 2> 1 3> Error 4> Invalid select…
153 total views
SQL FOREIGN KEY Constraint
A foreign key is a key used to link two tables together. This is sometimes also called as a referencing key , usually a primary key table is considered as a parent table while a foreign key table is considered as a child table .
170 total views
Truncate VS Delete statements in SQL Server
What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?
174 total views, 2 views today
SQL LOGON Trigger
It fires in response to LOGON events of SQL Server is raised .
A LOGON Triggers can be useful in may ways, such as to restrict number of connection made by a Login or to prevent a user from logging-in outside .
109 total views, 3 views today