I posted some useful scripts to count your database’s Tables, Views and Stored Procedures. Count Tables [sourcecode language=’sql’] SELECT COUNT(*)
Continue readingCount Tables, Views and Stored Procedures in you Database
Something more relaxing after this scrary number on previous post
This procedure has saved me more than once, so I need to document it throughly for everyone! There are cases
Continue readingTrace freed/deallocated instances of objects
Sounds impressive eeeh? This is a real deal check it for yourself. How to make a godmode shortcut on your
After some research i found a very simple solution Try following steps 1. change mode from FULL to Simple. 2.
Tips and tricks in SQL Server perfomance…. (read more)
Problem Adding constraints such as check constraints or foreign keys to a table are best practices to keep your data
This is a SQL Script that Cleans your Database Records & resets Identity Columns, and it is all in 6
Continue readingSQL Server, Empty your Database & Reset Identity Columns **made Simple
1. Save as excel document in CSV format. (found as CSV Comma Delimited file) 2. Connect to Mysql through command