The green control flow arrow coming out of the Row Count transformation does not have the ability to change it to an expression. I had to search for a while...

Minor update to our process:

We just (in the last 30 minutes) decided it would be good to have an exceptions file that tells us when no records were exported. So,...

For free videos, search YouTube. There are some very reputable sources that have put videos there. http://www.youtube.com/results?search_query=sql+server+2005&search_type=&aq=1&oq=sql+ser

I would also recommend taking some classes so you can get some hands on...

This all depends upon your business rules. If your business requires realtime data (ie traffic officer pulling a warrant search for a traffic stop), you need to make sure your...

Be sure your provider will work without In Process checked. Some providers require this be...

Do you have RPC and RPC Out enabled on the linked server? This has caused me problems in the past going to a DB2 database. They are not on by...

If you are not strong in the SAN world, I would STRONGLY recommend contracting with HP to do your initial install and setup so they can make sure it is...

The third answer is not correct. I had to go back and do some testing on one of our tables that does contain date data. Only the 2nd option returns...

I have email alerts setup so when I come in, the first thing I do is get my coffee and then look at email (no back door but I arrive...

GSquared (6/20/2008)

---

It would be easy enough to set up a proc that did something like "select 1 from database.dbo.table" for each database on your server. Have it send an...

Interesting read. Essentially, the responses to the blog indicate that testing in YOUR environment is the ONLY way...

Muhammad Furqan (6/20/2008)

---

Space is no issue.

i have windows on separate physical disk

i have log on RAID1 separate disk ( as far as i know, RAID1 is better for larger reads)

i...

majorbloodnock (6/18/2008)

---

Of course, being "indispensable" is not a good position in which to find yourself. Companies aren't comfortable with being beholden to one person, since it gives that person too...

I'm not entirely sold on the idea of having someone else do my job for me while I'm gone. I do agree there needs to be a system of verifications...

Can you show us?