|
|
|
|
 |
Dynamic execution of SP ( This method is not well-known ).
|
| Total Hit (2459) |
This method of dynamic SQL execution is not well-known. This will work from SQL60 & upwards. This is very useful when calling SPs dynamically with parameters of different datatypes, output parameters & return value.
|
Rating
 |
|
|
|
|
|
|
|
|
|
How to install MSDE
|
| Total Hit (4034) |
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
|
|
|
|
DATEFLOOR : Rounding dates to nearest day,hour,minute,second
|
| Total Hit (7237) |
This function takes a date and a date part parameter and rounds the date down to the nearest date part.
Credit goes to "Gordon Klundt"
<b>Example:</b>
In order to round '2010-11-03 17:44:10.117' to the nearest hour ('2010-11-03 17:00:00.000')
«code LangId=6»select dbo.datefloor(cast('2010-
....Read More |
| Rating
|
|
|
|
|
|
|
|
Procedure to import SQL Server error log into a table (SQL 2000)
|
| Total Hit (3270) |
This procedure reads the SQL Server error log using sp_readerrorlog and imports the error log's contents into a specified table. It accepts three parameters:
@log_name is the name of the table into which the error log will be imported
@log_number is the error log number, 0 is default and refers
....Read More |
| Rating
|
|
|
|
|
|
|
|
MDX Essentials: Basic Set Functions: The Order() Function
|
| Total Hit (960) |
This is the twelfth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
....Read More |
| Rating
|
|
|
|
Multiple Paths in Workflow
|
| Total Hit (967) |
Branching workflow is a common requirement, and is quite easy to achieve using the basic On Success or On Failure constraints available through the designer. However branches go in different directions and do not meet up again.
|
| Rating
|
|
|
|
Configuring Disks and Managing Space in SQL Server Part 1
|
| Total Hit (940) |
Something like fifty percent of system outages are caused by "Out of space" conditions. I kid you not. I run into them all the time. Combine this problem with the need to maintain high availability and peak performance and the consequence is that disk configuration and space allocation become one of
....Read More |
| Rating
|
|
|
|
Disabling or Enabling All Constraints of a Table or Database
|
| Total Hit (1188) |
These procedures are very important to use when you need to load a bulk of data that you know is correct but when you do not need the foreign keys and check constraints to interfere while you are loading the data. This is also the case when you want to change key values and don't want the constraint
....Read More |
| Rating
|
|
|
|
|
|
Troubleshooting SQL Server Alerts
|
| Total Hit (1090) |
If you have problems with Microsoft SQL Server alerts, review this troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
Import Files with Date-stamped Filenames or Paths
|
| Total Hit (1180) |
DTS packages are fantastic features available in SQL Server 7.0 and SQL server 2000. One outstanding feature in the DTS package is the ability to run ActiveX scripts. ActiveX gives us an added advantage in handling many situations; we will discuss how to handle three of these situations.
File-nam
....Read More |
| Rating
|
|
|
|
Exporting SQL Data as XML
|
| Total Hit (3228) |
In my last article, Importing XML into SQL Server 2000, we looked at various techniques to import the XML data into SQL Server. To complement that, this article will focus on some of the methods that you can use to export relational SQL data to the XML format.
More specifically, we'll explore th
....Read More |
| Rating
|
|
|
|
XML and SQL 2000 (Part 3)
|
| Total Hit (1074) |
In the third article of this series, we will look into executing T-SQL statements against SQL Server 2000 via HTTP. This functionality is provided by SQLXML component (implemented in the form of SQLISAPI.DLL, which is included as part of SQL Server 2000 installation). The updated versions of this co
....Read More |
| Rating
|
|
|
|
Implementing Application Roles
|
| Total Hit (1154) |
SQL Server 7.0, as well as SQL Server 2000, support several technological feature enhancements that allow for a faster time to completion for database and application development. Application roles exist as SQL Server database objects that allow developers and database administrators to assign SQL S
....Read More |
| Rating
|
|
|
|
How to Create ODBC DSN on multiple SQL server machines
|
| Total Hit (2082) |
In a typical Client - Server environment it is often necessary to create ODBC DSN on many client machines or servers for front-end applications such as VB, or MS-Access, which uses ODBC DSN for linked tables. Even for creating linked servers to heterogeneous systems like Oracle, Sybase and mainframe
....Read More |
| Rating
|
|
|
|
Dynamic ORDER BY Statements in Stored Procedures
|
| Total Hit (1644) |
When creating data-driven Web applications, it is ideal to place the actual SQL statements into stored procedures, and to have the Web pages, then, call the appropriate stored procedures rather than executing the SQL statements themselves. (If you are unfamiliar with what stored procedures are, or t
....Read More |
| Rating
|
|
|
|
How do I know what type of index to create?
|
| Total Hit (1305) |
We get a lot of index questions related to what type of index should be created given a particular situation. I compiled the items below from books-online to facilitate this discussion:
Before creating clustered indexes, understand how your data will be accessed.
....Read More |
| Rating
|
|
|
|
Coping with text files and abnormal column or row delimiters
|
| Total Hit (1238) |
Sometimes you may receive a text file to import that has a row or column delimiter not available in the standard drop-down boxes of the Text File Properties dialog.
The first thing to try in these cases is to type directly into the Row Delimiter or Column Delimiter box. This will work fine if th
....Read More |
| Rating
|
|
|
|
Connecting to MS SQL Server from Unix
|
| Total Hit (1042) |
I've written this page as I keep getting questions on how to access MS SQL Server from Unix. I have never had any reason talk to SQL Server from Unix myself, but since people kept asking me how to do it, I decided to compile an web page with the tiny fragments of information and I have. The main foc
....Read More |
| Rating
|
|
|
|
|
|
Changing the DataPump Source and Destination Tables
|
| Total Hit (1082) |
You can use an ActiveX Script to change both the source and destination of the DataPump task.
The first thing you need is the Name of the task. Right-click the DataPump task and select Workflow Properties. On the options tab it shows you the step name. The task name is almost guaranteed to be th
....Read More |
| Rating
|
|