SQL
SQL Server 2005 Backward Compatibility
This feature is installed automatically by the Microsoft SQL Server install for most editions of SQL Server, but is not included in the 32-bit install for SQL Server 2008 and above, so therefore only the x86 download is given. Automated installation of SQL Server 2005 Backward Compatibility is performed by Process Id 4IE and is …
Essential skills on T-SQL Programming
> Create Database Objects – CREATE/ALTER/DROP TABLE/COLUMN – Data Types (XML, DATETIME, SPATIAL, VARCHAR) – Constraints (Primary Key, Foreign Key, Unique, Check, Default) – Calculated Column – Views – Indexed Views (SCHEMABINDING, COUNT_BIG(*), CLUSTERED INDEX) – Stored Procedures, [link]. – DML Triggers (INSERTED, UPDATED, UPDATE function) vs CHECK Constraint – TRIGGER for VIEWS (INSTEAD OF) …
Move DB files to new location
In my opinion, we should perform database migration/movement programmatically in order to achieve an automated task, freeing up human resources from tedious tasks. SQL Server 1) ALTER DATABASE <dbname> SET SINGLE_USER WITH ROLLBACK IMMEDIATE; 2) ALTER DATABASE <dbname> SET OFFLINE; 3) ALTER DATABASE <dbname> MODIFY FILE 4) ( 5) Name = <dbname>_Data, 6) Filename …
