Useful tips for everyday
How do I find the indexes on a table in SQL Server? On Oracle: Determine all indexes on table: SELECT index_name FROM user_indexes WHERE table_name…
What are some examples of corruption? Forms of corruption vary, but can include bribery, lobbying, extortion, cronyism, nepotism, parochialism, patronage, influence peddling, graft, and embezzlement.…
Where are deadlocks in SQL Server 2014? SQL Server: 8 different ways to Detect a DeadLock in a Database Using SP_LOCK, you can find the…
How do you remove quotes from a string in Java? “how to remove double quotes from string in java” Code Answer String x=”\”abcd”; String z=x.…
Is T-SQL and SQL the same? The obvious difference is in what they are designed for: SQL is a query language used for manipulating data…
What is MySQL buffer? Buffer pool. Also called buffer cache. The buffer pool is a global resource shared by all databases for their cached data…
How does TSQL speed up performance of insert? This prevents page splits (where SQL Server must move data around because an existing page is full)…
How to return the lowest value and return the adjacent cell in Excel? 2. With VLOOKUP function, you only can return the adjacent cell in…
How do I export an Oracle database structure? To create an Oracle Data Pump export of your data, code and data structure: Go to the…
Where is Oracle Instant Client installed? Go to the Oracle Database Instant Client website. In the Get Oracle Instant Client section, select Downloads. On the…