Bistuffwithdigven.com Website Review

I have started Microsoft MDS (Master Data Services) as a new category to share some really quick and helpful solution of problems faced while working. Let me know if you have Questions in comments section. To delete partial (good number of rows) or full Entity data with MDS database, Manual UI usage is slow and really bad if numbers of rows are good enough. DECLARE @DateTimestamp nvarchar(100) = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(19),GETDATE(),120),' Recently I have been asked to merge a new datasource in my current SQL Server solution for client. For example I had data from US in enterprise data warehouse solution, now clients wants to add UK data in same dimension and facts tables. Now UK database could be in a complete different structure and I will be looking each column to find if Dimension Tax Type data and then do Searching a small text in a whole database could be for multiple reasons: So following is the code for same. Use it, utilise it, enhance it, extract whatever good you can from it. Let me know if you want clarity on any section. I have given good detailed comments for understanding, still comments section is open for any query and feedback. INPUTS ARE ONLY NEEDED IN SECTION 1 (and Section 4 but only if ---You can be more creating and filter tables or columns based on name (first two commented lines) ---You can filter columns by columns data types to make sure least count of columns are actually checked In case of big database we can pick few alphabets to check the data. ---This whole section is for filtering least column (or keep all) from overall column list in database which in turns help in quick search Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.