Sql Server Bits and Bats
More of that pesky SQL Server stuff that I can never quite remember (checked with SQL Server 2008):
| F5 Ctrl+E Alt+X | Execute Query |
| Ctrl+T | Output as Text |
| Ctrl+D | Output as Grid |
| select @@version | Version of sql server |
| select serverproperty('productversion'), serverproperty('productlevel'), serverproperty('edition') | Version of sql server (Since 2000) |
| sp_help table | Long info about a table (or other object) |
| sp_tables table | Short info about a table |
| sp_helpindex table | Indexes for a table |
| sp_who | Current connections |
| kill spid | Kill a connection |
| sp_rename 'dbo.oldtable', 'newtable' | Rename a table (or anything in sys.objects) |
| sp_rename 'dbo.table.oldcolumn', 'newcolumn', 'COLUMN' | Rename a column |
| Limit Server memory | Right Click (at top level)->Properties->Memory->Maximum Memory |
| Logons | Right Click (at top level)->Activity Monitor |
| Simple Recovery | Right Click (on database)->Options->Recovery->Simple |
| Backup | Right Click (on database)->Tasks->Backup |
| Shrink | Right Click (on database)->Tasks->Shrink |
| Rename database files | Right Click (on database)->Tasks->Detach Rename on file system Right Click (at top level)->Tasks->Attach (will have to adjust filenames) |
| Test connection with telnet | telnet bsq101 1433 Ctrl + ] quit |
| Test connection with odbc | On desktop make empty text file: test.udl double click fill in odbc credentials click test connection |
| Force protocol in connection string | server=tcp:hostname server=tcp:hostname, portNumber server=np:hostname server=np:\\hostname\pipe\pipeName |
| Switch off connection pooling in connection string | pooling=false; |