Change Data Capture (CDC)–An easy way to track data changes of a database–TIP #79

 
In last TIP #78  we have discussed Change tracker (CT) which was introduced in SQL SERVER 2008. CT feature only...

T-SQL – How to Find Number of Words in a Given String

TSQL: To find number of words in a given string
Download the codehttps://gallery.technet.microsoft.com/T-SQL-How-to-Find-Number-533b6b39
DECLARE @DemoTable Table
(Col varchar(500));

INSERT INTO @DemoTable (Col)VALUES ('JOHN...

Capturing Database(s) and Table Usage stats – sp_spaceused simulation using DMVs

For more Information refer Technet Article

Introduction
sp_spaceused is one of the system stored procedure used frequently by many DBA’s that reveals amount...

Happy Holidays

Quick and simple for today.  Happy Holidays to you!  
Related Posts:

Easy Permissions Audit January 21, 2019

T-SQL Tuesday Participation Over the Years December 19, 2018

Quick Permissions Audit January...

Happy Holidays

Quick and simple for today.  Happy Holidays to you!

Related Posts:
Always Waiting, Waiting WaitingFinally, it has happened…On the Seventh Day…September 2014...

Reblog: December 19 to December 25

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

Friday Followup For December 26, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

T-SQL COALESCE Example

T-SQL COALESCE
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your...

Cumulative Update – 5 for SQL Server 2014 RTM Is Now Available !

The 5th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since...

Cumulative Update – 5 for SQL Server 2014 RTM Is Now Available !

The 5th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site....