In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function.
When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.
Data in our systems has an actual dollar value, which we might be aware of if we have to purchase more.
In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language to import and transform data.
Snippets will allow you to code faster by inserting chunks of code with few key strokes.
Before you go live, test your backup and CHECKDB speeds.
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Comments posted to this topic are about the item What Did Healthy Look Like?
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
How many types of DML triggers are there?
See possible answers