Awh, you need to specify schema nameeee

thank you, I appreciate it! Looks like I am making progress with TSQL as my logic was syntax was just a little wrong - thanks!

Are they backing up to the same place?
Have you done write tests outside of SQL to confirm the disks are configured properly? Do they both have the right allocation,...

Old topic, I know, but my guess is that that job is failing because the backup history is too large....my guess is you've got many many rows in that table.....

If you're adding an index to a table, regen the statistics anyways and if they are unneeded, (and they aren't created manually by you) they should go away I think.

Figured out the issue!!

When I was creating the index, I was adding it to the "default file group"...instead of specifying the one I created for full text.  When...

Sorry to be a troll, but....

It is emergency because my friend asked me...

NO...come on.

AWh, I have another column in the select, and therefore the group by.... that seems to affect it, but how can I use more than one column - for example,...

COl1 Col2 Col3

RE44528INfringed2015-03-27 00:00:00.000

RE44528Not infringed2015-03-27 00:00:00.000

I would expect your query to show...

Well, it doesn't seem to work, for two reasons

One, it will show a result even if there is another results on or after the date. for example,

if I have...

thanks! Let me play with that and see if it works as I'd expect

Thanks for the advice - this is what I ended up using that worked (in case it helped anyone else) I basically had to take a list of columns,...

Did you ever fix this? I had the same issue after doing an inplace upgrade from 2008 R2 to 2012 RTM...

Someone said there was a fix issued for 2008 R2......

No you cannot. There is a hack if you Google it, but it won't let you. I have not fixed and have had no issues though that I...