|
|
 |
Using FTP in Transact-SQL
|
| Total Hit (4001) |
«B»Introduction«/B»
I’ve seen a few posts asking “How do I ftp a file into SQL” Well, if you have 6.5 or 7.0 this article should be helpful. Unfortunately it’s not an easy answer, but it’ll work great once you’ve set it up. The answer is that there isn’t a function in SQL to let you do this, you
....Read More |
Rating
 |
|
|
|
|
|
|
|
Monitor stored procedure and batch activity from remote workstations
|
| Total Hit (2410) |
Using the sp_user_counterX stored procedure (where X is a number between 1 and 10) you can set internal SQL Server counters. This values are read by the Performance Monitor, the standard Windows utility that monitors system activity. The Performance Monitor is able to monitor not only the activities
....Read More |
| Rating
|
|
|
|
|
|
Avoid error 1540 in Join queries
|
| Total Hit (2775) |
When you plan your queries, you should avoid the use of wildcard keyword * - which means "retrieve any field" - mainly because it may decrease performances, since the engine allocates space for the entire row; use explicit field declaration instead, such as:
SELECT field1, field2 FROM table1
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Monitoring Hard Drive Space
|
| Total Hit (2841) |
This script monitors available disk space for the specified drive. If a drive name is not specified in @drivename parameter the usp_dba_diskspace_monitor stored procedure will check all drives against a space limit (MB) passed through @spacelimit parameter. If available disk space is less then @spac
....Read More |
| Rating
|
|
|
|
|
|
|
|
A Practical Guide to SQL Server Yukon Beta 1 DTS
|
| Total Hit (1548) |
To understand the new features in "Yukon" Data Transformation Services (DTS), one must in many ways take a step back from the knowledge of prior DTS releases and come to the product with a fresh perspective. It is not that the new release is entirely different than its predecessors, but the similari
....Read More |
| Rating
|
|
|
|
Setting Up Snapshot Replication: A Step-by-step Guide
|
| Total Hit (657) |
In this article, I want to tell you about some general Microsoft SQL Server replication topics: replication topologies, replication types, and replication agents. I will also discuss Snapshot replication: how to check necessary conditions for this type of replication and how to backup and restore th
....Read More |
| Rating
|
|
|
|
|
|
|
|
SQL Server and XML
|
| Total Hit (1106) |
Read the sample chapter from a new book released by Wrox Press, "Begining SQL Server 2000 for Visual Basic Developers". This chapter explores new XML features in SQL Server 2000 and takes a look at how you can exploit them to your benefit. We will also take a look at how we can use XSL (Extensible S
....Read More |
| Rating
|
|
|
|
T-SQL Programming Part 5 - Using the CASE Function
|
| Total Hit (559) |
The CASE function is a very useful T-SQL function. With this function you can replace a column value with a different value based on the original column value. An example of where this function might come in handy is where you have a table that contains a column named SexCode, where 0 stands for fem
....Read More |
| Rating
|
|
|
|
Compressed Backup of SQL Server 6.5, 7.0 and 2000 on Windows 2000
|
| Total Hit (1219) |
DBAs are always running out of hard disk space when handling large databases such as data-warehouse databases and other VLDB. Backing up such databases to disk occupies more disk space, since Microsoft SQL Server does not have compression built into the backup process. SQL Server customers usually g
....Read More |
| Rating
|
|
|
|
Writing Secure Transact-SQL
|
| Total Hit (702) |
There are plenty of good sources of information about how to deploy SQL Server in a secure fashion. However, these resources are often targeted at database administrators tasked with securing already developed applications. In addition, there is a rich body of information that discusses writing secu
....Read More |
| Rating
|
|
|
|
|
|
Using SQL Server's CHARINDEX and PATINDEX
|
| Total Hit (1186) |
If you have written many applications then you probably have run across situations where you need to identify if a specific character or set of characters appears in a string. In this article I will discuss using the CHARINDEX and PATINDEX functions to search text columns and character strings. I wi
....Read More |
| Rating
|
|
|
|
Scheduled Task Reporting on SQL Server
|
| Total Hit (619) |
If you have a server with a large number of scheduled tasks, you will know that keeping track of them all can be a bit difficult at times - checking and double-checking that your database backups and log backups are in synch, that maintenance tasks go off in the correct order, and that tasks do not
....Read More |
| Rating
|
|
|
|
|
|
Find Out What They're Doing with fn_get_sql
|
| Total Hit (1112) |
Not only did SQL Server 2000 introduce the concept of user-defined functions (UDF) but also Microsoft's development team created several such functions as part of the database product. In addition to many undocumented system UDFs, used internally by SQL Server, the product release has nine documente
....Read More |
| Rating
|
|
|
|
SQL Reporting Services with Dynamic Column Reports
|
| Total Hit (1277) |
Hi all, this is the second time I am getting a task for dynamically creating reporting columns. In the first instance, I had done it by first binding the data to a DataGrid (by setting the auto-generated columns feature to true and then exporting to Excel). In the second case, the task was to genera
....Read More |
| Rating
|
|
|
|