I have implemented TDE at Database. I want to test the TDE. What is the procedure of this. Should I create new user for this or should I take backup...

Thanks its Works for me.

What should I learn before to start Warehousing.

Thanks

Nice Tool.It works for me.

Thanks

Looks nice article.Please upload prices.sql script file.

Thanks

I removed @ Sign From Code and It just work For me.

Thaks

I am using SQL Server 2008R2. When I run the following Code it give me following Error.

CREATE TYPE dbo.DynamicTbl AS TABLE

(

@TransID as int,

@TableName as varchar(50)

)

Msg 102, Level...

Actually we are using isnull too much in sps for reports which is overhead for performance. We are going to remove isnull by using default constraint. At application level it...

azhar.iqbal499 (9/14/2011)

I will correct data, but my require ment is like that, I can explain further here. This is just dummy Data

Col1 ...

Yes,

I will correct data, but my require ment is like that, I can explain further here in new attatched xls file.

pl see attached file.

Hopefully this will explain.

In case of...

Thanks for your time.

Actually, we will synchronize the data by replicating the all dbs. We dont have extra servers right now to shift all subscriber at the different physicals servers....

Thanks Dear for Help,

You pointed out problem in a right way,

There many Views that are created in our DB automatically, We have just have replication in our DB and backup...

Dear its nice article, but I face One issue here.

When I run proc_FilltblIndexUsageInfo sp then I get following error.

Msg 8134, Level 16, State 1, Procedure proc_FilltblIndexUsageInfo, Line 5

Divide by zero...

Dear Prashant Pandey,

Nice explanation of Difference, I learned definitely something new from this post.

I Solved the problem. I was using push distribution and all Agents were running at the Distributoer. There were some blocking going on at the distributor, which was hurting the...