How big is tempdb and how big is the disk drive (or lun) that it is on? What else is on thid disk drive or lun?

Sean Lange (4/30/2012)

---

MaverickMan (4/30/2012)

---

Thank you all for providing such wide variety of solutions to this problem. Performance is not the need for our problem so it will work with any...

blandry (4/30/2012)

---

Ah, Gotcha...

I got a couple great suggestions and some guideance off another SQL site and I am pursuing that right now. If I get stuck I will try...

Really don't have enough information to really help. Please read the first article I reference below in my signature block for the information we need and how to post...

Iceberg

blandry (4/30/2012)

---

Wow...

Thanks for the replies, and the advice. I made the cursor READ_ONLY, presuming that would help improve things - but if you guys are saying "Dont use cursors",...

iBar (4/30/2012)

---

Hi,

There were 7 rows and after deletion there are 6 rows. So i can't understand your question.

Note: Question and Query is based on data at the time of query...

Error message is telling you exactly what to do.

First of all, your fetch into has to have variables for all the columns you have defined in your select list for the cursor. You then use the appropriate...

k.subramanyam1017 (4/30/2012)

---

I'm really sorry for what I had done. I'm new to this and I have a doubt on this and so I posted that question, If any one knows...

Another would be Notification Services. You could install it on SQL Server 2005 but not on SQL Server 2008.

is250sp (4/30/2012)

---

I have a datetime report parameter named @due_date with "allow null value" checked. In my where clause I have the following.....

where rehire_dt = @due_date

During runtime when I have...

Unfortunately, no one is asking the obvious question. What is the problem you are having or trying to solve?

adonetok (4/30/2012)

---

I create a function as below.

It is working but I do not think it is the best way.

create FUNCTION [dbo].[GetFirstDayOfMonth] ( @myDate DATE )

RETURNS varchar(20)

BEGIN

declare @tempdate varchar(20)

set @tempdate=...

Okay Steve, I submitted my QotD this morning. You may need to do some fiddling with the image. If you have any questions, drop me an email.