Search Results | SQL Server Performance Forums

Take a look at an article i just published - How to disable Lock Escalation at table level :)

Thread by: Netic, Apr 18, 2011, 1 replies, in forum: SQL Server 2008 General DBA Questions

Take a look at an article i just published - How to disable Lock Escalation at table level...

Run SSIS Packages in SQL SERVER 2005 x64 with Jet4 OleDB connections (eg:excel)

Thread by: Netic, Apr 8, 2011, 1 replies, in forum: SQL Server 2005 Integration Services

Run SSIS Packages in SQL SERVER 2005 x64 with Jet4 OleDB connections (eg:excel)...

Run SSIS Packages in SQL SERVER 2005 x64 with Jet4 OleDB connections (eg:excel)

Thread by: Netic, Apr 8, 2011, 1 replies, in forum: SQL Server 2005 General DBA Questions

http://www.citen.net/2011/04/08/run-ssis-packages-in-sql-server-2005-x64-with-jet4-oledb-connections-egexcel/

Algorithm to calculate resources used by index rebuild and index reorganize.

Thread by: Netic, Aug 7, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hello. Is there any algorithm to calculate resources (storage/tempdb/datafiles/transaction log) used by index rebuild and index reorganize processes....

SQL SERVER 2000 BUG !

Thread by: Netic, May 12, 2008, 2 replies, in forum: General DBA Questions

Thanks in advance in reading this post ! I'm facing a situation in sql server 2000 sp4 with partitioned views. I have a partition views that joins...

No transaction is active.

Post by: Netic, May 5, 2008 in forum: SQL Server 2005 General Developer Questions

Roshan, What are the Transaction Statistics & DTC LOG C:Windowssystem32MSDtc (Default Path). By the way... are there any Firewalls in the middle ?...

Huge transaction log size even after truncate and shrink

Post by: Netic, May 5, 2008 in forum: Performance Tuning for DBAs

JRMTL, Keep in mind, that all transactions go trough the transaction log. If poorly designed transactions or natural large transactions are issued...

No transaction is active.

Post by: Netic, May 5, 2008 in forum: SQL Server 2005 General Developer Questions

That is a differente issue ! Configure the Microsoft Distributed Transaction Coordinator and check that it is up n' running ! When you are...

No transaction is active.

Post by: Netic, May 5, 2008 in forum: SQL Server 2005 General Developer Questions

Howdy, the BEGIN TRAN should be inside of the BEGIN TRY ! Best regards, Paulo CondeÃ§a.

Dataware Performance Degradation - Urgent Situation.

Post by: Netic, Apr 3, 2008 in forum: General DBA Questions

Already Run Profiler, everything seems normal. I'm going to enquire IT today, to find if the server had a AV update/upgrade, and check for new...

Dataware Performance Degradation - Urgent Situation.

Post by: Netic, Apr 2, 2008 in forum: General DBA Questions

Thanks for the feedback. That maintenance is done on Sundays. More help would be appreciated :)

Dataware Performance Degradation - Urgent Situation.

Thread by: Netic, Apr 2, 2008, 5 replies, in forum: General DBA Questions

Thanks in advance ! We are having a situation (PROBLEM) with our DW - SQL SERVER 2000 SP4 ENT X86, it suddenly slowed a lot. CPU Usage : 20% IO : AVR...

BIG SSIS PACKAGE (200 PLUS DATAFLOWS & VALIDATIONS) ISOLATION

Thread by: Netic, Mar 29, 2008, 1 replies, in forum: SQL Server 2005 Integration Services

Thanks in advance in reading this thread. I have developed a big SSIS package to extract data from flat-files ( + 200 Dataflows ). The situation is...

help with this script plz

Post by: Netic, Jan 16, 2008 in forum: SQL Server 2005 General DBA Questions

You can create a cursor that sweeps the sysdatabases. My example will return all user databases:declare @dbname varchar(50)declare @ocorreu_erro...

Monitoring User activities on database

Post by: Netic, Nov 23, 2007 in forum: General DBA Questions

Sonny, You have to be a little more precise... Do you want to save all sessions data(example : IO/CPU) every 15 minutes? Best Regards, Paulo CondeÃ§a

Log Shipping Problem, Out of Sync

Post by: Netic, Aug 21, 2007 in forum: SQL Server Log Shipping

LS007, The best practice is to use only one of the tools. Best Regards.