While working on the query editor, I often find myself requiring to switch over to the Object Explorer window. In such cases, I use a little known, underappreciated feature hidden within the pop-up menu of the query explorer. Today, I share this SSMS pr...

@@ROWCOUNT returns the number of affected rows by last statement. Below example illustrate the same CREATE TABLE #t (id int) INSERT INTO #t(id) values(1) DELETE #t SELECT @@ROWCOUNT Here we will get @@ROWCOUNT AS 1 But same did ...

@@ROWCOUNT returns the number of affected rows by last statement. Below example illustrate the same CREATE TABLE #t (id int) INSERT INTO #t(id) values(1) DELETE #t SELECT @@ROWCOUNT Here we will get @@ROWCOUNT AS 1 But same did ...

@@ROWCOUNT returns the number of affected rows by last statement. Below example illustrate the same CREATE TABLE #t (id int) INSERT INTO #t(id) values(1) DELETE #t SELECT @@ROWCOUNT Here we will get @@ROWCOUNT AS 1 But same did ...

@@ROWCOUNT returns the number of affected rows by last statement. Below example illustrate the same CREATE TABLE #t (id int) INSERT INTO #t(id) values(1) DELETE #t SELECT @@ROWCOUNT Here we will get @@ROWCOUNT AS 1 But same did ...

Hi All, One more Extended SP is there for version. xp_msver will give all details....

Hi All, One more Extended SP is there for version. xp_msver will give all details....

How do you know when your index was last rebuilt or reogranized? How many records changed during this rebuild/reorganization operation? Read this post for answers to all these questions....

How do you know when your index was last rebuilt or reogranized? How many records changed during this rebuild/reorganization operation? Read this post for answers to all these questions....

Changing database options to make it read-only, or taking a database offline? If you are using sp_dboption, your code will not work with SQL Server 2012. Use ALTER DATABASE...SET statement instead....