Quick Editing Tips (Day 23)
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
183 reads
There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these...
2018-01-23
183 reads
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
322 reads
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
125 reads
The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...
2018-01-21
368 reads
The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...
2018-01-21
118 reads
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
410 reads
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
126 reads
Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...
2018-01-19
360 reads
Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...
2018-01-19
210 reads
You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up...
2018-01-18
276 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers