|
|
|
|
|
|
 |
Date and Time User-Defined Functions
|
| Total Hit (3844) |
Introduction
Date and Time UDFs
DatePart
TimePart
GetWorkingDays
AddWorkingDays
FirstMonthDay
LastMonthDay
--------------------------------------------------------------------------------
Introduction
I would like to write the series of articles about useful User-Defined Fu
....Read More |
Rating
 |
|
|
|
|
|
|
|
Extract records by their record number
|
| Total Hit (2928) |
SQL Server, and the SQL language in general, doesn't support record numbers, so you can't extract a set of records if you know their position in the resultset. This missing capability would be extremely convenient when displaying pages of data in an ASP program. For example, if each page contains 10
....Read More |
| Rating
|
|
|
|
The fastest way to delete all the rows in a table
|
| Total Hit (2814) |
The standard way to delete all the rows in a SQL Server table is a DELETE statement without a WHERE clause:
«Code LangId=6»
DELETE FROM MyTable
«/Code»
However, in most cases you can speed up your code remarkably with the TRUNCATE TABLE command: «Code LangId=6»
TRUNCATE TABLE MyTable «/Code
....Read More |
| Rating
|
|
|
|
|
|
Deleting Duplicate Records
|
| Total Hit (2177) |
May of us have faced duplicate records issue in SQL Server Table. First, I'll need some duplicates to work with. I use following script to create a table called dup_authors in the pubs database.
«Code LangId=6»
-- If the table exists, drop it
use pubs
go
If exists (select * from INFORMATION_SC
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
Failover Clustering
|
| Total Hit (746) |
Continuous uptime in a production environment, whether it is a database powering a mission-critical client/server application or an e-commerce Web site, is becoming a common businesses requirement. This chapter describes Microsoft® SQL Server™ 2000 failover clustering, one method of creating high av
....Read More |
| Rating
|
|
|
|
Examining SQL Server's I/O Statistics
|
| Total Hit (820) |
Reading and writing to the disk is the heart of what any database management system does, SQL Server included. Input/Output (I/O) performance can make or break an application. This article discusses the diagnostic tools that can be used to examine SQL Server's I/O statistics so that you can make fac
....Read More |
| Rating
|
|
|
|
Using and Building Query Analyzer Templates
|
| Total Hit (703) |
The Query Analyzer (QA) in SQL Server 2000 is greatly enhanced over the QA in SQL Server 7.0. One of the enhancements, QA templates, can increase your productivity in developing code.
QA comes with over fifty canned templates that you can use. Although these templates are useful as they are insta
....Read More |
| Rating
|
|
|
|
SQL Server and Collation
|
| Total Hit (504) |
Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.
....Read More |
| Rating
|
|
|
|
How to loop through a global variable Rowset
|
| Total Hit (840) |
The Execute SQL Task for SQL Server 2000 allows both input and parameters to be specified. In this article we will be focusing on the Rowset output parameter functionality, and what we can then do with the Recordset it returns. The Rowset parameter takes the result set of a SELECT statement and stor
....Read More |
| Rating
|
|
|
|
|
|
How to check the file date
|
| Total Hit (603) |
This sample script was written to check the age of a file. If you import files according to a schedule, you may wish to check that the file is recent to prevent the potential re-import of an old file. The script reads the filename from an existing package connection and uses the scripting FileSystem
....Read More |
| Rating
|
|
|
|
Overview of Native XML Web Services for Microsoft SQL Server 2005
|
| Total Hit (1085) |
Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.
....Read More |
| Rating
|
|
|
|
|
|
|
|
using NT Authentication to login into SQL
|
| Total Hit (1115) |
This is for using NT authentication (NT users already setup in the Domain)
So you need to get the correct spelling of each user in User Manager for Domains.
Then it will get the user from NT when they log in and bingo they have permissions to the SQL server database too.
....Read More |
| Rating
|
|
|
|
Implementing CRUD Operations Using Stored Procedures: Part 1
|
| Total Hit (757) |
That's the American Heritage dictionary definition but not the database definition. When you are working with databases, CRUD is an acronym for the four essential database operations: Create, Read, Update, and Delete.
|
| Rating
|
|
|
|
|
|
XML for Analysis (XMLA) Specification
|
| Total Hit (970) |
Specifies a SOAP-based XML communication API that supports the exchange of analytical data between clients and servers on any platform and with any language.
|
| Rating
|
|
|
|
|
|
Comparing Oracle 10g and SQL Server Yukon
|
| Total Hit (1221) |
The purpose of the following technical paper from WisdomForce is to provide a feature comparison between MSSQL 2005 (Yukon) and Oracle 10g.
The document compares VLDB/OLTP related features and discuss issues with performance, utilities and replication. It discusses several new features, which we
....Read More |
| Rating
|
|