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...
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...
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...
FrankKalis, Thank for the response. But the info in the Book Online it's very limited or general for E.g. the book online says ........ to calculate...
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...
Thank for the response. I have been working on the Query but the performance not improve. My query is the follow:SELECTA .AccountID, A.ConcessionID,...
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,...
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...
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...
Hi!!! I need help with the instrucction REBUILD. I have this SP: CREATE PROC [dbo].[DBA_Reindex] ( @db_name VARCHAR(100) ) AS SET...
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...
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...
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...
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...
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...
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...
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...
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...
Good Morning Luis. The sequence of command was executed in SQL Server Management Studio and shows the error before shown.
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...
Separate names with a comma.
