Here we use raid 5. its fast to read and write and has parity spread out through out the array. we also run with a hot spare so...

jasona.work (10/30/2012)

---

Or I could have searched on Google for "sql server create corrupt database" in which case the top two results would be an article by Perry Whittle (How To...

What you are asking is possible through the blessing and curse of dynamic sql. before you start in on dynamic sql have a read through this as it has...

bala2 (10/30/2012)

---

Hi,

We have Production server win 2003 with Sql server 2008 running on it.

Ram --4GB.

We have performance issue for a database which application is running very slow.

Can any one...

baabhu (10/28/2012)

---

Hello Everyone,

Our production server experiences lot of blocking and locking from application.

I have attached the top waits from server. Can anyone help to understand or guide me...

ChrisM@Work (10/29/2012)

---

Jeff Moden (10/29/2012)

---

Eugene Elutin (10/29/2012)

---

Actually it depends how you take it,...

vu_tran764 (10/27/2012)

---

Capnhector,

So I got what I needed however I need to update a field in Tbldoc (maybe called as UPDATEDTO).

What I can see in the last statement(below) is more...

i see where the error is.

in your initial cte you have the following

with cte as

(

select 1 as listid, [To] as tolist from tblDoc where [To]IS not null AND [To]...

Dave Morris (10/18/2012)

---

Hi Bugg,

I think 'Trounbleshooting SQL Server, A Guide for Accidental DBAs' by Johnathan Kehayias and Ted Krueger, would be a good read before you start. It's available on...

here is the best microsoft connect item on the issue http://connect.microsoft.com/SQLServer/feedback/details/540092/sql-server-2008-sp1-cu6-periodically-does-not-accept-connections

im guessing the event id is 18056? if so the above will have allot of information. we are...

had to fix the url. The link Alex posted is to Ola Hallengren's Database Maintenance Scripts. they are a wonderfully complete scripts for index maintenance.

vu_tran764 (10/26/2012)

---

Thank you Lowell and Sean! Much appreciated!

This reply post is for Lowell. I am testing out your codes and I think I'm slightly not getting some part of the...

Sean Lange (10/26/2012)

---

Well it looks like Lowell beat me to the punch on this one. I rolled my own version, which also uses the DelimitedSplit8K function. 😉

;with cte as

(

select...

Eugene Elutin (10/26/2012)

---

If you want your CLR with Regex to perform well you need to declare your Regex object as static and...

asita (10/26/2012)

---

Thanks for all the man kind

i great full to al of you

hisakimatama

Luis Cazares

capnhector

Steven Willis

i got the answer from hisakimatama, when he gave his first reply, i am...