5. SQL Server
What is the Difference Between a CTE and a Temp Table? CTE tables are used in a single query or procedure. Temp tables exist until the connection is closed. SQL…
11 Keyboard Shortcuts Every SQL Server Geek Should Know
. Open a new Query Window with current connection (Ctrl + N) This shortcut opens up a new query window with an existing connection. It will query to the same database…
SQL Server 2008 R2 Stuck in Single User Mode
Problem/Description: Cannot get the Database to go back into mulit user mode. Answer: For Checking the proccess IDs so you can kill them later exec sp_who SELECT request_session_id FROM sys.dm_tran_locks…
SQL – Setting the Value of Variables inside server scripts.
Using SELECT: SELECT @ModelID = m.modelid FROM MODELS m WHERE m.areaid = 'South Coast' Using SET: SET @ModelID = (SELECT m.modelid FROM MODELS m WHERE m.areaid = 'South Coast') See…
How to Truncate a SQL Server Log File
Open SQL Server Management Studio: Truncate by clicking: Don't do this on a live environment, but to ensure you shrink your dev db as much as you can: Right-click the…
Saving changes is not permitted in SQL Server Manager
Problem: Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't…