Search Results | SQL Server Performance Forums

AWE memory settings for SQL Server.

Thread by: LucasDa, Apr 13, 2010, 5 replies, in forum: SQL Server 2008 General DBA Questions

Hi, I have a dedicated server for SQL Server that has 18GB of memory available. The SQL Server is configured with a maximum of 4GB memory. I would...

A new structure of permissions.

Thread by: LucasDa, Apr 7, 2010, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hi, my Name is Lucas and need help in SQL. . . . I'm working in a company where the DBA position is new, this company has never had a DBA. For this...

Insert 300 millon of recods

Thread by: LucasDa, Nov 16, 2009, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi...! I need to insert in a Table the result of a Query that descrive below: SELECT Campo1, Campo2, Campo3 FROM TableUno CROSS JOIN TableDos CROSS...

The size of a row.

Thread by: LucasDa, Oct 12, 2009, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I need help or some advice about How can I calculate the size of a row? or How can I do a proyection of the space need for a DB in the time (6...

Replace "Is not null" clause in "Where" to use Index.

Thread by: LucasDa, Jun 25, 2009, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi. I have one question. I need improve one Query, this query have a clausule WHERE with fileds to behave against "IS NOT NULL". The question is,...

Question About NOT EXISTS and IS NULL (or IS NOT NULL)

Thread by: LucasDa, Jun 9, 2009, 4 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi. I need some advices about the clauses NOT EXISTS and IS NULL or NOT NULL. If I have a statement with in the clause WHERE have a field (or a lot...

Index on column DATETIME.

Thread by: LucasDa, Jun 9, 2009, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi. I have two question about the Index in SQL 2005. First Question. At some point I hear that not it's good have or Create an Index on a column the...

Rebuild error.

Thread by: LucasDa, Feb 17, 2009, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi!!! I need help with the instrucction REBUILD. I have this SP: CREATE PROC [dbo].[DBA_Reindex] ( @db_name VARCHAR(100) ) AS SET...

Security Profile for a DBA.

Thread by: LucasDa, Jan 20, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi!! I have a query in relation to the allocation of permits for a DBA. When a new DBA enters in the company, What is the most appropriate security...

Dashboard - Script - Application

Thread by: LucasDa, Jan 15, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi, My name is Lucas. In this moment I am doing tasks of DBA (in SQL Server 2005) for a new Company. My first task in the Company is perform a...

DBA Morning Check List

Thread by: LucasDa, Dec 1, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi!!!. My name is Lucas and I'm new in the DBA field. In the company where I 'm working the boss ask me for a Creation a Morning Check List for 3...

Reindexar - Defragmentar - Fragmentar.

Thread by: LucasDa, Nov 18, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi!! I have a problem with the SQL Server 2005. At times this shows me an error out of Time Out. The client tell me the and now I need to analyze the...

What is the process of restarting the SQL Server 2000?

Thread by: LucasDa, Nov 17, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi!!. I have some problem with the SQL Server 2000 and Sessions. For this, I need to know " What is the process of restarting the SQL server? ". I...

Problem with Restore.-

Thread by: LucasDa, Nov 14, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi,I have a new problem with SQL 2000/2005. The problem is:I have a notebook in wich I have been installed SQL 2000 and SQL 2005. The architecture of...

Consultation

Thread by: LucasDa, Nov 14, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi, My name is Lucas and I need to make a query. Three months ago I changed my job. In my old job I did programming in SQL 2000 and now I'm DBA for a...

Help!! with Transact SQL

Thread by: LucasDa, Sep 25, 2008, 2 replies, in forum: General Developer Questions

Hi!!, My name is Lucas and I have trouble with 3 points from a test. The problems are: 1- Get all employees who worked every day from 01-05-2006...

Problem with Data Base AdventureWorks.

Thread by: LucasDa, Jun 19, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

My name is Lucas. I work in a Company programing in Transact-SQL and I'm learning Reporting Services 2005. For learn Reporting Services I read in...