Posted in Community :

6 more ...

SQL Server 2005/2008 Profiler

Tags : sql server, sql server 2005, sql server 2008, sql server 2000, sql server database, microsoft sql server, sql server jobs, vb net sql server, database, sql database, sql developer, sql dba, sql server download, ms sql, mssql, sql, software, applications

Industry : IT Products
Functional Area : Application Software

Refer

1 2 3 4 5 Rate :	Follow this Topic		more actions >> Report Abuse [Edit]
Post Trends/Insight	Ask Question	Start a Debate	Ask for Ideas

About "SQL Server 2005/2008 Profiler" topic:

While many DBAs may understand SQL Server 2008 Profiler basics, not too many know how to tap the full potential of this important utility. Here we shall share our knowledge and learn many advanced techniques that can be used to troubleshoot both SQL Server problems and performance issues.

3 insight , 2 debates , 1 question on topic: "SQL Server 2005/2008 Profiler"

Sort by: Top Rated Most Recent Most Viewed Most Referred Most Discussed

Prev1NextShowing 1 - 6 of 6

Database Shrinking in SQL Server

(rate this)

Database Shrinking in SQL Server How do I reclaim space in SQL Server? As time goes by, the disk space requirements for your database may fluctuate greatly. You can set SQL Server to automatically expand a database when it requires more space; and you can also set it to 'shrink' when it can reclaim allocated but unused space. Sometimes it makes sense to enable autogrow and autoshrink events, and sometimes it doesn't. (See KB #315512 for information about enabling each of these options.) Shrinking Data Files (*.MDF / *.NDF) If you haven't enabled the auto-shrink setting, there may be times when your database has been cleared of significant amounts of data, and you'd like to reclaim t...

View all 2 comments

Comment

Refer

	RAJEEV KUMAR \| Commented \| 2 years ago
	Why database shrinking is not done implicitly? It is better idea to save space automatically. Or some performance concerns are hidden.

Insight: "Database Shrinking in SQL Server" deleted from your view.

DMV’s in SQL Server 2005

(rate this)

Dynamic Management Views The dynamic management views (DMV’s) in SQL Server 2005 are designed to give DBA a window into what's going on inside SQL Server. They can provide information on what's currently happening inside the server as well as the objects it's storing. They are designed to be used instead of system tables and the various functions provided in SQL Server 2000. The DMV’s are actually composed of both views and table-valued functions. Some apply to the entire server and are stored in the master database. Others are specific to each database. All are stored in the sys schema . They all start with dm_ in the name. The DMV’s are newly introduced in SQL Server 2005 gives dat...

View all 6 comments

Comment

Refer

	LAXMAN KESHWALA \| Commented \| 7 months ago
	All these matter is related to internet server provider so you have to contact with him.

	Sandeep Kumar \| Commented \| 7 months ago
	I m not understand what r u saying

Insight: "DMV’s in SQL Server 2005 " deleted from your view.

Integrated Full Text Search (iFTS) in SQL Server 2008

(rate this)

The SQL Server Development Team at Microsoft has been doing some great work with Integrated Full Text Search (iFTS) in SQL Server 2008. The iFTS feature is available in the February CTP of SQL Server 2008. Simon Sabin , who is an active SQL Server MVP in the UK, has a good series of posts talking about performance improvements with iFTS compared to the old FTS in SQL Server 2005. What I have seen with iFTS on CTP6 is that it does perform much better than SQL 2005 FTS (at least for our workload), but there are a few issues to be aware of with this CTP. First, (especially if you have a heavy insert/delete load on your base table), you should use manual change tracking instead of automatic cha...

View all 2 comments

Comment

Refer

	prashant pamani \| Commented \| 2 years ago
	USE [Customer] /****** Object: Table [dbo].[OCRDocument] SET ANSI_NULLS ON exec sp_fulltext_database 'enable' SET QUOTED_IDENTIFIER ON IF NOT EXISTS (SELECT * FROM sys.fulltext_catalogs WHERE name = N'FullTextSearch_Catalog') BEGIN CREATE FULLTEXT...

Insight: "Integrated Full Text Search (iFTS) in SQL Server 2008" deleted from your view.

SQL SERVER 2008 OR ORACLE...Which is better?

(rate this)

SQL SERVER

ORACLE

View all 10 arguments

Argue

Refer

	Sairam. M \| Argues in support of "SQL SERVER" \| 1 year ago
	SQL SERVER IS BEST WHEN COMPARED TO ORACLE, BECAUSE IT SUPPORTS ACTIVE DIRECTORY. IN SQL SERVER WE CAN CREATE 2 TYPES OF USERS (STRUCTURED QUERY LANGUAGE) SQL USERS AND ACTIVE DIRECTORY USERS. CENTRALIZED ADMINISTRATION IS POSSIBLE, BACKUP AND...

	Abhishek Tiwari \| Argues in support of "ORACLE" \| 1 year ago
	This depends on the project requirement..both are better in current market...peoples who are familier with SQL they always prefer SQL server. and oracle professionals are always with ORACLE DB.

	Arunkumar \| Argues in support of "SQL SERVER" \| 1 year ago
	SQL Server is better than oracle.I can justify myself by the following bullet points, One of the main Microsoft SQL Server 2000 advantage in comparison with Oracle 9i Database is that SQL Server is cheaper . Other SQL Server advantage is that...

Debate: "SQL SERVER 2008 OR ORACLE...Which is better?" deleted from your view.

i have knowledge of SQL SERVER 2005 & ADO.net

(rate this)

SQL SERVER &ADO.net

C, CORE JAVA

View all 3 arguments

Argue

Refer

	sameer kamble \| Argues in support of "SQL SERVER &ADO.net" \| 1 year ago
	Hi pravin, Sql server is for database and java is a programming language. how can we compare this. both imp

Debate: "i have knowledge of SQL SERVER 2005 & ADO.net" deleted from your view.

i tried to install Microsoft sql server, bt der is a error tat, Microsoft sql native client required,,,, whr can i get it??

(rate this)

Add answer

Answer

Refer

Answer: "i tried to install Microsoft sql server, bt der is a error tat, Microsoft sql native client required,,,, whr can i get it??" deleted from your view.

Prev1NextShowing 1 - 6 of 6

Other knowledge matching "SQL Server 2005/2008 Profiler" topic

Add to this topic

I am associate of prajapati association and i am working for BJP from year 2005 to till date. and i want that our prajapati

	Posted by: Political associate, Prajapati Association village- Puraina Post -Noorpur Dist. -Bijnor (UP)-246734 Mobile-+91 9719492606 Activity: 0 referals , 3 arguments, 293 views
	I am associate of prajapati association and i am working for BJP from year 2005 to till date. and i want that our prajapati cast progress is continue. so please help me all prajapai ( Kumhar) in india.