To select vertical text in SSMS, hold Alt and drag with the mouse, or hold Alt and Shift and press the arrow keys. This post explains what a vertical selection does, how to edit many lines at once and how to turn a pasted column into an IN list. It also shows a T-SQL alternative for long lists.
Remove Completion Time From the SSMS Messages Tab
To remove completion time from the Messages tab in SSMS, clear one check box in the options. This post gives the exact steps for SSMS 22, explains why no T-SQL setting controls the line and says why old query windows keep showing it. It also shows how to print a time yourself, when a script needs one.
SQL SERVER – Installation Error: 25641- For target, “package0.event_file”, the parameter “filename” passed is invalid. Target parameter at index 0 is invalid
While installing SQL Server 2012 in a client environment, they faced an interesting error about for target. Here is the information that is taken.
go-sqlcmd: The New Command Line Tool for SQL Server
Set up go-sqlcmd on Windows, verify the executable, run scripts and variables, control output, and review optional container commands.
SCHEMABINDING View: What You Can Change in the Table
A SCHEMABINDING view locks the columns it uses and leaves the other columns of the table free. This post tests which changes SQL Server blocks, shows the messages and lists the bound columns with a query. It also shows how to change a bound column inside one transaction.
What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245
SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.
SQL SERVER – Identifying and Fixing PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type
I walked into a client engagement where I really got stuck with a very interesting scenario with a client with PREEMPTIVE_OS_RSFXDEVICEOPS Wait Type.