Search Results | SQL Server Performance Forums

What are the reasons why Database Mirroring cannot be used for system databases?

Thread by: pcsql, May 4, 2009, 1 replies, in forum: SQL Server 2005 Database Mirroring

I just want to know the reasons why Database Mirroring cannot be used for system databases.

How to set up SQL Web Data Administrator in Windows XP?

Thread by: pcsql, May 2, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

I have downloaded SQL Web Data Administrator from CodePlex and unzipped the files. The setup instructions in CodePlex are not quite clear. I cannot...

Is there a way to configure Activity Monitor?

Thread by: pcsql, Oct 9, 2008, 1 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

I'm using SQL Server 2008 RTM and connecting to SSMS as sa. The SQL Server 2008 Activity Monitor is missing some columns such as host, net library,...

Is there any function or system view to show connection pooling setting?

Post by: pcsql, Oct 9, 2008 in forum: SQL Server 2005 General DBA Questions

Adriaan, Your understanding about connection pooling seems to be same as mine. The reason that I'm interested in whether a connection is connected...

Is there any function or system view to show connection pooling setting?

Thread by: pcsql, Oct 8, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

How can I find out whether a connection is connected with connection pooling enabled?

How to truncate log in SQL Server 2008?

Post by: pcsql, Oct 2, 2008 in forum: SQL Server 2008 Questions [Archive Only - Closed]

Hi ghemant, My goal is just to free up log space. The backup log with truncate_only does exactly that. I'm doing a mass data manipulation of all...

How to truncate log in SQL Server 2008?

Thread by: pcsql, Oct 1, 2008, 9 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

I want to replace the coding Backup Log with Truncate_Only in a sql script. If I understand correctly, I need to do the following: alter database...

Difference among functions like original_login, system_user

Post by: pcsql, Sep 17, 2008 in forum: SQL Server 2005 General DBA Questions

Hi Satya, I don't have any problem using them in 2005 and 2008. I just want to make sure that I understand them correctly since all those functions...

Difference among functions like original_login, system_user

Thread by: pcsql, Sep 16, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

I'm trying to understand the differences among the following functions: Functions returning login original_login() - original login name not...

Can SQL Server Profiler use to trace which filegroup is used?

Thread by: pcsql, Sep 11, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Can I use Profiler to trace which filegroup is used? I'm trying to trace which filegroup is used for a table which is partitioned using partition...

What are different ways to find out the permissions granted to a particular user?

Thread by: pcsql, Sep 4, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Besides using sp_helprotect, what are other system functions/system stored procedures/system tables/system views that I can use to find out granted...

Which SQL Server 2005 Exams are corresponding/similar to 70-450?

Post by: pcsql, Aug 26, 2008 in forum: SQL Server 2008 Questions [Archive Only - Closed]

Hi moh_hassan20, Since 70-450 is a new test, I'm thinking to base my study on 70-431, 443 ,444 unless I can find practice test for 70-453 and/or...

Which SQL Server 2005 Exams are corresponding/similar to 70-450?

Thread by: pcsql, Aug 26, 2008, 2 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

I want to take some practice tests for 70-450. I don't think there is any yet. Which SQL Server 2005 Exams I should take as practice tests for...

What permssions/roles to be assigned to a database user who is in charge of jobs?

Post by: pcsql, Aug 22, 2008 in forum: SQL Server 2005 General DBA Questions

Hi ghemant, I have tried all 3 SQLAGENT roles. It seems that those roles won't give permission to select the msdb..sysjobs and other system tables...

What permssions/roles to be assigned to a database user who is in charge of jobs?

Thread by: pcsql, Aug 21, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

I want to assign permissions/roles to a login who is in charge of creating, maintaining, and executing jobs. The login is the dbo of a database on...

SQL Server 2008 new data types and Entity Framework

Thread by: pcsql, Jun 16, 2008, 1 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

Does anyone have a list of SQL Server 2008 new data types that will not be supported by Entity Framework?

SQL Server 2008 Certifications

Post by: pcsql, Jun 12, 2008 in forum: Greg Larsen's Blog

How can I take the beta exam? Does this link http://www.microsoft.com/learning/mcp/sqlvs/offer/default.mspx apply to beta exam?Thanks.

SQL Server 2008 RC0 is out

Post by: pcsql, Jun 9, 2008 in forum: SQL Server 2008 Questions [Archive Only - Closed]

Does the RC0 include the SQL Server Audit feature? Thanks.

SQL Server 2008 Jumpstart Event Dev Training Now Online

Post by: pcsql, Jun 4, 2008 in forum: SQL Server 2008 Questions [Archive Only - Closed]

Hi Jason, I have copied the sections from Developer track below so you can see what I'm referring to. I'm starting to download the Recordings from...

SQL Server 2008 Jumpstart Event Dev Training Now Online

Post by: pcsql, Jun 3, 2008 in forum: SQL Server 2008 Questions [Archive Only - Closed]

Hi Jason, The site looks quite different from few weeks ago. Do we need to download both the LATEST Metro section and the All section in each track?...