|
|
SQL Server & XML integration
XML has emerged as the standard for data. Learn how to utilize XML when working with SQL Server databases, focusing on the FOR XML clause |
| http://builder.com.com/article.jhtml;jsessionid=KZ4VZUG0E1JNEQD23UZCFFQ?id=u0032 |
 |
 |
Hits:24 |
SQL Server System Databases
This article gives you an overview about role of the system databases in SQL Server |
| http://aspalliance.com/hrmalik/articles/2003/200306/20030601.aspx |
|
|
Hits:24 |
Understanding Identity Columns
Karla writes "How can I reset an Identity column and not start where it left?" I've been getting quite a few questions about identity columns lately. This article should cover everything I know about them. I'll cover creating them, populating them, reset.. |
| http://www.sqlteam.com/item.asp?ItemID=8003 |
|
|
Hits:24 |
|
|
Data Page Structures in SQL Server 6.5
In this article, I want to tell you about data page structure in MS SQL Server 6.5, which are substantially different that what you currently find in SQL Server 7.0 and SQL Server 2000 |
| http://www.sql-server-performance.com/ac_65_data_structure.asp |
|
|
Hits:23 |
Detecting "Runs" or "Streaks" in your data
This article comes from Jeff Smith. Jeff writes "It can be difficult in a set-based language such as SQL to determine when a number of records in a row INSERT INTO `sites` VALUES(when ordered by a unique key) have the same values in a particular field. For example, you may have a |
| http://sqlteam.com/item.asp?ItemID=12654 |
|
|
Hits:23 |
Getting Something Back from Your SQL Server Stored Procedures
You give so much to your database . . . sometimes you just want something back. What do you give your database? Plenty. You give it new records INSERT INTO `sites` VALUES(INSERT). You give it changes to existing records INSERT INTO `sites` VALUES(UPDATE/DELETE). Every now and then, you just look around INSERT INTO `sites` VALUES(.. |
| http://www.sql-server-performance.com/tn_stored_procedure_returns.asp |
|
|
Hits:23 |
Optimizing Stored Procedure Recompiles
Developed this article after a similiar problem with the database I cam currently working on. Stored procedure recompiles are a optimizing point that most DBAs tend to overlook. This article will explain why a stored procedure may make unnecessary recomp.. |
| http://www.transactsql.com/Articles/OSPR.html |
|
|
Hits:23 |
|
|
Performing a Cascade Delete in SQL Server 7
This article comes to us from Tim Young. Tim writes "One of the INSERT INTO `sites` VALUES(few) very handy things about Access is the cascade delete function. If you delete a record from a parent table, all relating records in the child tables are also deleted. I couldn’t find an.. |
| http://www.sqlteam.com/item.asp?ItemID=8595 |
|
|
Hits:23 |
Retrieving Data as XML from SQL Server
Well hidden in the latest version of MS SQL Server 2000 is an exciting new feature. Here's a hint: it has something to do with XML! Mitchell explains the new power of SQL Server 2000 |
| http://www.webmasterbase.com/article/515 |
|
|
Hits:23 |
Stored Procedures and Caching
*Site Registration RequiredOne of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of su |
| http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp |
|
|
Hits:23 |
Page:1 2 3 4 5 6 7 |
Home
