Useful tips for everyday
What is browser service in SQL Server? SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server…
How do I start Oracle SQL Plus? Starting SQL*Plus Windows GUI Click Start > Programs > Oracle-OraHomeName > Application Development > SQL Plus. Alternatively, open…
Is there an Oracle Application Server 10g 10.1.2? Oracle Application Server 10g Release 2 (10.1.2) is not certified/supported on newer platforms such as Oracle Linux…
What is daisy chaining and what does it mean? In the world of electronics, unfortunately daisy chaining isn’t nearly as innocent as its name might…
How do you pass dynamic values to a prepared statement? Create Database Connection. Create SQL query with Placeholder. Connection. prepareStatement() Set the query parameter by…
How can reduce database size? To shrink a database In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand…
How efficient is SQL MERGE? The basic set-up data is as follows. We’ve purposely set up our source table so that the INSERTs it will…
How to automatically report SQL Server Backup status? Summary: Learn how to use Windows PowerShell to automatically email a report on SQL Server backup status.…
How do I run SQLCMD in PowerShell? Script run from PowerShell ISE: $SQLServer = “TestServerOne” $db3 = “TestDB3” $selectdata = “SELECT Id, IdData FROM invokeTable”…
Should fact table have foreign keys? The fact table also has a primary (composite) key that is a combination of these four foreign keys. As…