You and me both. Liked...

Dumb question, but why constantly create and drop the function? Wouldn't it make more sense to just create the function in the database and then call it as needed?

Actually, that makes sense. Also, as a...

Yes, that is exactly what it feels like. 😛

Still not enough. You mention 150+ databases, adding 1GB new data daily. How much space is needed for the existing databases, how much extra disk space do you...

bdavey (5/3/2010)

---

Hi Lynn,

I guess I should have clarified a little more. The stuff you mentioned is what I am looking for. Should I go with a NAS or SAN, how...

Do we need to draw a picture of what we are requesting?

Randy Doub (5/3/2010)

---

My table is compiled year-to-date payroll information and is the source for several reports. The cpp column is the pay period. I gave sample data for...

I'll give the short answer: It Depends.

To give a more detailed answer we would need to know more about what you are doing. dedicated server? DASD, SAN,...

Vacation (soon, daughter graduating from AIT!)

jimk-524058 (5/3/2010)

---

I just got this error message this morning on a filegroup that is spread across 2 drives. The main .mdf file is set to NOT autogrow. The 2nd file...

jcrawf02 (5/3/2010)

---

I was expecting this poster: http://www.despair.com/leaders.html

I think the leadership that you see out of the folks in the Armed Forces has to do with their training. They are forced...

Although I agree the Express may be the way to go initially, it does have some other limitations. SQL Server Agent is one of them, it doesn't have it,...

Something is missing. You have provided sample data, but your description is lacking.

If there is base data for the table followed by an "UPSERT" of data, which is what...

Grant Fritchey (5/3/2010)

---

Also, having four completely different queries inside the IF statement pretty much guarantees you're likely to see recompiles. If you need to set up this kind of IF...