Epoch to SQL Date Time
What would you do if as a DBA someone asks you that Hey, i need to know how many stored procedures are their in this database? 1 . you are gonna count all of them? of course not. 2. use your dba magic and save the time. So i was asked today we need to […]Read more "Stored Procedures in a database"
Merge join is a strategy which sql servers takes up when condition on which the table is joined is a column which is ordered ; this happens when lets say that two table T1, T2 have columns T1C and T2C T1C and T2C are the columns on which the tables are joined these both columns […]Read more "Merge Join"
So this comes in to your mind that the joins in sql are Inner join, left join , right join , cross join well the thing is that sql server does not know that, for sql server its just syntax which is decoded and sql server works on it in the following three plans. Merge […]Read more "Joins Of SQL Server"
Three types of back up : Full Differential Transnational Full As the name suggests, Full Copy involves taking back up of all the database this also includes log files, this enables to restore database to the state where the backup was taken Differential This involves taking the copy of the latest changed data, a Differential […]Read more "Back up Types"
Today i was working with some traces since i am a noob DBA there was this function fn_trace_gettable which had a default parameter, i noticed this weird “::” (double colons) syntax. Why were there two colons after From and before the function, i never encountered this and i have been working with SQL for the […]Read more "System defined function call in legacy system"
If you are here you already know about In Clause and Like in SQL, let me just give you a brief over view about it Like is a wild card when used would search up any row which has your condition (For better understanding Please look it up) IN Clause when used with […]Read more "Like operator with IN Clause SQL"
Normalization is one of the most important and basic database principle , why is it that important? So if you are a sql developer and you come across a table in which there are comma separated values and those are to be used to join another table ; what would you do? Parse it one […]Read more "Why Normalize Data?"