If you want to kill it use : Kill

forgive grammar and typos ...i wrote it in haste ..

Regards.

Adding to What Gail has said :

In Auto update statistics the statistics change occure when the optimizer finds that he query is using the stale Stats , thus creating the...

First use : sp_repldone

This will mark the transactions as complete .

after that check the status column in dbcc loginfo .see if there are any 2's at the bottom .Plus...

Gail, the number of therads that are working are 8 but the 9th one will be the one consolidating the records and giving the output .

So 0 through 8...

This is because of parallelism .

If you right click on say index seek symbol and select properties , you will find that this query is creating 9 worker threads .

Each...

If you are on SQL Server 2000 then setting up max server memory before enabling AWE is required sice we do not have dynamic AWE settings .So as soon as...

Note : you wont be able to detach the database without taking it to emergency .It will complain about the mising log file.

Regards

Here is your answer my friend :

1)alter database test set emergency

2) we use to use this command in 2000

dbcc rebuild_log ('test','C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_log.ldf')

This will give you an error...

Hi,

1.How the processor licensing works in SQL Server 2005 Enterprise edition and Standard ?

Abhay: Its per physical CPU based as well as monthly charges based .There might be some...

add another column as flag (values 0 or 1) in the main table .

-> Create a cursor that inserts the values from you main table to the temp table having...

the other alternative is using SSIS packages.

Regards

Well at one time you cannot have 2 databases with same name .

So in your case you have restored the database on the different instance of SQLserver .

make sure that...

The graph in a Simplified way

---------------------------------

Node:1

---------

Owned By :

------------

Owner SPID: 55

Owner:0x0577BD40

Life:00000000 <- 0 seconds

XactLockInfo: 0x069BEFB4

PAGE: 17:1:102945 <-- databse 17 file 1 page 102945

Statement Type: SELECT

Mode: S

Object Id = 1807761943

Requested...

1)

When you are running this select the locks are created on the set of rows /Pages /Extents or entire table .This is because you are using * .I do not...