Useful tips for everyday
What recovery model is supported by database mirroring? Mirroring is implemented on a per-database basis and works only with databases that use the full recovery…
What is the best way to paginate results in SQL Server? Pagination query in SQL Server DECLARE @PageNumber AS INT. DECLARE @RowsOfPage AS INT. SET…
Is there a word normalize? verb (used with object), nor·mal·ized, nor·mal·iz·ing. to cause (something previously considered abnormal or unacceptable) to be treated as normal:I have…
How much does MySQL cluster cost? MySQL Pricing Name Price MySQL Cluster Carrier Grade Edition $10,000 MySQL Enterprise Edition $5,000 MySQL Standard Edition $2,000 Which…
How do I view the header of a SQL table? SQL to list the headers in a table? SELECT st. name AS TableName. , sc.…
Can I use case in where clause Oracle? You can use a CASE expression in any statement or clause that accepts a valid expression. For…
How to Shard data in PostgreSQL Version 10? Version 10 of PostgreSQL added the declarative table partitioning feature. In version 11 (currently in beta), you…
How do I enable IntelliSense in SQL Server Management Studio 2016? Open SSMS, click Tools -> Options -> Expand Text Editor -> Expand Transact-SQL and…
How do you create a relational database in star schema? Let’s walk through this process step by step. Step 1: Install Diagram Support. Step 2:…
How do I enable Filestream on an existing database? Right-click the instance, and then click Properties. In the SQL Server Properties dialog box, click the…