Useful tips for everyday
How do I use NodePort in Kubernetes? Configuring the Service Log into the master node. Edit the service definition to specify spec. type:NodePort and optionally…
How can I test my server performance? Seven Performance Testing Steps Identify the testing environment. Identify performance metrics. Plan and design performance tests. Configure the…
What are archive logs in Oracle? What Is the Archived Redo Log? Oracle Database lets you save filled groups of redo log files to one…
What are the different types of cursor in SQL Server? SQL Server supports three cursor implementations. Transact-SQL cursors. Transact-SQL cursors are based on the DECLARE…
How do I count the number of tables in SQL Server? INFORMATION_SCHEMA. TABLES returns one row for each table in the current database for which…
What is System NT Authority? The account NT AUTHORITY\System which is a Local System account.. It is a powerful account that has unrestricted access to…
Does truncate release storage space SQL Server? Any truncate/delete/drop on Sql Server doesn’t release space back to disk. Truncate/Delete/Drop should follow DBCC Shrinkfile to reclaim…
How can check SQL server mirroring status? To view the status of a database mirroring session After connecting to the principal server instance, in Object…
How often do SQL dynamic port change? Named instances can be configured to use TCP 1433, but by default, named instances are configured to use…
How do I rebuild a fragmented table? Using SQL Server Management Studio: Expand the specific table. Expand the Indexes node. Right-click on the fragmented index…