Suresh B. (11/3/2011)

crazy4sql (11/3/2011)

Points to be considered :-

1) Must have enough space at new location for...

Hi All,

Thanks for your valuable inputs

Regards - Deepak

Nice question thanks 🙂

Hi Stewart,

Thanks for your quick reply , i have few questions here ,

> If the database is invloved replication (in my case it is transactional replication and transactional replication with...

can you share that excel file ?

Thanks For this article excellent explanation 🙂

As steve mentioned SSIS is the good way to do this. if you go with linked server approach you will face some performance issue while copy data from across the...

Hi Lowell ,

how to check the index creation for non -PK or Unique Key , example non-clustered index creation index date or filtered index or XML index ....

Thanks & regards

Deepak.A

hi,

SSAS services running properly and also alll the component are installed.

Regards -Deepak.A

One more information I'm using 64 Bit machine, operating system windows 7

Regards - Deepak.A

Currently i'm using 2005 , we are palnning to use 2008 so to learn and understand the new...

nice question , it depends on ansi_nulls settings

Statement 1 -

set ansi_nulls off

SELECT CASE COL1 WHEN NULL THEN 'Is Null'

WHEN '0' THEN 'Is Zero'

WHEN '1' THEN...

Is there anything new in SQL 2008 R2 ?

What are those additional components ?

Do you want to make Http connection string as dynamic ? if so use package configuration

Regards - Deepak.A