1 minSQL Adv - Obtain prior or next row dataI am a fan of using ranking system to pull prior data, but if you are curious if there's another way to pull data without having to rank,...
1 minSSMS Adv - Find a stored procedureHere is a simple code to find a stored procedure. You will need to update the 'DatabaseName' with which DB you would like to search from...
2 minSSMS - Slow database...When a database is running slow, the first diagnostic step I do is try to determine if there is anything that is slowing it down by using...
2 minSSMS Adv - Search for multiple columns that exists in one tableBelow is a simple solution as to how you can find tables from a database that have two (or more) specific columns. I have divided 3...
2 minSSMS Adv - Find a column from multiple databaseBelow is a simple solution as to how you can find certain column from multiple database. This code is simply looking thru each database...