December 2008 - Posts

1
Comments

Checking Depreciated Feature through Profiler by Kasim.Wirama

Checking Depreciated Feature through Profiler By : Kasim Wirama, MCDBA, MCITP I have long time to use profiler, mainly to trouble shoot database problem and also it is useful in database development too. And I see profiler is the easiest tool among similar...
Filed under:
0
Comments

SQL CLR User Defined Function by Kasim.Wirama

SQL CLR User Defined Function By : Kasim Wirama, MCDBA, MCITP I would like to show how to create CLR user defined functions in SQL Server project type (Visual Studio 2005/2008). Here I would like to give 2 examples for 2 types of user defined functions...
Filed under:
0
Comments

Namespace for SQL CLR Assembly by Kasim.Wirama

Namespace for SQL CLR Assembly By : Kasim Wirama, MCDBA, MCITP SQL Server provides possibility to reference .NET assembly code from outside database environment. It is possible through integration .NET CLR into SQL Server architecture, called SQL CLR...
Filed under:
0
Comments

Various Way to Retrieve Column Information by Kasim.Wirama

Various Way to Retrieve Column Information By : Kasim Wirama, MCDBA, MCITP If you always query against database metadata information in SQL Server, you must be familiar with some of system tables such as sysdatabases, syscolumns, sysobjects, etc. Some...
Filed under:
0
Comments

Prepare Your Database Script for Smooth Upgrade by Kasim.Wirama

Prepare Your Database Script for Smooth Upgrade By : Kasim Wirama, MCDBA, MCITP Your database probably has been run well over years using SQL Server 2000/2005. And upgrade process doesn’t always go smoothly and you should that the more bigger major version...
Filed under:
0
Comments

NULL = NULL is True ? by Kasim.Wirama

NULL = NULL is True ? By : Kasim Wirama, MCDBA, MCITP Not as in common programming world where a comparison only yields TRUE or FALSE, in SQL Server comparison would yield 3 possible result : TRUE, FALSE and UNKNOWN. UNKNOWN result would come from comparison...
Filed under:
0
Comments

Top and Order By Combination by Kasim.Wirama

Top and Order By Combination By : Kasim Wirama, MCDBA, MCITP Given that a table (for example : content table) contains integer records : 2, 1, 3 and I would like to retrieve the rows in ordered fashion, you simply issue a query : SELECT COL1 FROM CONTENT...
Filed under:
0
Comments

Danger of Dynamic SQL by Kasim.Wirama

Danger of Dynamic SQL By : Kasim Wirama, MCDBA, MCITP You probably have used dynamic SQL inside your stored procedure. As name implies, the query could change dynamically and usually dynamic SQL is executed by sp_executesql or EXEC () statement. What...
Filed under:
0
Comments

Setting Up Performance Counter Measurement for SQL Server Performance Issue by Kasim.Wirama

Setting Up Performance Counter Measurement for SQL Server Performance Issue By : Kasim Wirama, MCDBA, MCITP If you encounter database performance issue and you will measure database performance issue affected by database environment, you can rely on Windows...
Filed under:
1
Comments

Querying Object Metadata With Catalog View by Kasim.Wirama

Querying Object Metadata With Catalog View By : Kasim Wirama, MCDBA, MCITP If you want to know SQL Server specifics object such as column, computed column, check constraint, default constraint, events, extended procedures, foreign keys, foreign key columns...
Filed under:
2
Comments

Activity Monitor Toolbar in SSMS SQL Server 2008 by Kasim.Wirama

Activity Monitor Toolbar in SSMS SQL Server 2008 By : Kasim Wirama, MCDBA, MCITP I capture something interesting when I fire up SQL Server Management Studio (SSMS) for SQL Server 2008. Try to find a toolbar button called Activity Monitor. Found it? Yes...
Filed under:
0
Comments

Question to Contemplate this Weekend by Kasim.Wirama

Question to Contemplate this Weekend By : Kasim Wirama, MCDBA, MCITP How far does query cost 96% : 4% or even 99% : 1% impact for your application performance? J Turn expensive hardware cost in IT expense into effective hardware cost in IT profit center...
Filed under:
1
Comments

Querying CLR Assembly Information with Catalog View by Kasim.Wirama

Querying CLR Assembly Information with Catalog View By : Kasim Wirama, MCDBA, MCITP Since SQL Server 2005 has been released to market, you have better option to query metadata of SQL Server. Metadata in general terms is simply defined as data describes...
Filed under:
0
Comments

Get database and database files information by Kasim.Wirama

Get database and database files information By : Kasim Wirama, MCDBA, MCITP You can get information about database and file information with catalog view. There are 6 catalog views related to database and files information. Let’s look at each of them...
Filed under:
0
Comments

Extended Event, New Tracing Engine in SQL Server 2008 by Kasim.Wirama

Extended Event, New Tracing Engine in SQL Server 2008 By : Kasim Wirama, MCDBA, MCITP SQL Server 2008 introduces new tracing engine capability, called Extended Events. It will capture server side events and put the capture result into a wide variety of...
Filed under:
More Posts Next page »
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems