|
|
|
|
 |
How to find tablesize and estimated rows for all tables
|
| Total Hit (2711) |
Since there is no easy way using Enterprise Manager to know size and rows for all tables you need to write your own query. Run the following Query to see the result
«code LangId=6»USE Northwind
Go
SELECT a.Name
, SUM(b.RowCnt) EstRowCount
, SUM(b.Used) * 8 TableSize_KB
, (SU
....Read More |
Rating
 |
|
|
|
Building SSIS Packages Programmatically (Part 1 to Part 9)
|
| Total Hit (4588) |
This tutorial series will show you how to use SSIS Object Model to buil packages programatically in C# (or VB.net)
<a target=_blank href='http://www.ssisbi.com/2009/01/14/building-ssis-packages-programmatically-part-1/'>http://www.ssisbi.com/2009/01/14/building-ssis-packages-programmatically-part
....Read More |
| Rating
|
|
|
|
|
|
|
|
SAVE TRAN and Save Points.
|
| Total Hit (2534) |
Savepoints offer a mechanism to roll back portions of transactions. A user can set a savepoint, or marker, within a transaction. The savepoint defines a location to which a transaction can return if part of the transaction is conditionally canceled. SQL Server allows you to use savepoints via the SA
....Read More |
Rating
 |
|
|
|
|
|
Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands
|
| Total Hit (2895) |
In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 7.0 and 2000 for administering and monitoring.
DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logica
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
Displaying RTF formatted text in SQL 2005 Reporting services
|
| Total Hit (43993) |
I haven't tried this but it may be helpful to someone who is trying to display RTF formatted text on their report. Crystal Report Support RTF/HTML format but RS 2005 doesnt support. May be MS will add in the next release.
Just follow these steps:
Compile the code below it into a class
Firs
....Read More |
Rating
 |
|
|
|
|
|
Choosing SQL Server 2000 Data Types
|
| Total Hit (998) |
Choosing an appropriate data type is very important, because the errors made in a table design can result in large performance degradation. These problems often surface later, when a large amount of data is inserted. In this article, I want to tell you about built-in and user-defined data types, how
....Read More |
| Rating
|
|
|
|
MDX Sets
|
| Total Hit (1390) |
In this chapter, you’ll learn MDX query terminology and how to
«LI»Use the MDX Sample application to enter queries.
«LI»Use set functions.
«LI»Create sets by using member constants.
«LI»Create calculated members that aggregate sets of values.
....Read More |
| Rating
|
|
|
|
Importing and Exporting Data with SQL Server
|
| Total Hit (1274) |
Transferring data, whether into or out of a database, can be a complex process. SQL Server provides several tools that help you in a variety of situations, including the Bulk Copy Program, the Select statement, the Transfer Manager, and Query results. This chapter examines those options, and times w
....Read More |
| Rating
|
|
|
|
Attaching and Detaching Databases on SQL Server
|
| Total Hit (929) |
If you need to move a database, or database file to another server or disk, and you do not want to backup the database, copy the backup on another server, and then re-create the database from the backup, you can use the sp_detach_db and sp_attach_db system stored procedures to detach the database an
....Read More |
| Rating
|
|
|
|
Using DTS to Detect and Process a File
|
| Total Hit (1074) |
There is nothing better than when a new technology lends itself to solving an old problem; well, there may be some things better, but this will have to do for now. One of the classic problems in computing -- classic being defined as a problem I have seen before -- is processing files that were uploa
....Read More |
| Rating
|
|
|
|
|
|
Textual Searches on File Data
|
| Total Hit (1912) |
This chapter introduces the types of textual searches supported by SQL Server and illustrates the roles performed by both the IIS and Index Services technologies. It also introduces SQL Server distributed queries and describes their use in the processing of textual searches. It then addresses the qu
....Read More |
| Rating
|
|
|
|
Backup Table Data in SQL Server 7.0 and 2000
|
| Total Hit (1985) |
With SQL Server 6.5, Microsoft gave us an opportunity to do a backup (DUMP Table) of the tables. However, after 6.5, with both 7.0 and 2000, that feature has been removed for some reason. Here is a stored procedure that I wrote which gives similar functionality for backing up table data. This is ver
....Read More |
| Rating
|
|
|
|
|
|
|
|
SQL Server 2000 DTS Part 9 - DTS Designer Tasks
|
| Total Hit (1906) |
The last installment of this series discussed the basic principles and applications of the Transform Data task. This article continues, focusing on its more advanced features.
|
| Rating
|
|
|
|
Dealing with MS SQL Tables that contain Duplicate Rows
|
| Total Hit (705) |
Every so often, you might have to deal with tables that contain duplicate rows. In one case, you might only need to identify the duplicate rows. In other cases, you might need to remove the duplicate rows. This article will show you some different techniques for dealing with duplicate rows.
....Read More |
| Rating
|
|
|
|
|
|
|
|
Deleting an Excel WorkSheet from within a package
|
| Total Hit (1896) |
Here is a simple and quick way of deleting a worksheet in an Excel spreadsheet. It uses two global variables, one for the Excel file name and one for the sheet to delete. As this uses OLE automation of the Excel application object, you will need Excel installed on any machine that this package execu
....Read More |
| Rating
|
|
|
|
Dynamic order by
|
| Total Hit (903) |
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
|
|