Search Results | SQL Server Performance Forums

Transaction Log file Full with checkpoint

Thread by: Fais, Feb 24, 2010, 5 replies, in forum: SQL Server 2005 General DBA Questions

This is related to SQL Server 2005 Enterprise edition. One of the database log file is 100 % full and its log_reuse_wait_desc = CHECKPOINT ( from...

Post Partitioning Problems

Thread by: Fais, Feb 10, 2010, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hello, I have implemented partitioning for the first time. Requirement is to have partition by weeks. So each partition have around 25 million rows...

Cannot able to see Windows Group account in Linked Server security page

Thread by: Fais, Dec 11, 2009, 3 replies, in forum: SQL Server 2005 General DBA Questions

I am trying to add windows group ( MYDomainlogin) to the Linked Server security page, but when I click add --> then browse to find the windows group...

Capture Inserts, Updates , Deletes

Thread by: Fais, Dec 9, 2009, 5 replies, in forum: SQL Server 2005 General DBA Questions

One of my colleague wanted to know , how often changes are performed against Table_A, Table_B , Table_C in production. Here are some more details ,...

Combine data from two columns into one column

Thread by: Fais, Oct 19, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

I have a scenario wherein I have to combine two columns into one . Its SQL Server 2005 Below is the example : CREATE TABLE Table_Source (...

After schema update , Replication is breaking without raising error

Thread by: Fais, Jul 13, 2009, 2 replies, in forum: SQL Server 2005 Replication

This is SQL Server 2005 Transactional replication configuraiton. I am modifying the table schema at publisher by adding addtional columns on...

How to insert into table in chunk of 5000 rows at a time

Thread by: Fais, May 15, 2009, 3 replies, in forum: SQL Server 2005 General Developer Questions

I would like to do inserts into my destination tabel in chunk of 5000 rows at a time because source table can have milions of rows and I dont want to...

Stopping Delete at Subscriber

Thread by: Fais, May 5, 2009, 1 replies, in forum: SQL Server 2005 Replication

Hi all, 1) If I dont want 'Delete' statements to propagate to subcriber.........What needs to be done, when creating new publication (or) modifying...

Snapshot agent not applying snapshot if @sync_type = N'replication support only'

Thread by: Fais, Apr 23, 2009, 1 replies, in forum: SQL Server 2005 Replication

All~, Is it true that , if a subscription is created with parameter @sync_type = N'replication support only' , then even if we generate a new...

Snapshot agent not applying snapshot if @sync_type = N'replication support only'

Thread by: Fais, Apr 23, 2009, 1 replies, in forum: SQL Server 2005 Replication

All~, Is it true that , if a subscription is created with parameter @sync_type = N'replication support only' , then even if we generate a new...

Monitoring replication

Thread by: Fais, Apr 14, 2009, 1 replies, in forum: SQL Server 2005 Replication

Hi All, I configured Transactional replication on my staging server and will be configuring transactional replication on Production as well. I...

SQL Server 2005 SP3 failed

Thread by: Fais, Apr 8, 2009, 7 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, I am installed sp3 + cu1 on one of my servers , it was successfull. But ,I tried to install this on my other server it failed with the...

Openrowset with cross server connection

Thread by: Fais, Mar 25, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I am trying to run a stored procedure by passing a parameter BY using openrowset. Note: I am running below query FROM Datasrv2 . Datasrv1 &...

Tablediff workaround with different schema

Thread by: Fais, Feb 27, 2009, 1 replies, in forum: SQL Server 2005 Replication

I am trying to use Tablediff utility to compare publisher and subscriber tables. The problem is : At Publisher side : we have Table_A & Table_B. At...

Data archiving

Thread by: Fais, Feb 24, 2009, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hello All, I am trying to archive data from OLTP database into Archive database. Below is the procedure which I am using currently. In this...

Server Migration with replication

Thread by: Fais, Jan 16, 2009, 1 replies, in forum: SQL Server 2005 Replication

Hi All, I am in the process of moving our database server onto new hardware . Some of the databases on old server are involved in replication. So...

2005 Standard to 2005 Enterprise

Thread by: Fais, Jan 8, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

We have SQL Server 2005 Standard editon 9.0.3042 (64-bit) installed and I would like to upgrade it to Enterprise Edtion. This will be In-Place...

Convert CASE expression to Outer Join.

Thread by: Fais, Nov 10, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, I am trying to convert this particular code to newer sql syntax that uses Outer joins. I did few but having problems with this one. I also...

Converting Ansi Outer join to Newer Outer join

Thread by: Fais, Oct 23, 2008, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi all, I am trying to convert some Ansi sql code ( OLD Version ) to new version of sql for compliance with SQL Server 2005 code. (Ansi SQL ( OLD...

Rebuilding index for ALL User databases in SQL Server 2000

Thread by: Fais, Oct 15, 2008, 1 replies, in forum: General DBA Questions

Hi all,I have this stored proc from BOL for sql server 2000. In order to use this stored proc. I have to execute this procedure separately against...