knock on wood

the unplanned downtimes we had were:

- during fire detection system tests, the backup power unit was shut down because of a little shot circuit by one of the...

sp = service pack

cu = cumulative update (intermediate hotfix bundles)

meaning the software level of your sqlserver installation.

I hope you did apply servicepacks to the installed sqlserver instance.

For SSMS,...

this is a huge NONO !

- doing so you'll create pressure on your db catalog, especially when the proc is executed in parallel !

-...

ehm ... none.

Just be sure to only provide the parameters for the client tools and only install the client tools parts you need.

Also double check to apply the sp/cu for...

oh there can be a whole world of difference between servers hosting the same database.

- do you rebuild indexes on a regular basis ?

- are the statistics up to date...

Indeed.... we live by a couple of rules, but a ton of guidelines.

JacekO (2/20/2009)

---

I guess everybody is missing my point. I even submitted a short article on this subjects few days ago and it is under review - I guess I did...

Actually the problem with that kind of like operations is that one should implement a decent split function (according to the datatype of the target column)

Then SQLServer would be able...

Grounded for the weekend 😀

well... maybe just for once ..... OK, no problem ...

Have a nice weekend :w00t:

JacekO (2/20/2009)

---

ALZDBA is probably right and the 1=1 is because of the dynamically generated SQL Select by the user interface.

My comment is that such a technique is a BAD,...

Those shouldn't be a problem:

http://support.microsoft.com/kb/917828

karthikeyan (2/20/2009)

---

The statement like......

select top 100 * from xyz

where 1=1

AND (sid IN ( 111 ) or oid IN ( 089 ) )

and timein >= N'02/02/2009...

Probably that sql statement is being generated dynamically.

Some bright minds use it in their starting where clause because they don't know if other conditions will be added.

It guarantees the where...

That's just SQLServer performing the internal db upgrade at restore time if your backup originates from a lower version.

That also occurs if you attach a db from a lower version.

And...

Judy (2/19/2009)

---

It was not related to SP3 installation. We used to have one big physical drive which crossed two Arrays. And then this physical drive was seperated into three logical...