|
|
|
|
 |
Shrink log files of all user databases
|
| Total Hit (5117) |
«code LangId=6»declare @ssql nvarchar(4000)
set @ssql= '
if ''?'' not in (''tempdb'',''master'',''model'',''msdb'') begin
use [?]
declare @tsql nvarchar(4000) set @tsql = ''''
declare @iLogFile int
declare @sLogFileName varchar(55)
declare @RecoveryModel nvarchar(10)
declare LogFiles cursor
....Read More |
Rating
 |
|
|
|
Tricky order by without writing dynamic T-SQL
|
| Total Hit (2479) |
This example shows you how to write dynamic order by statement without writing Dynamic T-SQL which is required to re-compile the execution plan every time you run it.
|
| Rating
|
|
|
|
How to perform update on multiple tables of linked server.
|
| Total Hit (2457) |
This code demonstrates
1) How to write update trigger which checks modification for a specified field (e.g. here DistrictId)
2) How to handle Errors during update
3) How to update data on linked server.
4) How to do update which requires joining tables
5) How to use XACT_ABORT option to handle
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
How to create dynamic query without loosing performance.
|
| Total Hit (1660) |
We all know that in sql server you can use exec or execute statement to execute dynamic sql statement which can be on the fly but the biggest drawback of executing dynamic query using execute is query plan is not chached by sql server and so you get poor performance if you hitting many tables and se
....Read More |
Rating
 |
|
|
|
Minimum value from 4 variables - datetime example.
|
| Total Hit (2070) |
This scripts shows how to obtain minimum value of four 4 datatime values contained in local variables. This method can be adapted to any datatye supported by the the SQL Server MIN function. This technique basically eliminates the writing of series of IF..ELSE or CASE statements.
....Read More |
| Rating
|
|
|
|
|
|
RDBMS Performance Tuning Guide for Data Warehousing
|
| Total Hit (1772) |
This performance tuning guide is designed to help database administrators and developers configure Microsoft® SQL Server™ 2000 for maximum performance and to assist in determining causes of poor performance of relational databases, including those used in data warehousing. It also provides guideline
....Read More |
| Rating
|
|
|
|
Linked Servers on MS SQL: Part 1
|
| Total Hit (883) |
Think of a Linked Server as an alias on your local SQL server that points to an external data source. This external data source can be Access, Oracle, Excel or almost any other data system that can be accessed by OLE or ODBC--including other MS SQL servers. An MS SQL linked server is similar to the
....Read More |
| Rating
|
|
|
|
|
|
|
|
XML for Analysis (XMLA) SDK Download
|
| Total Hit (1047) |
The Microsoft XML for Analysis SDK contains the Microsoft® XML for Analysis provider and sample client applications. The Microsoft® XML for Analysis Provider supports data access to analytical data sources (OLAP and data mining) residing on the Web. This provider implements the XML for Analysis Spec
....Read More |
| Rating
|
|
|
|
|
|
|
|
DTS How to...Transfer Packages between Servers
|
| Total Hit (1058) |
There are two ways to transfer packages between servers. The simple method is to save packages as COM Structured Storage Files, copy them to the new location, then open and save them to the new server. Whilst this works, it is very tedious when you have a lot of packages. You can automate much of th
....Read More |
| Rating
|
|
|
|
Textual Searches on Database Data
|
| Total Hit (1907) |
This chapter describes support for textual queries against data within SQL Server tables. The full-text search concepts are introduced, followed by the form that a full-text search takes and the information that can be retrieved by means of such queries. The internal design and architecture of the f
....Read More |
| Rating
|
|
|
|
Creating a custom task with a default UI
|
| Total Hit (1444) |
The Developing a User Interface for a Custom Task entry in Books Online describes how to build your UI from scratch, but there is an easier way to create a UI that has the same look and feel as the stock tasks that ship with SSIS.
The Microsoft.DataTransformationServices.Controls assembly expose
....Read More |
| Rating
|
|
|
|
MDX Essentials: Basic Set Functions: The Filter() Function
|
| Total Hit (1083) |
This is the sixteenth 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
|
|
|
|
|
|
MDX Essentials: Basic Set Functions: The Intersect() Function
|
| Total Hit (769) |
This is the fourteenth 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
|
|
|
|
|
|
Examples of how to Calculate Different SQL Server Dates
|
| Total Hit (592) |
Every now and then, you need to take the current date and calculate some other date. For instance, you might have an application that needs to determine what date is the first day of the month, or need to know the last day of the month. Now most of you probably already know how to separate the date
....Read More |
| Rating
|
|
|
|
Indexed Views Basics in SQL Server 2000
|
| Total Hit (1098) |
Indexes have been a method to improve the performance of SQL queries since the creation of relational databases in the 1970's. You are probably familiar with the ways that indexes can speed query operations at the expense of additional overhead during data inserts, updates, and deletes. Up until rec
....Read More |
| Rating
|
|
|
|
Build a Web Site Traffic Analysis Cube: Part I
|
| Total Hit (2180) |
This is the thirteenth article of the series, Introduction to MSSQL Server 2000 Analysis Services. As I stated in the first article, Creating Our First Cube, the primary focus of this series is an introduction to the practical creation and manipulation of multidimensional OLAP cubes. The series is d
....Read More |
| Rating
|
|
|
|
MDX Essentials: MDX Member Functions: "Relative" Member Functions
|
| Total Hit (720) |
This is the eighth article of the series, MDX Essentials. The primary focus of this series is an introduction to MDX. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features design
....Read More |
| Rating
|
|