Title: DBA Tips
![]() |
![]() |
![]() |
IN THIS ISSUE:
>
Getting an environment variable value using T-SQL
>
Adding T-SQL functions to SQL Server system schema
>
SQL Server: Identifying external or internal table fragmentation
>
PASS: What's new in SQL Server 2005
>
Make your iSeries database easy to read
>
Performance tuning is war
>
Call for submissions
>
Analytics: Tips and advice
SPONSORED BY:
SearchDatabase.com Product and Vendor Guide
![]()
Simplify the process of finding specific database products and solutions. SearchDatabase.com's Product and Vendor Guide allows you to search listings alphabetically, and by industry or across such topics as database tuning, data warehousing and more.
![]()
Visit our easy-to-use guide now!
|
![Advice]()
![]()
Getting an environment variable value using T-SQL
[Eli Leiba]
This article describes how to get an operating system environment variable value in a T-SQL script programmatically.
MORE INFO:
> Hundreds more SQL Server tips and scripts
| SPONSORED BY:
SearchDatabase.com
|
![]() |
Product and Vendor Guide
Simplify the process of finding specific database products and solutions. SearchDatabase.com's Product and Vendor Guide allows you to search listings alphabetically, and by industry or across such topics as database tuning, data warehousing and more.
>> Visit our easy-to-use guide now!
|
|
![]() |
|
Adding T-SQL functions to SQL Server system schema
[Eli Leiba]
This article describes how to add T-SQL functions to the SQL Server system schema for use by an entire server.
SQL Server: Identifying external or internal table fragmentation
[Eli Leiba]
This article describes how to identify tables that are fragmented internally (ie, fragmentation inside data pages) or externally (ie, extents are fragmented).
PASS: What's new in SQL Server 2005
[SearchDatabase.com]
Direct from the PASS conference last week, here's the latest about the cool (and controversial) new features coming in SQL Server 2005.
Make your iSeries database easy to read
[Search400.com]
This article takes a quick look at making your iSeries database easier for users to read. By creating simple data marts and using SQL views, you can make your production data understandable for user reporting.
Performance tuning is war
[Craig Shallahamer]
ist Craig Shallahamer compares Oracle performance tuning to the wars of old and offers a lesson to young DBAs about how to survive the bloodshed.
![Also on SearchDatabase.com]()
![]()
PRODUCTS OF THE YEAR:
Call for submissions
You are invited to nominate your favorite data management product released in the past year: database administration, development, business intelligence, and integration suites and tools are accepted. Our editors and other database industry experts will judge the entries. Vendor and user recommendations are welcome. The deadline for submissions is October 22, 2004 and winners will be announced January 17, 2005.
FEATURED TOPIC:
Analytics: Tips and advice
With data growing exponentially, business intelligence technologies are essential to maximize revenue and monitor corporate performance. Visit our collection of BI news, tips, & expert advice...
|
![]() |
|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Contact Us
Sales
For sales inquiries, please contact us at:
[EMAIL PROTECTED]
Editorial
For feedback about any of our articles or to send us your article ideas, please contact us at:
[EMAIL PROTECTED]
|
|
![]() |
![]() |
Free E-Newsletters!
Select e-newsletters you would like to receive via e-mail!
|
SearchWin2000: SQL Server Webcast Alerts |
|
SearchWin2000: SQL Server White Paper Alerts |
|
![]()
|
| Not a Member? We'll activate your membership with your subscription. |
|
![]() |
![]() |
![]() |
|
![]() |
|
![]() |
|
