Search Results | SQL Server Performance Forums

MAPI ERROR

Thread by: cejar, Jan 8, 2004, 6 replies, in forum: General DBA Questions

For some reason I cant get SQLMail or Agent Mail to work on one of my servers. I have intalled an uninstalled Outlook, created and recreated Mail...

Distributed Transactions

Thread by: cejar, Jan 6, 2004, 5 replies, in forum: General DBA Questions

I am trying to run a transaction that across two servers DTC is running and the servers are linked to one another still I get this message when I run...

ERwin 4.0 Naming Standards

Thread by: cejar, Dec 24, 2003, 1 replies, in forum: Third Party Tools

I am forward Engineering a datamodel from Erwin. When I script it out to a file I want to create a PK as a clustered Index with my own naming...

DBCC Inputbuffer

Thread by: cejar, Dec 17, 2003, 14 replies, in forum: General DBA Questions

On Current Activity in EM I keep seeing a process for DBCC Inputbuffer thats comming from my machine. Why is this popping up if Im not executing no...

Composite Pkeys

Thread by: cejar, Dec 16, 2003, 6 replies, in forum: Preguntas sobre SQL Server en EspaÃ±ol.

Â¿Hay una buena razÃ³n por la que un revelador debe crear un PKey compuesto? Estoy mirando una base de datos con muchos de Composite Pkeys que se...

Viso 2000

Thread by: cejar, Dec 16, 2003, 6 replies, in forum: Third Party Tools

Has any one created a database using Viso. How well do all the features work when it comes time to generate the database from the Model? Are there...

Profiler Traces

Thread by: cejar, Dec 16, 2003, 7 replies, in forum: Performance Tuning for DBAs

Which event categories and columns should I capture in SQL Profiler for ITW to perform a meaningful analysis on queries? Cheers!

Find Orphan Records

Thread by: cejar, Dec 15, 2003, 15 replies, in forum: General Developer Questions

Does anyone have any SQL scripts to find all Orphan records in a givin table? Cheers!

Paralle Queries

Thread by: cejar, Dec 11, 2003, 9 replies, in forum: Performance Tuning for DBAs

What is the best method to identify Parallel Executions? Do I have to turn MAXDOP on to run these monitores? Cheers!

Parallelism

Thread by: cejar, Dec 4, 2003, 7 replies, in forum: Performance Tuning for DBAs

On one of my servers, while completing an audit I noticed that it only utilizes one processor when infact it physically has two. This server has a...

DBCC DBREINDEX

Thread by: cejar, Dec 3, 2003, 5 replies, in forum: General DBA Questions

I ran DBCC SHOWCONTIG before and after a REINDEX on a table and got back the same results. Here are the results I got back after DBCC DBREINDEX....

When was index created?

Thread by: cejar, Dec 2, 2003, 9 replies, in forum: General Developer Questions

Does any one know of a way to find out when the indexes where created? I don't think sp_help can can help with this. A script that can report a list...

Determine the size of tables

Thread by: cejar, Nov 28, 2003, 7 replies, in forum: General Developer Questions

Is there a way I can query a DB to find out which are the biggest tables in it? Cheers!

encript dts package

Thread by: cejar, Nov 26, 2003, 5 replies, in forum: SQL Server DTS-Related Questions

Is there a way I can encript a DTS package? Cheers!

Error message Max tables exceeded 256

Thread by: cejar, Nov 6, 2003, 11 replies, in forum: Performance Tuning for DBAs

I'm getting this error message when I run a an SP. I'm query off views that join to multi tables but I know that they dont exeec 256. Here is the...

Spanish Terminology for SQL Sever

Thread by: cejar, Oct 31, 2003, 4 replies, in forum: Preguntas sobre SQL Server en EspaÃ±ol.

Hola a todos! Deseo traducir una cierta terminologÃa del SQL Server en espaÃ±ol. Deseo ser intune en cÃ³mo la referencia de DBA/Developers se opone...