Hi Jeff,

What a good one, thanks for explaining this. If you don't mind, where can I find the 'Smart' Index?

'Lookup the topic in Books Online on the DMV sys.dm_db_index_physical_stats....

I was trying to download Idera: SqlSafe but it said 'Trial' . Are you sure is that full operational?

Anyway that is the great software for someone who got SQL...

Hello,

This is for Production System. Shall I rebuild the index every once a week and run the full backup every day? I set the datatabase at Full Recovery Mode so...

Hello lynn,

Here is what I am trying to accomplish......

I have a table called 'SALES' Table which is getting new sales records transaction in every single seconds.

I want to write...

First of all thaks to Lynn and Tim,

Tim,

what do you mean 'locked table and not write to it, you can consider adding 'with (nolock)' to the reading transaction that...

CREATE TRIGGER dbo.Write_TEST_NEW ON dbo.TEST

FOR INSERT

AS

IF @@ROWCOUNT = 0RETURN

DECLARE @tbl_TEMP_TEST_TABLE TABLE( RowID int IDENTITY(1, 1),

Param1int,

Param2int,

Param3nvarchar(30),

GenTimedatetime)

DECLARE @ctr_TEMP_TEST_TABLE_CURRENTCOUNTER int , @ctr_TEMP_TEST_TABLE_MAXCOUNTER int

INSERT @tbl_TEMP_TEST_TABLE

SELECTParam1,

Param2,

Param3,

GenTime

FROMINSERTED

SELECT@ctr_TEMP_TEST_TABLE_CURRENTCOUNTER = MIN(RowID),

@ctr_TEMP_TEST_TABLE_MAXCOUNTER = MAX(RowID)

FROM@tbl_TEMP_TEST_TABLE

WHILE (Not @ctr_TEMP_TEST_TABLE_CURRENTCOUNTER...

Hi,

I am using FOR INSERT.

Thanks.

Leo

Hello again,

Right, you need to create the new database called DB2 in SQL Databases. That will create the shall of the DB2 database for you. To do this, right click...

Yes, that can be done. Create the new database on the Server, then restore the backup file which is DB1*.bak.

Go to Option Tab when you restore and before you...

Hi aries76,

Normally port number is 1433 but sometime they changed the port number for the security reasons. Also if you have a dedicated server then you might need to...

Hi,

You can try the following if you already installed SQL Management Studio for 2005 -

1. Detach the database in SQL 2000

2. Copy it into c:\xxx\microsoft sql server\MSSQL.1\Data\*.mdb (and) *.ldb

3. Open...

Hi,

You need to install Microsoft SQL Express Management Studio Express to manage the database and maintenance.

You can download from the link below.

http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Let me know if you have any...