you...

Also, do you really need to do reindexing on a daily basis? Cant you schedule it to run only during weekends when the activity on the db server is minimal?...

Log shipping works fine under bulk-logged recovery model as well.

Remember that in bulk logged recovery model, bulk operations are 'minimally' logged which means space consumed by your log file will...

General rule of the thumb is,

30% rebuild

EDIT - The % denotes index fragmentation.

Nero (7/6/2009)

---

hi all,

I have 10Gb DB.

From past 2-3months my DB slows down due to high transaction.I have added new filegroup and moved some table in it using cluster index.

I also...

This is by design of Sql Server. We cannot change and it's always 8K.

Why do you need to change it?

Glad you got it going.

Please go through this site as this will help you to post relevent details in the thread that will help others to help you in a...

May be the threshold of the job history was reduced. Pls go through this site on how to check and modify this.

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

Blazix Marler (7/6/2009)

---

hi,

I new to sql server.Below is the query I am writing.On running this query the error is

'Incorrect syntax near the keyword 'where'.Let me know the correct syntax...

Run sqlservermanager.msc

expand sql server 2005 network configuration

select an instance, click on TCP/IP and IP Addresses tab. U can check the port on which sql server instance is running

I'm not sure...

Are you trying to create a DDL trigger for Logging in of a user? This is not a DDL event. You can enable Login audit by right clicking ur server...

for some days observe the log file capacity being utilized and for once shrink the log file to that level, leaving some free space in it. It seems there are...

compatibility level of 80 of a sql server 2005 database means some of the behaviours of the database to be compatible with sql server 2000.

ref. http://msdn.microsoft.com/en-us/library/ms178653.aspx

You cannot restore a database...

Can u also check if the tran log file of the subscriber is full(if its in full recovery mode?)

I'm interested in knowing if really the problem was related to what some of us predicted, or was it something else?