Hi,

Check thoses links:

http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm --Best in my opinion

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1225335,00.html

http://www.devx.com/dbzone/Article/11363/0/page/3

Regards,

Ahmed

Hi,

http://www.sql-server-performance.com/tips/dbcc_commands_p2.aspx

http://articles.techrepublic.com.com/5100-9592_11-6142604.html

Regards,

Ahmed

Hi,

In SQL 2000 Standard Edition, SQL Server uses a max of 2G.

Check the following article http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

Regards,

Ahmed

Hi,

I think you want this,

SELECT *

INTO #proj

FROM PROJ WHERE proj_start_dt IS NULL OR proj_end_dt IS NULL;

CREATE CLUSTERED INDEX #proj_ci ON #proj(proj_id DESC)

BEGIN TRAN

DECLARE @Dummy smalldatetime,

@id VARCHAR(50),

@dt...

Salam,

--1 -- Table info

create PROCEDURE Generate_getDataDictionary

AS

DECLARE @table_name nvarchar(128)

CREATE table #tblDataDictionary

(table_name [sql_variant],

column_order [sql_variant],

column_name...

Hi,

Your table B was empty so when you run the following command, the new identity will start with a value of 0

delete from B

DBCC CHECKIDENT (B, RESEED, 0)

When you DBCC...

Hi,

Total Server Memory (KB), tells you how much the mssqlserver service is currently using. This includes the total of the buffers committed to the SQL Server BPool and the OS...

Hi,

Thanks I will download the trial and try it.

Thanks again.

Hi homebrew01,

Is there any overhead on SQL Server when using the Idera tool.

Thanks.

Hi,

Yes it does.

Check the following links

http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/

http://www.databasejournal.com/features/mssql/article.php/3399241

Regards,

Ahmed

Hi,

You can also check theses links

http://www.sqlmag.com/Article/ArticleID/95728/sql_server_95728.html

http://khsw.blogspot.com/2004/08/decrypt-stored-procedures-on-sql.html

http://www.sql-shield.com/decrypt-stored-procedure.html

http://www.sqlmag.com/Article/ArticleID/14369/How_can_I_decrypt_a_SQL_Server_storedprocedure.html

Regards,

Ahmed

Hi,

Check the following post http://www.sqlservercentral.com/Forums/Topic358239-146-1.aspx

Regards,

Ahmed

Hi,

You have to be member of sysadmin fixed sever role.

Check the link http://technet.microsoft.com/en-us/library/ms191002.aspx

Regards,

Ahmed

Hi,

In my opinion let the software (your program) process the XML (retreive the children and for each create columns) before saving it whitin the table.

If you save the XML...

Hi,

HAVING was added to SQL because the WHERE keyword could not be used against aggregate functions (like SUM), and without HAVING

it would be impossible to test for result conditions....