Useful tips for everyday
Can you run SQL and SQL Express on the same server? Answer: SQL Server considerations for running multiple instances on the same server: As long…
How query LSN number in SQL Server? Overview of SQL Server backups and LSN GO. declare @backupSetId as int. select @backupSetId = position from msdb..…
How do I select a subset of a row in SQL? To fetch a subset of selected rows we use TOP clause fallowed by integer…
When should you encrypt a database? Data at-Rest Encryption Encrypting an entire database should be done with caution since it can result in a serious…
Which one of the below statements best describes heap table a heap is a table without a non clustered index? A heap is a table…
Is it possible to shrink a transaction log file? I’m unable to shrink the log file of the databases. Transaction log backup of the databases…
What is Ssrs encryption key? Reporting Services uses encryption keys to secure credentials and connection information that is stored in a report server database. Managing…
Why is execute permission for SP _ send _ dbmail not working? I receive this error The EXECUTE permission was denied on the object ‘sp_send_dbmail’,…
Which of the indexes would be best for fast look up for exact key matches but not so good for prefix lookups or sorting? Also,…
How to decode bytea column in PostgreSQL? But in the above case, the query returns a decode column of type bytea and I only see…