Blog

Scalable Solutions by Nile Bits Take Care of The Business Needs of Today: GoodFirms

Nile Bits is a proponent in the software development field that has etched its name in the good books of GoodFirms. About the Company Nile Bits, founded in 2014, located in Canada and Egypt, offers the best and most effective software development, testing, and mobile app development solutions. The company offers full-cycle services that leverage professionalism and...

15 things you should do at an interview

Arrive on time or early but not too early.Dress formally, this would give you a self-confident.Be polite to everyone in the office.Act confident, but not overconfident.Give the appearance of energy as you walk.Do not forget to smile.Shake hands firmly and stand until offered a chair.Look to the interviewer in the eye while speaking.If the...

How to execute a T-SQL command to every table in SQL Server database

sp_MSforeachtable is a stored procedure that is mostly used to apply a T-SQL command to every table, iteratively, that exists in the current database. Examples on how to use it: 1-Perform an unconditional reindex over all tables in the database: EXEC sp_MSforeachtable 'DBCC DBREINDEX(''?'')' 2-Truncate all tables in the database: EXEC sp_MSforeachtable 'TRUNCATE TABLE ?' 3-Get the information about the...