Viewing 15 posts - 31 through 45 (of 847 total)
Easy one since the behavior was discussed a while back with the other version of these queries. Thanks for an easy one on a Friday!
July 29, 2016 at 10:52 am
Interesting behavior. Thanks for the question!
July 26, 2016 at 1:06 pm
My Schedules table has data in it but classes does not. I figured that this is because the BuildingSchedule view only returns columns from the Schedules table. I tried updating...
July 14, 2016 at 3:46 pm
The Lead/Lag functions were one of the main reasons we upgraded to SQL 2012. We had a process that went from running for 45 minutes daily to running in 4...
June 28, 2016 at 9:21 am
Glad I got to this one late so I avoided the confusion. Thanks for fixing that Steve.
June 1, 2016 at 9:28 am
Isn't this exactly the same as NOT EXISTS? Is there a reason to use one method over the other?
I rewrote the query using not exists and got the same results...
May 18, 2016 at 6:56 am
djj (5/13/2016)
What is different in 2014 from 2008r2 that give a different answer? I should have went with my gut instead of trying to run it. 😀
I don't see...
May 13, 2016 at 2:42 pm
I am torn on this issue since I have definitely felt that I have missed out on friendship opportunities in the past but at the same time, I have also...
May 9, 2016 at 9:40 am
Thanks for the question Steve. I incorrectly figured it was a trick question since vardecimal was deprecated in favor of row_compression. I wonder how many more versions of SQL Server...
April 29, 2016 at 9:03 am
One more feature that makes me want to upgrade to 2016! Thanks for the question Steve.
April 25, 2016 at 7:21 am
I agree with the visibility issue. I have written very few triggers as I tend to turn to them as a last resort. I have had a few bite me...
April 18, 2016 at 5:21 am
Viewing 15 posts - 31 through 45 (of 847 total)