http://netvouz.com/tag/sql?feed=rss&pg=7 Bookmarks tagged with "sql" on Netvouz http://vyaskn.tripod.com/generate_scripts_repetitive_sql_tasks.htm Welcome to the website of Narayana Vyas Kondreddi. This is a personal website, with some technical stuff which you will find useful. This site features some great SQL Server, Visual Basic, ASP resources. You will also find an FAQ section on SQL Server replication. You will also find a list of handy shortcut keys of some Microsoft products. Additional sections include: A code library which features VB programs, stored procedures; A page dedicated to SQL Server related books; sql conradina Fri, 04 May 2007 13:44:01 GMT http://www.sqlteam.com/item.asp?ItemID=23040 The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what's going on inside SQL Server. They can provide information on what's currently happening inside the server as well as the objects it's storing. They are designed to be used instead of system tables and the various functions provided in SQL Server 2000. This article provides an introduction to DMVs and covers a few of the basic views and functions. sql conradina Wed, 02 May 2007 16:27:22 GMT http://www.developerdotstar.com/community/node/334 developer.* Blogs sql conradina Tue, 24 Apr 2007 20:07:30 GMT http://www.databasejournal.com/features/mssql/article.php/3518431 Among features introduced in the SQL Server 2005 Integration Services are the For and ForEach loops, implemented in the form of containers that can be incorporated into the Control Flow part of a package design. Join Marcin Policht to learn about the For and ForEach loops. sql conradina Tue, 24 Apr 2007 19:15:01 GMT http://www.techonthenet.com/sql/tables/alter_table.php The ALTER TABLE command allows you to add, modify, or drop a column from an existing table. sql conradina Tue, 24 Apr 2007 15:07:23 GMT http://www.madprops.org/cs/blogs/mabster/archive/2006/07/24/An-SQL-Tip-_2D00_-WHERE-EXISTS.aspx I don't even know where I picked this little tip up from. I think I read an example query on someone's blog recently. Every SQL developer at some point has had to write a query that includes the "WHERE EXISTS" clause. You're looking sql conradina Mon, 23 Apr 2007 17:48:56 GMT http://taposh.wordpress.com/2007/03/05/sql-server-2000-keyboard-hotkeys/ sql conradina Mon, 23 Apr 2007 17:21:26 GMT http://www.sqlservercentral.com/columnists/rVasant/queryingsystemtables.asp Free Microsoft SQL Server articles, news, forums, scripts and FAQs. sql conradina Sat, 21 Apr 2007 19:49:51 GMT http://www.sql-server-performance.com/ac_undocumented_2000_system_tables.asp Learn about the SQL Server 2000 undocumented system tables sql conradina Sat, 21 Apr 2007 19:49:34 GMT http://www.mssqlcity.com/Articles/Undoc/SQL70UndocTbl.htm Article about SQL Server 7.0 undocumented system tables. MSSQLCity.Com - all about MS SQL (SQL Server Articles, FAQ, Scripts, Tips and Test Exams). sql conradina Sat, 21 Apr 2007 19:48:02 GMT