Viewing 15 posts - 1 through 15 (of 198 total)
Thanks for the response SSCertifiable. The order by also needs to choose the greater of AddDt & UpdateDt. I'll definitely try and get the nullability squared away.
.
April 27, 2016 at 1:37 pm
Thanks Alan.B. Completely understood. I believe the real schema has the proper keys/indexes, I was just looking for the best query solution for this scenario. I will double check though.
.
December 7, 2015 at 7:40 pm
Interesting solution LinksUp. Thank you. I'll try this in the real data and see how it goes. The real data is pretty large, eliminating a table scan should be pretty...
.
December 7, 2015 at 4:56 pm
Awesome, thanks. I have great respect for your reputation Jeff. I've followed your posts for many years, and have tried to live my SQL Server life according to the principles...
.
April 24, 2015 at 3:09 pm
Hi Jeff, thanks for the reply. I'll work on tracking down those specifics for you by tomorrow. What I can tell you so far is that the files are "positional",...
.
April 24, 2015 at 12:48 am
Thank you. Sounds reasonable. I'll give this a shot.
.
March 25, 2015 at 9:39 am
Thanks all for the great advice. Rewriting the sproc is not an option at this time. Since this is just a wrapper around the real work horse, I guess it's...
.
February 28, 2013 at 8:12 pm
I think I figured out the problem. I was using the SQL 2012 SSMS to do the restore. On this version, the Restore Dialog has a new "Files" option on...
.
October 30, 2012 at 11:27 am
Quite right Crazy8! Getting my Visual Studios & SQLs all mixed up, which should not surprise you since Microsoft seems to be doing the same thing! Have you seen SSDT....
.
October 30, 2012 at 10:01 am
Yea I'm sold on that approach. I'm headed down that road now.
.
September 4, 2012 at 2:11 am
You are absolutely right about those things Jeff, I've not been giving those the attention they deserve.
Thanks
.
September 3, 2012 at 2:46 pm
Perfect. Thank you Tom. Exactly what I am looking for.
.
August 17, 2012 at 8:42 pm
Viewing 15 posts - 1 through 15 (of 198 total)