Useful tips for everyday
How to get date from year and month in sql? DECLARE @Year int = 900, @Month int = 1, @Day int = 1; SELECT CONVERT(date,CONVERT(varchar(50),(@Year*10000…
How do I read an encrypted view or a stored procedure? SQL Decryptor Next, right click on the encrypted stored-procedure and select ‘Show DDL script’…
Does identity column auto increment SQL Server? The MS SQL Server uses the IDENTITY keyword to perform an auto-increment feature. In the example above, the…
What are crud permissions? CRUD permission comes under object level Security which deals with Create,Read,Update,Delete. and it can be managed at Profile level. How do…
What does PostGIS do to the PostgreSQL database? About PostGIS. PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic…
What normalization solves? Basically, normalization is the process of efficiently organising data in a database. There are two main objectives of the normalization process: eliminate…
How can I time SQL-queries using PSQL? Timing can be turned on with timing at the psql prompt (as Caleb already said). If you are…
Is there always a huge redo queue in SQL Server? SQL SERVER – Always On Secondary Replica Huge Redo Queue – Version Store is Full.…
How to insert date in datetime column in SQL? FooDate is datetime variable which contains your date in your format. I encounter into a more…
How can you undo a committed transaction? You cannot roll back a transaction once it has commited. You will need to restore the data from…