With all of the concerns over C&C, I think maybe the following would help - at least IMO, because I don't know enough to really point fingers in any specific...

I have been going to PASS Summit since 2012. When I wasn't making a higher salary, I was fortunate that my employer paid for it. I did make it clear...

It's interesting now that businesses have to be more aware of how they treat individual clients. Previously, it didn't matter as much to the company if a client "got...

Well, first I'd register for the SQLCruise to Alaska 🙂

I would put an addition on my house and buy the 3 acres behind me from my neighbor. I would buy...

I have found in many classes/situations that when I'm having trouble getting the answer, the more work I have to do to figure it out, the better I'll remember what...

Thank you - that worked like a charm!

Thank you so much!

I'm starting on a data cleanup task (which will lead to table structure cleanup in the future, I hope) on a production database. Well, starting in the...

Thanks again for the info and for pointing me in the correct direction for more information!

I believe they can set up additional virtual drives.

I'm not sure about the RAID.

I know there had been discussion that if the project did explode in size (which it...

Ah excellent - I was wondering if my lookup tables (which change very infrequently, but are not exactly read only) also should go in a separate filegroup from the 3...

I have been working in my job for a little over two months. In that time, when questioning a gaping lack of security precautions, I have received the same two...

Hello!

I 'was' a Coldfusion programmer - at some point about two years ago I realized I was having CF do things for me that the back end database would have...

That's okay - I'm sure I'll have a ton of SSIS questions once I figure out how it fits into the scheme of things! 🙂

Thanks for the reply!

I previously had been writing stored procs this way, but in my optimization reading I found this article:

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Stored-Procedure-Parameters-giving-you-grief-in-a-multi-purpose-procedure.aspx

which explains why I should try to avoid doing so....

Thank you! I was looking for that too and stumbled upon this thread. Much appreciated!