Friday, June 04, 2004

SQL Server & Other Database Releated References
-----------------------------------------------


All type of Connection String
-----------------------------
http://www.connectionstrings.com

SQL Server 2000 XML related queries and for SQLXML 3.0.
-------------------------------------------------------
http://www.extremeexperts.com/expertchat/default.aspx

SQL Server 2000 Articles
------------------------

i)Understanding SQL Server Triggers
---------------------------------
http://www.microsoft.com/india/msdn/articles/107.aspx

ii)Spell Checker in SQL Server
---------------------------
http://www.microsoft.com/india/msdn/articles/116.aspx

iii)Understanding UDF in SQL Server 2000
------------------------------------
http://www.extremeexperts.com/sql/articles/UDFFunctions.aspx

iv)Top 15 Undocumented Stored Procedures
-------------------------------------
http://www.microsoft.com/india/msdn/articles/118.aspx

v)Find when the last backup was taken
-----------------------------------
http://www.extremeexperts.com/sql/scripts/Lastbackup.aspx

vi)List all available DTS Packages using VB .NET
---------------------------------------------
http://www.extremeexperts.com/sql/faq/ListDTSPackagesVBNET.aspx

v)Extending DataGrid in ASP.NET
-----------------------------
http://www.extremeexperts.com/Net/Articles/ExtendingDataGrid.aspx

vi)Setting focus to an Textbox after Page Loads
--------------------------------------------
http://www.extremeexperts.com/Net/CodeSnippets/SettingFocustoElementAfterPostback.aspx

vii)Resource about Yukon (SQL Server Next Generation)
-------------------------------------------------
http://www.extremeexperts.com/SQL/Resources/default.aspx

viii)Simple Upload of Comma-Separated Values :
-----------------------------------------
http://www.extremeexperts.com/sql/articles/SimpleBulkInsert.aspx

ix)Locking Basics in SQL Server 2000:
----------------------------------
http://www.extremeexperts.com/sql/articles/LockingBasics.aspx

x)Knowing SQL Profiler trace template :
-------------------------------------
http://www.extremeexperts.com/sql/articles/TraceTemplate.aspx

Storing Image Data in SQL Server 2000
-------------------------------------
http://searchvb.techtarget.com/

SQL Server administration best practices
----------------------------------------
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

Server-Side Profiling in SQL Server 2000 :
------------------------------------------
http://www.microsoft.com/india/msdn/articles/102.aspx

Reading an XLS from SQL Server 2000 :
-------------------------------------
http://www.extremeexperts.com/sql/articles/ExcelLinkedServer.aspx

Transfer Data to XLS from SQL Server table :
--------------------------------------------
http://www.extremeexperts.com/sql/articles/TransferDataToExcel.aspx

Loop through T-SQL Result Set :
-------------------------------
http://www.extremeexperts.com/sql/articles/IterateTSQLResult.aspx

SQL Server Timeout Property
---------------------------
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlcommandclasscommandtimeouttopic.asp
http://p2p.wrox.com/topic.asp?TOPIC_ID=1327

Connection to SQL Server Database Using IP Address Is Unusually Slow
--------------------------------------------------------------------
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q300420

Function in check constraint (and in Default definition) - User Defined Functions (UDF) as CHECK Constraint
------------------------------------------------------------------------------------------------------------
http://www.sqlnet.cz/sql_server/tsql/udf_in_check.htm

ACC2002: "Configuring SQL Server 2000 Desktop Engine" White Paper Available in Download Center
----------------------------------------------------------------------------------------------
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q301413

HOW TO: Manage the SQL Server Desktop Engine (MSDE2000) by Using the Osql Utility
----------------------------------------------------------------------------------
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003

Internationalization [ I18N ] features in Microsoft SQL Server 2000
--------------------------------------------------------------------
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/IntlFeaturesInSQLServer2000.htm

Forming a comma Separated String in SQL Server 2000
---------------------------------------------------
http://www.microsoft.com/india/msdn/articles/47.aspx?

Arrays and Lists in SQL Server
------------------------------
http://www.algonet.se/~sommar/arrays-in-sql.html

0 Comments:

Post a Comment

<< Home