|
|
 |
Stored procedure to set/reset columns's identity property
|
| Total Hit (3391) |
You can use ALTER TABLE statement to add/remove column and to change some attributes of a column but there are some limitations with ALTER TABLE statement. You can not use ALTER TABLE to set a column as an identity column (Auto Increment field). You can ADD a new column with IDENTITY property but ca
....Read More |
Rating
 |
|
|
|
|
|
UDF : ParseArray - return table from CSV
|
| Total Hit (3509) |
Sometimes we may need to store values in one field using some sort of seperating character. For example if you want to store multiple values in one field instead of normalizing your table and creating a whole new table to store multiple records. This articles will show you how you can create a UDF w
....Read More |
Rating
 |
|
|
|
|
|
How to pass array to stored procedure in SQL Server
|
| Total Hit (4015) |
Have you ever come across the situaction when you have to pass mutiple values as parameter to your stored procedure.
Assume the following scenario.
- Your application pass comma seperated CustomerID list to stored procedure to get Orders for related customers.
Above requirement can be don
....Read More |
| Rating
|
|
|
|
Statistic functions that take Null values into account
|
| Total Hit (2836) |
Statistic functions - that is MAX, MIN, SUM, AVG, VAR, VARP, STDEV and STDEVP - don't take Null values into account. Usually this isn't a problem with the SUM function, but it can be an issue with the others. For example, you can evaluate the average value of a group of records keeping Null values i
....Read More |
| Rating
|
|
|
|
Programmatically start and stop SQL Server main service
|
| Total Hit (3154) |
Using the SQL-DMO object model you can programmatically start, stop, pause, and continue the main SQL Server service. In the following code snippet the server is "MyServer", and "sa" / "mypwd" is the user name and password of a user that is allowed to start/stop the service:
«Code LangId=6»
' N
....Read More |
| Rating
|
|
|
|
Useful undocumented extended stored procedures
|
| Total Hit (3140) |
An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can run extended stored procedures from the Query Analyzer, for example, just as you would normal stored procedures. Ex
....Read More |
| Rating
|
|
|
|
Moving Average Example #1.
|
| Total Hit (2301) |
This example shows how to solve the Moving Average problem using a correlated query.
|
| Rating
|
|
|
|
Complex Updates Using the Case Statement
|
| Total Hit (1699) |
«B»Introduction«/B»
One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
«B»Multiple updates to a single column«/B»
....Read More |
| Rating
|
|
|
|
Enumerate all the indexes in a SQL Server database
|
| Total Hit (4003) |
The indexing schema plays a fundamental role in performance tuning, and tools such as the Index Tuning Wizard that can suggest efficient schemas on the grounds of a database usage. Once the indexing schema has been completed, you should document it in order to know which tables have primary keys, wh
....Read More |
| Rating
|
|
|
|
|
|
|
|
Monitoring Disk Space and Sending Alerts with TSQL
|
| Total Hit (5706) |
Monitoring disk space is one important task for SQL Server DBAs. To proactively monitor disk space, we want to be notified when disk space is below certain level. We also want to collect database file size information over time for trend analysis, for which Gregory Larsen has an excellent article "A
....Read More |
| Rating
|
|
|
|
Tutorial : Problems With IDENTITY() and the DataPump task.
|
| Total Hit (722) |
Just recently we have seen a number of posts in the newsgroups concerning problems with IDENTITY columns when inserting data into a table using DTS. This walkthrough should hopefully explain most of the problems we can encounter and give you some useful information about behind the scenes stuff as w
....Read More |
| Rating
|
|
|
|
Report-enable Your Web Apps with Microsoft Reporting Services
|
| Total Hit (1129) |
Reporting is an integral part of almost all of today's Web applications. However, while the tools to create such applications have matured, Web reporting often boils down to generating tabular reports in the form of HTML tables. Microsoft SQL Server 2000 Reporting Services fills in this gap and give
....Read More |
| Rating
|
|
|
|
How to Install Windows 2000 Cluster Services
|
| Total Hit (546) |
SQL Server clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL Server 7.0 or SQL Server 2000, and time. Lots of it. The purpose of this article is to get you started along your way to SQL Server clustering. As a precursor to this step, you must first install and configu
....Read More |
| Rating
|
|
|
|
SQL Server Notification Services Architecture
|
| Total Hit (959) |
Like most services or applications, Microsoft SQL Server Notification Services is not really one monolithic application. It should be thought of as a series of smaller components that, when girded together in a precise manner, work in concert to produce a notification application. A good understandi
....Read More |
| Rating
|
|
|
|
Backup--Transfer--FTP!
|
| Total Hit (2023) |
Having a standby server in a remote site, copying backup files directly to a Disaster recovery site or other requirements such as transfering files from one location to another using FTP creates the need for creating a FTP batch file using a changing parameter file. In this article, I will walk you
....Read More |
| Rating
|
|
|
|
|
|
|
|
Understanding BCP/BULK COPY Format Files
|
| Total Hit (1144) |
In Microsoft SQL Server 2000 and earlier, bulk exporting and importing works with a single type of format file. This is supported in Microsoft SQL Server 2005. SQL Server 2005 also supports XML format files as an alternative. To distinguish format files of the original type, they are called non-XML
....Read More |
| Rating
|
|
|
|
|
|
Reporting Options for Analysis Services Cubes: Cognos PowerPlay
|
| Total Hit (3301) |
This is the twelfth article of the series, Introduction to MSSQL Server 2000 Analysis Services. As I stated in the first article, «a href="http://www.databasejournal.com/features/mssql/article.php/1429671"»Creating Our First Cube«/a», the primary focus of this series is an introduction to the practi
....Read More |
| Rating
|
|
|
|
Powerful New T-SQL Syntax Gives SQL Server a Programmability Boost
|
| Total Hit (2386) |
The T-SQL language in the upcoming version of SQL Server will provide more power and flexibility than previous versions. Additions and enhancements include error handling with the TRY/CATCH construct, SNAPSHOT isolation, and WAITFOR enhancements. Also important are the BULK rowset provider, common t
....Read More |
| Rating
|
|
|
|
Application Design Optimization Tips
|
| Total Hit (1019) |
Here are fifteen tips that you can use to ensure your Application Designs are performing in the most efficient manner possible.
|
| Rating
|
|
|
|
|
|
XML and SQL 2000 (Part 4)
|
| Total Hit (1146) |
In the fourth article of the series dealing with XML related features of SQL Server 2000, I will discuss the implications of various configuration options available when using IIS Virtual Directory Management for SQL Server. As described previously, the Settings tab of the Virtual Directory Properti
....Read More |
| Rating
|
|
|
|
Bryan's WebLog for Reporting Services
|
| Total Hit (1020) |
Using an External DataSet with Reporting Services Reports
Writing Custom Code for Reporting Services Reports
GetReportParameters method
Welcome Tudor to Reporting Services Blogging
Reporting Services Service Pack 1 Now Available!
And many more....
....Read More |
| Rating
|
|