SQL Server: Error – Web application can’t import data from a file to SQL server anymore
Related information: This happens afer database migration is done from SQL 2008 to SQL 2015 Solution Reason: The workaround was to ensure that the Web […]
MSQL
SQL: DB/ Table Queries
SQL Server Management Studio How to find a certain string inside a stored procedure/ function [sql]SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, ‘IsProcedure’) = 1 AND […]
SQL statements – SELECT
How to know number of rows being affected by SELECT/INSERT/UPDATE…? SQL Server[sql] UPDATE Employee SET JobTitle = N’Executive’ WHERE NationalIDNumber = 123456789 IF @@ROWCOUNT = […]
Query tuning
General Speed depends much on indexes than other things JOIN is quicker than IN Index Index improves performance of SELECT queries Index should be applied […]