Search Results | SQL Server Performance Forums

Directory for Databases

Thread by: najeed_dba, Sep 21, 2007, 8 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Need Some Adviceâ€¦ Current Setup of the Databases: All â€œsystem databasesâ€ + â€œreportserver & reportservertempdbâ€ are on â€œ D...

Granting Sql Agent job permission to only one job

Thread by: najeed_dba, Aug 22, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, Does anyone know how can we grant a user access to only one particular job( Existing job), out of many jobs. So, that he can use that...

Integer in Varchar Columns

Thread by: najeed_dba, Aug 20, 2007, 17 replies, in forum: SQL Server 2005 General Developer Questions

Hi all. I have some integer data in a table which is enclosed in double quotes. But, I want to perform some sum(), avg() function on those columns,...

Dropping indexes before bulk insert

Thread by: najeed_dba, Aug 16, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Need some advice. I have a huge table 170 Gb of size. On that table we have 10 indexes of around 12 GB in size. The application is designed...

AWE is not getting enabled.

Thread by: najeed_dba, Aug 15, 2007, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi all , Need some help... We enabled /3GB Switch from boot.ini file,and then reboooted the server and then I try to enable from SQL Server...

Alerts, Thresholds & Database Mail

Thread by: najeed_dba, Jun 24, 2007, 1 replies, in forum: Getting Started

Hi All, Actually i m new in sql server administration. And i m in the process of building our production box with sql server 2005. ( win 2003 std )...

Reports in Excel

Thread by: najeed_dba, Jun 12, 2007, 6 replies, in forum: SQL Server 2005 Reporting Services

Hello all, Actally i posted this topic under Reporting Services section, but no reply there, so i m removed from there and posted here....

MDF Integrity

Thread by: najeed_dba, Jun 7, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Is there any way to check the integrity of .Mdf file before Attaching it to a database means to check whether its valid (or) not....

Reporting Services

Thread by: najeed_dba, Jun 6, 2007, 1 replies, in forum: SQL Server 2005 Reporting Services

Hi all, If we restore the backup of ReportServer and ReportServerTempdb databases ( and other database which reports are accessing) from primary...

Full and Differential Backup

Thread by: najeed_dba, Jun 6, 2007, 8 replies, in forum: SQL Server 2005 General DBA Questions

Hi all , Is there any way to restore a differential backup when the database is running means its online. Means i restored the full...

SSRS Book Ref.

Thread by: najeed_dba, May 9, 2007, 1 replies, in forum: SQL Server 2005 Reporting Services

Hi all, I am new to SQL Server 2005 Reporting Services. Can somebody advice any good book (or) any good online resources. Thanks in...