There are many.

I tried finding few on net.

http://www.cmswire.com/cms/industry-news/sql-server-2008-released-heres-the-skinny-002993.php

http://www.simple-talk.com/sql/learn-sql-server/management-studio-improvements-in-sql-server-2008/

There must be a job created for the backup maintenance plan. Check for the job history for that job. Also click on the (+) sign before the job name which...

Please post DDL scripts for tables with sample data and desired output.

Here is help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

SELECT DB_NAME(tl.resource_database_id) AS DatabaseName, tl.resource_type, tl.request_mode, tl.resource_associated_entity_id ,

tl.request_session_id 'who_session',who_es.program_name 'who_program', who_es.nt_domain 'who_nt_domain', who_es.nt_user_name 'who_user_name', who_es.login_name 'who_login_name',

wt.blocking_session_id 'blk_session',bl_es.program_name 'blk_program', bl_es.nt_domain 'blk_nt_domain', bl_es.nt_user_name 'blk_user_name', bl_es.login_name 'blk_login_name',

request_owner_id 'transaction_id', wt.resource_description

FROM sys.dm_tran_locks as...

The table script u gave in ur first post defines Quantity as Integer.

I modified the column by running

alter table reorderS alter column Quantity decimal(10,2), you can increase the precision (here...

You may also want to go through Gail's article on managing transaction logs.

http://www.sqlservercentral.com/articles/64582/

try increasing log backup frequency.

sys.dm_os_waiting_task gives details of waiting task and sys.dm_tran_locks DMV gives detailed on locking tasks.

am trying to join these two views to get processes waiting due to a lock placed on...

http://support.microsoft.com/kb/271509 has detailed query to find blockings.

Also master.sys.dm_tran_locks is a dymamic view that provides information about locks and blockings.

http://www.mssqltips.com/tip.asp?tip=1359

you need to install sql server express edition on ur windows box, create a database, database objects(tables/views/sps) and then start using it.

from your application, you need to connect to the...

I'm not too sure but bigint will require 8 bytes for storage per record where as varchar(50) will take up 50 bytes of storage, in this case storage requirements of...

I dont understand what's the point in changing the name?

anyways u can be identified easily.

5 mins and 2 names in the new id!!

Am happy i was of some help 🙂

:crazy:

🙂 Glad you remembered that important step!!