|
|
 |
How to drop all temp tables created by current connection.
|
| Total Hit (7327) |
Few days ago I came up with one problem. I was tesing a script in query analyzer. This script was using several temp tables so every time I run this script I had to make sure that all temp tables are dropped before I run the script otherwise it will give bunch of errors. So I decided to write a proc
....Read More |
Rating
 |
|
|
|
How to display COM error description in SQL Stored procedure ?
|
| Total Hit (3390) |
When we deal with COM object using sp_OAxxxx stored procedure sometimes you need exact error description to Identify the problem. Here is the solution for this type of problem. sp_displayoaerrorinfo stored procedure will display any error encountered while executing sp_OAxxxx stored procedure.
....Read More |
Rating
 |
|
|
|
How to export table or Query output to a file using BCP
|
| Total Hit (2809) |
To export Query result to a file use following command to your command prompt
«code LangId=6»EXEC master..xp_cmdshell
'bcp "select * from pubs..authors" queryout c:\authors.txt -c -Usa -Pmypassword'«/code»
To export table to a file use following command to your command prompt
«code LangId
....Read More |
| Rating
|
|
|
|
|
|
|
|
Working with Computed column in SQL Server 2000
|
| Total Hit (1539) |
There are restriction for ALTER COLUMN, documented in Books Online (see end
of this post). Depending on your particular situation, you need to DROP
INDEX, ALTER TABLE... DROP CONSTRAINT etc.
The altered column cannot be:
a) A column with a text, image, ntext, or timestamp data type.
....Read More |
| Rating
|
|
|
|
|
|
|
|
Tricky order by without writing dynamic T-SQL
|
| Total Hit (2472) |
This example shows you how to write dynamic order by statement without writing Dynamic T-SQL which is required to re-compile the execution plan every time you run it.
|
| Rating
|
|
|
|
How to install MSDE
|
| Total Hit (4033) |
To install MSDE first extract files to a folder e.g. c:\sql2ksp3 then run folloing command on command prompt
c:\>cd sql2ksp3
You can specify installation option either in command line itself or specify in setup.ini
«b»[1] Specifying parameters in command line«/b»
For example the following
....Read More |
| Rating
|
|
|
|
|
|
ADO like Cursor operations using T-SQL
|
| Total Hit (1763) |
This article shows how to use SQL cursor to perform MoveFirst, MoveLast, MoveNext, MovePrev and MoveAbsolute operations using T-SQL's SCROLL CURSOR
|
| Rating
|
|
|
|
|
|
|
|
Managed UDTs Let You Extend the SQL Server Type System
|
| Total Hit (1006) |
The next version of SQL Server, code-named "Yukon," will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UDTs you can more precise
....Read More |
| Rating
|
|
|
|
XML, T-SQL, and the CLR Create a New World of Database Programming
|
| Total Hit (972) |
The next version of SQL Server, code-named "Yukon," includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined functions, stored
....Read More |
| Rating
|
|
|
|
New Version Showcases Native XML Type and Advanced Data Handling
|
| Total Hit (1166) |
The next version of Microsoft SQL Server, code-named "Yukon," represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging industry standard XQ
....Read More |
| Rating
|
|
|
|
Microsoft TerraServer
|
| Total Hit (743) |
The Microsoft® TerraServer stores aerial and satellite images of the earth in a Microsoft SQL Server™ database served to the public through the Internet. It is the world's largest atlas, combining five terabytes of image data from the United States Geodetic Survey, SOVINFORMSPUTNIK, and Encarta®
....Read More |
| Rating
|
|
|
|
XML for Analysis (XMLA) Specification
|
| Total Hit (968) |
Specifies a SOAP-based XML communication API that supports the exchange of analytical data between clients and servers on any platform and with any language.
|
| Rating
|
|
|
|
XML for Analysis (XMLA) SDK Download
|
| Total Hit (1044) |
The Microsoft XML for Analysis SDK contains the Microsoft® XML for Analysis provider and sample client applications. The Microsoft® XML for Analysis Provider supports data access to analytical data sources (OLAP and data mining) residing on the Web. This provider implements the XML for Analysis Spec
....Read More |
| Rating
|
|
|
|
|
|
Random Sampling in T-SQL
|
| Total Hit (783) |
Imagine a company with a data warehouse that contains tens of millions of records on individuals. The analysts want to use it to do statistical analysis or data mining. Because it can be time-consuming to work with such a large number of records, analysts often select a small, random subset of recor
....Read More |
| Rating
|
|
|
|
Brief Tutorial on Text, Ntext, and Image
|
| Total Hit (1126) |
Databases are growing in size and complexity, in part because today's hardware and software allow us to store mind-boggling amounts of data—including multimedia and document data. JPG, PNG, MP3, DOC/RTF, HTML, Unicode, and XML data can all be stored as image, text, or ntext in SQL Server databases.
....Read More |
| Rating
|
|
|
|
Data Extraction, Transformation, and Loading Techniques
|
| Total Hit (2288) |
Chapter 17, "Data Warehouse Design Considerations," discussed the use of dimensional modeling to design databases for data warehousing. In contrast to the complex, highly normalized, entity-relationship schemas of online transaction processing (OLTP) databases, data warehouse schemas are simple and
....Read More |
| Rating
|
|
|
|
Business Case Solutions Using MDX
|
| Total Hit (865) |
The purpose of the Multidimensional Expressions (MDX) language is to make access to multidimensional data more concise and efficient. However, because MDX reflects the natural complexity of multidimensional data structures, simple business questions may sometimes require complex MDX solutions.
....Read More |
| Rating
|
|
|
|
Log Shipping
|
| Total Hit (700) |
It is 2 PM on a record business day. The Microsoft® SQL Server™ 2000 server housing your mission-critical customer database experiences a disk failure. What do you do? When was the last known good backup? Is there another server available to restore the backup onto? Is SQL Server even on that server
....Read More |
| Rating
|
|
|
|
Failover Clustering
|
| Total Hit (745) |
Continuous uptime in a production environment, whether it is a database powering a mission-critical client/server application or an e-commerce Web site, is becoming a common businesses requirement. This chapter describes Microsoft® SQL Server™ 2000 failover clustering, one method of creating high av
....Read More |
| Rating
|
|
|
|
Replication and Microsoft SQL Server 2000
|
| Total Hit (1925) |
Data Replication is a powerful feature of SQL Server. SQL Server 7.0 provided many improvements from previous versions, and SQL Server 2000 builds on those features and adds more to increase the reliability, ease of use, and management of replication.
....Read More |
| Rating
|
|
|
|
Dynamic order by
|
| Total Hit (902) |
You can use CASE statement in order by clause to select field by which you want to order the resultset. This is very handy technique.
|
| Rating
|
|