|
How to create audit triggers?
|
Total Hit (2304) |
This article will show you the most easiest way to audit your data changes for a specific table in sql server.
I will show you, how to use <Code>DBCC INPUTBUFFER</Code> command to capture some valuable audit information when update/insert/delete occurs.
Step-By-Step Example
- Run the follow
....Read More |
Rating
|
|
|
|
|
|
|
|
Correct installation of Server service on Windows NT4 for SQL
|
Total Hit (2683) |
It is especially important to correctly set Windows NT4's Server service in "Application Server" mode to ensure that the Server service doesn't absorb all the available hardware resources while providing network services for file management. As its name suggests, when in "Application Server" mode, r
....Read More |
Rating
|
|
|
|
|
|
|
Flight Schedule Ordering problem.
|
Total Hit (1692) |
A flight schedule ordering problem. This demonstrates the powerful derived table feature. More details regarding the problem is in the link.
|
Rating
|
|
|
|
Avoid Auto Close and Auto Shrink.
|
Total Hit (3030) |
I was on-site with a client, whose had a server which performing very sluggishly. It was a beefy brute with heaps of memory and processing power, so clearly something was just not what it should have been.
For me step 1 in doing any sort of trouble-shooting is to look at the logs. Yup, always a
....Read More |
Rating
|
|
|
Send fax from SQL Server using Microsoft Word
|
Total Hit (9833) |
This article explains how you can create a Microsoft Word document from T-SQL and fax it through a method exposed by its Automation object model.
You can create and destroy OLE Automation object using the sp_OACreate and sp_OADestroy, whereas you can use the sp_OAMethod to invoke a method, and t
....Read More |
Rating
|
|
|
Index Optimization Tips
|
Total Hit (2960) |
«B»General concepts«/B»
In this article, I want to show how you can improve the speed of your queries by choosing the proper indexes, what kinds of indexes MS SQL supports and what is the advantage and disadvantage of using indexes in particular situation.
There are clustered and nonclustere
....Read More |
Rating
|
|
|
Generic logic to search & replace characters in a string.
|
Total Hit (1511) |
A generic logic to search & replace certain characters in a string. This approach is flexible in the sense that new characters can be added for searching without modifying the logic. This will make the code more maintainable too.
|
Rating
|
|
|
Getting Syntax Help for DTSRun
|
Total Hit (579) |
If you are having problems with the syntax for the dtsrun command line, or just want an easy way of generating a valid command line first time, try using the dtsrunui utility. As the name indicates it is very similar to dtsrun, but with a user interface. This allows you to easily select your package
....Read More |
Rating
|
|
|
|
|
Get More Out of SQL Server Reporting Services Charts
|
Total Hit (4141) |
This white paper presents general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports. It provides an overview of some Reporting Services features, answers common chart design and feature questions, and includes advanced examples of how t
....Read More |
Rating
|
|
|
|
|
SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow
|
Total Hit (2080) |
As we indicated in our previous article, we are going to continue discussing various ways of utilizing global variables in DTS Designer tasks. In particular, we will look into their role in exchanging data between packages, using features built into the Execute Package task. As part of this discussi
....Read More |
Rating
|
|
|
SQL Server 2000 DTS Part 2 - Creating DTS Packages using Wizards
|
Total Hit (2032) |
As we explained in the first article of this series, there are three methods of creating DTS packages - with DTS Designer graphical interface, with programming by directly using the DTS object model, or with wizards available from the SQL Server Enterprise Manager interface. We will focus here on th
....Read More |
Rating
|
|
|
Padding, Rounding, Truncating and Removing Trailing Zeroes
|
Total Hit (621) |
In this article, I am going to show you a number of tips for displaying numeric fields as strings. I will show you how to pad zeroes on the left side of numeric numbers, so that each number regardless of the size will be the same length. Also along those same lines below you will find out how to pad
....Read More |
Rating
|
|
|
Global Variables and SQL statements in DTS
|
Total Hit (776) |
For those fortunate enough to have SQL 2000, using global variables with an Execute SQL Task, or as part of the source statement in the DataPump task is now a standard feature. For those still using SQL Server 7.0 this tedious process, but here are some examples of how it can be done. Even if you ar
....Read More |
Rating
|
|
|
How to share data between stored procedures
|
Total Hit (700) |
Questions you often see in newsgroups about MS SQL Server are: How can I use the result set from one stored procedure in another or How can I use the result set from a stored procedure in a SELECT statement?
|
Rating
|
|
|
T-SQL Programming Part 1 - Defining Variables, and IF...ELSE logic
|
Total Hit (513) |
This is the first of a series of articles discussing various aspects of T-SQL programming. Whether you are building a stored procedure or writing a small Query Analyzer script you will need to know the basics of T-SQL programming. This first article will discuss defining variables, and using the IF.
....Read More |
Rating
|
|
|
Using Partitions in a SQL Server 2000 Data Warehouse
|
Total Hit (1629) |
This chapter discusses the role of partitioning data in the data warehouse. The relational data warehouse and Microsoft® SQL Server™ 2000 Analysis Services cubes both support the partitioning of data. The logical concept behind partitioning is the same in both engines of SQL Server: to horizontally
....Read More |
Rating
|
|