1) which edition of sql you are running ?

2) maybe you should read this: http://support.microsoft.com/kb/918483/en-us

and you may need this:

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/06/20/sql-server-2005-sp3-cumulative-update-4-is-available.aspx

there are some problems with swaping sql's...

can you show us your clustered index ? if the key is Id - maybe it shouldn't - it depends on your queries

i think that you should create following index:

create...

sory but what does it mean: "lakhs" ?

maybe you can use Transactional Replication ?

this will be very hard achive this goal ;/

in SQL 2008 you can use CDC/CDT (Change Data Capture or Change Data Tracking) - maybe you can use these?

yes - there is a simple way to do that 😉

1) create a script to backup your database

2) learn how to use osql to fire it

3) use task...

why not a ssms ? its really nice pieace of software ?

fragmentation in which layer? files on file system or objects in database?

Do you have problems with disk space ? If not you only need to execute some index rebuilds and nothing more.

If you have disk space problem .... threre are no...

creating objects on your new filegroup looks like this:

create table MyGreatTable (i int) on MyGreatNewFileGroup

dbcc inputbuffer shows only first 256 signs of the query, you can see whole query using following code:

select t1.session_id, t2.text from sys.dm_exec_requests t1 cross apply sys.dm_exec_sql_text(sql_handle) t2

where t1.session_id =...

Sergiy - the paragrah you mentioned change nothing. hash is a hash - and for a given string should always return the same value. did you try to run his...

Paul ... but here you have a "special" index on field: any_date_year AS YEAR(any_date) so 😉

but sql can handle with this optimization in very elegant way - it is...

Paul White (9/6/2009)Best practice is to respect the parameter data types to avoid implicit conversions as far as possible:

EXEC [dbo].[sp_BackupAllFull]

...

You should read this position too: Tuning IBM System x Servers for Performance you can find there a lot of information about hardware, Windows and SQL Server. I always recommend...