Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins
I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...
2010-01-02
24,835 reads
Vivek's SQL Notes
Sql Server- Difference between Stored Procedure and Function
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to...
2009-12-22
2,176 reads
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,250 reads
Sql Server - How to write a Stored procedure in Sql server
Stored Procedure:-Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are...
2009-12-05
1,498 reads
Sql Server - Union and Union All
Union and Union All, both are used to select data from one or more than one tables but still they...
2009-11-17
4,485 reads
IDENTITY Property in SQL Server
IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...
2009-11-11
1,860 reads
Technology with Vivek Johari: How to make database offline or online
Technology with Vivek Johari: How to make database offline or online
2009-10-19
666 reads
Blogs
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
New article: Automating SQL Server Builds
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
Leading with Accountability: How Extreme Ownership Transforms Leadership
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Forums
What makes Monkey type's typing club apart from others?
Monkey type Typing Club is a unique typing practice website that offers several features...
Change Tracking Default Retention
Comments posted to this topic are about the item Change Tracking Default Retention
ssrs subscription file share
I am trying to create a subscription that posts to a one drive directory. ...
Question of the Day
Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers