No,

I'd recommend you just to follow your own strategy and planning, not others... it won't help you.

Regards

IgorMi

Hi,

May be something like this can help you

create table #locked

(spid int,dbid int,objid int,indid int,type varchar(10),resource varchar(10),mode char(3),[status] varchar(10))

insert into #locked

exec sp_lock

select l.spid, l.dbid,object_name(l.objid) [object],l.indid,l.type,l.resource,l.mode,l.status

from #locked l

Regards

IgorMi

Hi,

I think you can still stay on your RAID5

The following link http://www.dell.com/downloads/global/solutions/tradeoffs_RAID5_RAID10.pdf?c=

can explain you more. However if you can place your log and tempdb on a RAID 10then it will...

Hi,

I've changed it to 1435 (i would have changed it to another one later) but it is not that.

I was trying to connect from ssms 2008 and 2012 and the...

If i leave both instances to listen on the default port 1433, then the second's services don't start.

Regards

IgorMi

Hi,

If you have quite higher percentage of writes against reads, then RAID 5 is better than RAID 10.

However, you can download the following book by Jonathan Kehayias:

http://www.red-gate.com/community/books/accidental-dba?utm_source=simple-talk&utm_medium=webpage&utm_content=troubleshooting_ebook&utm_campaign=sqlmonitor

and decide what...

I think constraints are good in general, although they make insert/update operations slower.

In some cases they can help the query execution plans execute faster. As much of the constraints...

shohelr2003 (11/5/2012)

---

Dear,

1. I like to auto shrink my database. But I dont know how to do it.

2. My current DB size is 2 GB. I want that if my database...

Hi,

You can read some of the articles here:

http://www.sqlservercentral.com/Search/?q=indexes&s=0&t=a

http://www.sqlservercentral.com/Search/?q=indexes&s=10&t=a

http://www.sqlservercentral.com/Search/?q=indexes&s=20&t=a

...

and it will become clearer for you about indexing.

Regards

IgorMi

Perry Whittle (11/2/2012)

---

OK, you're joking right??

Firstly, TRUNCATEONLY does not apply to T-log files!

A wholesale shrink of all log files on the instance, and you believe this will be beneficial?

What do...

Nadrek (11/2/2012)

---

It is almost never recommended to shrink database or log files, even less likely to need them done all at once, and absolutely not in a scheduled job. ...

sqlfriends (10/30/2012)

---

When I use sql server maintenance plan, there is a task called reorganize index.

If I setup a job to reorgnize an index, for example every 6 hours, should...

PiMané (10/25/2012)

---

Hi,

I was trying to get a "rule" for table naming but it's kind of hard to do it since every case is a casa...

You can have a table Customers...

mpapali (10/25/2012)

---

Hi all,

Im new here (just joined your club)

I would like to do my SQL course basically on Administration and implementation.

Can anyone suggest a course and a good place...

You can use the Date and...