Answer to the Quiz
Hi Everybody, Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course ! Here’s the...
top of page
Madeira Team
- Aug 20, 2011
- 2 min
Win a Ticket to the “Advanced Programming” Course
We are opening another class of the “Advanced Programming in SQL Server” course on 28/08. You can find all the details here. Here is an...
Madeira Team
- Jul 19, 2011
- 1 min
Redundant Indexes
This query returns redundant indexes. An index is considered redundant if there is at least one other index for the same table or view...
Madeira Team
- May 23, 2011
- 1 min
Copy Login
Sometimes you need to create a new login from an existing login. For example, recently I helped one of my customers to move all the...
Madeira Team
- Apr 4, 2011
- 3 min
Efficiently UPDATE and DELETE using TOP and ORDER BY
Since SQL Server 2005, Microsoft added the nice addition to the common DML statements UPDATE and DELETE by allowing the use of the TOP...
Madeira Team
- Feb 2, 2011
- 3 min
Remove the IDENTITY property from an existing column
How to remove the IDENTITY property from an existing column using T-SQL (without changing the order of the columns or moving the data...
bottom of page