Netvouz / conradina / folder / sql http://netvouz.com/conradina/folder/7796593901756415368/sql?feed=rss conradina's bookmarks in folder sql on Netvouz SQL Server Forums at SQLTeam.com http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57391 Select Query to group records by 5 minutes sql conradina Fri, 18 Nov 2005 16:49:26 GMT 4GuysFromRolla.com - Writing a Stored Procedure http://www.4guysfromrolla.com/webtech/111499-1.shtml This article, by <A HREF='mailto:npond@bgnet.bgsu.edu'>Nathan Pond</A>, describes how to write stored procedures using SQL Server. Using stored procedures have a number of benefits, from performance gains in the data queries to providing a layer of encapsulation between your database and ASP pages. sql conradina Mon, 12 Feb 2007 14:51:41 GMT Download details http://www.microsoft.com/downloads/details.aspx?FamilyID=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en SQL Server 2000 Driver for JDBC SP3 sql conradina Thu, 12 May 2005 19:32:14 GMT Dynamic Management Views - SQL Server Information at SQLTeam.com 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 Exploit the power of T-SQL for generating scripts (for repetitive tasks): Narayana Vyas Kondreddi's homepage 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 InfoWorld http://www.infoworld.com/LiteSpeed_for_SQL_Server,_Version_3.1/product_46604.html?view=1&curNodeId=0 Product Guide: LiteSpeed for SQL Server, Version 3.1 : Review sql conradina Sat, 14 May 2005 19:11:04 GMT List DBCC Commands in SQL Server 2000 http://www.extremeexperts.com/sql/articles/ListDBCCCommands.aspx ExtremeExperts sql conradina Thu, 19 Apr 2007 13:12:57 GMT Mabsterama : An SQL Tip - WHERE EXISTS 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 My code library (SQL Server T-SQL code samples, snippets, examples, tips, tricks, stored procedures, user defined functions,... http://vyaskn.tripod.com/code.htm Welcome to the SQL Server website of Narayana Vyas Kondreddi. This site features a unique, one of a kind SQL Server replication FAQ, SQL Server T-SQL code samples, DBA and Database developer interview questions, Database object naming conventions, Database programming guidelines, Interesting articles and much more! sql conradina Wed, 14 Feb 2007 02:13:04 GMT My Issues With SSIS Event Handlers (And Why I'll Use Them Anyway) http://www.developerdotstar.com/community/node/334 developer.* Blogs sql conradina Tue, 24 Apr 2007 20:07:30 GMT