Sql Server Articles (246) - Page 17

Articles posted by registered members of DotNetFunda.com. You can also post an article and win monthly prizes as well as gain community credit points.

246 records found.
Delete Duplicate rows from the table. 
Last updated on: 13 Oct 2008 01:58:14 PM by Deysomnath | Views: 12330 | Category: Sql Server |
Votes: 1 | Rating: 4 out of 5
Delete Duplicate rows from the table.
Debugging Stored Procedures in SQL Server 2005 
Last updated on: 12 Nov 2007 10:49:39 AM by Deeraj | Views: 185155 | Category: Sql Server |
Votes: 3 | Rating: 3.67 out of 5
Were you ever in need of debugging a stored procedure in SQL Server 2005. Any .NET Developer is well versed with debugging .NET applications. The .pdb files will be used internally to serve the purpose. Pdb files will have the mapping information from Native to MSIL and ultimately to the .NET code. I will not get into the internals of how this happens as this article falls under the SQL Server category.
Tracking Object (Table/Function/Stored Procedure etc.,) changes in SQL Server 2005 
Last updated on: 12 Nov 2007 10:50:45 AM by Deeraj | Views: 26912 | Category: Sql Server |
DBAs often need to track the changes being made to the database objects such as tables, user-defined functions and stored procedures etc.,. Our team size was 10 and a couple of members were responsible for each of the modules. My requirement was to track the changes made to the stored procedures right from its creation. My earlier articles explained on how source control can be made available for new/existing stored procedures. If you have missed those articles please catch them up at, http://dotnetfunda.com/articles.
Source control for existing stored procedures (Continued..) 
Last updated on: 18 Mar 2009 11:32:26 AM by Deeraj | Views: 11919 | Category: Sql Server |
In my previous article, http://www.dotnetfunda.com/articles/article20.aspx, I have demonstrated on how source control can be made available on stored procedures during the initial stages. Now, let us consider a scenario where source control was lacking for stored procedures for an online database which already was in production.
Source control for stored procedures in SQL Server 2005 
Last updated on: 12 Nov 2007 10:52:09 AM by Deeraj | Views: 17958 | Category: Sql Server |
.NET Developers working with Visual Studio 2005 IDE are well aware of the fact that source control for all the classes, pages, dlls can be integrated just by configuring source control in VS 2005 IDE.
Query foreign keys of all tables in a given database in SQL Server 2005 
Last updated on: 07 Nov 2007 06:05:45 AM by Deeraj | Views: 10446 | Category: Sql Server |
At times as a DBA/DB Programmer we may need to generate a report on foreign keys across all the tables in a given database. It would be a tedious job to use the SQL Server Management studio and build a relationship diagram. Here is a tip to quickly query the meta data and depict all the foreign keys.