Hi ,

Index is on 2 GB data.

Thanks

Hi,

In both SQL Server and VB.NET you have to use Try catch block.

What ever error you grab in SQL Server catch box just Raised it with RAISERROR syntax.

Now in VB.NET...

Hi Abhishek,

I am assuming the mail target of this partition is to fetch the query fast.

So use those values which are frequently used in your Where clause.

You can use...

Hi Paresh,

I like your solution but again i am bit hasy in applying in production before testing it local.

Are you sure log shipping will not affected after this process because...

Hi,

Thanks for your valuable suggestion. I will run "DBCC INDEXDEFRAG " one by one for the index with fragmentation average greater than 30%.

Hope it will work without affecting log...

Will it cause to stop Log shipping ? Do i need to reconfigure logshipping again after defragmentaion ?

Hi,

Please run the following query

SELECT

SUM( * 8) / 1024 AS DB_Size -- Field "size" contains the number of 8 KB pages contained in each file

FROM

[db_name_here].sys.database_files

Hi,

Think you are just exporting data right ?

as far as the import export concept it always going to append your data.

If you want exact same data the on secondary server...

henrik staun poulsen (4/29/2011)

---

Hi Rajat,

According to dbtuna you are just waiting for the harddisk to repond. Other than getting a faster hard disk (SSD?), I have no suggestions.

I have just...

henrik staun poulsen (4/28/2011)

---

Hi Rajat,

My guess is that your table did a lot of page splits, resulting in a lot of unused space. When you rebuild your clustered index, the...

Hi,

I don't know why the database size increase drastically. But later on i recovered it

please see below link.

http://indiandotnet.wordpress.com/2011/04/27/space-issue-of-sql-server-database-how-to-claim-free-space-of-sql-server/

Thanks & Regards

Rajat Jaiswal

http://www.indiandotnet.wordpress.com

homebrew01 (4/26/2011)

---

Yes, that is how I do it, with no problems. It also...

GilaMonster (3/9/2011)

---

Then you need to explain to the client...

GilaMonster (3/9/2011)

---

Rajat Jaiswal-337252 (3/8/2011)

---

Actually situation is We have to install our database on client machine (end user machine) and obviously the end user have full SQL SERVER control but we...

Hi,

Actually situation is We have to install our database on client machine (end user machine) and obviously the end user have full SQL SERVER control but we want some way...