Roland Alexander STL (11/15/2012)

---

Hugo Kornelis (11/15/2012)

---

Roland Alexander STL (11/15/2012)

---

We ought to make note here that DEFAULT has been deprecated in an unspecified future version of SQL Server, so don't get...

Fortunately there is a fair amount of crossover knowledge and experience between SQL development and administration. How much cross over depends on a combination of factors. The job:...

Personally I like Joes 2 Pros[/url]. Their books are for the development path rather than the administrative one but still quite good.

adam_pearson (11/5/2012)

---

Hi Kenneth,

Thanks for the example however no joy with that either. Using either a table as the source or hard coding it into the FOREACH container...

The new machine is their desktop, not the server. The databases should all be the same as they have been.

You could try running DBCC CHECKTABLE and see if it shows anything. Or try looking at sys.dm_db_index_physical_stats and see if it needs to be rebuilt anyway based on fragmentation.

Here is an example using backupset. If I understood what you were asking for this should be it. It outputs the data as datatype TIME. If you...

Are there any indexes on the table? If so you might consider rebuilding them. I've seen "corrupted" before, causing similar problems.

I would check and make sure your secondary package has a package configuration set up. It would need to be type "Parent Variable" and you can use it to...

Actually I found that if you have OPTIMIZE FOR ADHOC on and see a full adhoc plan rather than a stub then it is actually the second time the query...

You were right. I checked again and everything was fine. I'll remember the checkpoint for next time though.

Thanks!

Awsome question! Learned something new and that always brightens my day!

Very true and I would certainly recommend the same. In this particular case it is a lookup table but not a parent to any other table. It's being...

Excellent point. I definitely should have made it clustered if I was going to put any type of index on it. I'm not really sure how much it...

Actually it's the combination of the columns that are unique. I have used filtered indexes before (and think they are a great addition to SQL Server). In this...