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