Useful tips for everyday
What is full text index in Hana? Full Text Index is created to enable text search features on specific column in a table. Conceptually, for…
Where do I find permissions on a schema? In SSMS, if you follow the path [Database] > Security > Schemas and view any schema properties,…
How do I use PG restore? Restore the backup. Open command line window. Go to Postgres bin folder. For example: cd “C:\ProgramFiles\PostgreSQL\9.5\bin” Enter the command…
Where can I find replication logs? Expand Application and Services Logs Click in DFS Replication to find all the logs related with DFSR. What is…
What is affinity masking? An affinity mask is a bit mask indicating what processor(s) a thread or process should be run on by the scheduler…
What is use of extended events in SQL Server? Extended events is a lightweight performance monitoring system that enables users to collect data needed to…
When to use multiple columns in an index? If you have queries that will be frequently using a relatively static set of columns, creating a…
What is the purpose of one to one relationship? One-to-one relationships are frequently used to indicate critical relationships so you can get the data you…
When should I use nvarchar in SQL Server? The real reason you want to use NVARCHAR is when you have different languages in the same…
How to connect to SQL servers in another domain? Since I work from home, I face this challenge all the time – almost every SQL…