Considering how integrated Microsoft tools usually are the result is frustrating when you tell to open SQL files using Sql Server Management Studio Open a solution which contains SQL files Right-click any SQL file and select “Open With…” Click “Add »
Ever have to work on a database with a large number of views and you needed to search the content of the objects? Well, here’s a query which will allow you to search inside your view objects: DECLARE @search VARCHAR(1000) SET @search = '[text]' SELECT »
Well after a long absence due to a crazy workload, I’m baaaack! Keepin’ it simple at this point. I’ve resumed studying for MCTS exams and I’ve been reading about dynamic management views. I love them. What’s more, I love the detail they provide and the »