Viewing 15 posts - 916 through 930 (of 15,381 total)
April 7, 2017 at 10:53 am
I really hate cursors and sp_msforeachdb is a big nasty undocumented cursor that sometimes skips databases. http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx
Thankfully we can easily use the system views to generate...
April 7, 2017 at 9:39 am
April 6, 2017 at 1:19 pm
I have a whole list of things I do after work. Some of them are relaxing but others are for the kids. The ones for the kids have their own...
April 6, 2017 at 7:51 am
April 5, 2017 at 9:29 am
Dim appword As Word.Application
In References is Microsoft office 12 object library...
April 5, 2017 at 8:14 am
WayneS - Tuesday, April 4, 2017 11:37 AM
Awesome!!! Well deserved!!!
April 4, 2017 at 12:34 pm
April 4, 2017 at 10:50 am
Many thanks Gail and her blog about parameter sniffing. I can't count the number of times I have sent others there but today I ran into it with a procedure...
March 30, 2017 at 10:00 am
March 30, 2017 at 8:09 am
March 30, 2017 at 7:25 am
March 29, 2017 at 10:18 am
Viewing 15 posts - 916 through 930 (of 15,381 total)