Viewing 15 posts - 286 through 300 (of 956 total)
Did you figure out the source of your problem?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 21, 2009 at 3:53 pm
It would be interesting to know if the issue is specific to 32 bit SQL Servers only or not. If it is specific to 32bit SQL Servers, then I...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 21, 2009 at 3:51 pm
Basically, you are trying to do something that is not allowed for stability reasons in SQL CLR. What exactly are you trying to do? What is the CLR...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 20, 2009 at 8:50 pm
I decided to post a blog post to cover this in more depth:
Understanding the VAS Reservation (aka MemToLeave) in SQL Server
It's quite extensive an I hope it helps explain this...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 6, 2009 at 11:45 pm
John Sansom (7/6/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 6, 2009 at 3:10 pm
I am not really sure where to begin with commenting on this article. It has incorrect information in it, and the code provided for looking at VAS comes from...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 6, 2009 at 10:40 am
One note about your 10% growth setting. This gets to be more expensive the larger the database gets to be. If you have a 500GB database, that would...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 29, 2009 at 10:30 am
It means that you aren't properly managing the size of your database files more or less. Your database files are set to autogrow to prevent the database from running...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 29, 2009 at 10:25 am
GilaMonster (6/29/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server articleYou mean 'good collection of stolen content' seeing as most of that was copyrighted material reposted without permission and frequently without attribution or links
Exactly what...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 29, 2009 at 10:22 am
Florian Reischl (6/23/2009)
Jonathan Kehayias (6/22/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 23, 2009 at 6:35 am
Florian Reischl (6/22/2009)
Jonathan Kehayias (6/22/2009)
Sure Adam Machanic wrote a custom string splitter to show the difference between a correctly built Enumerator in SQLCLR over the most commonly misapplied String.Split() function:
I...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 22, 2009 at 7:05 pm
Sure Adam Machanic wrote a custom string splitter to show the difference between a correctly built Enumerator in SQLCLR over the most commonly misapplied String.Split() function:
If you run his tests...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 22, 2009 at 1:05 pm
Florian Reischl (6/22/2009)
Jonathan Kehayias (6/22/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 22, 2009 at 12:38 pm
Robert Davis (6/18/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 22, 2009 at 9:49 am
A good book to get you started would be:
http://www.amazon.com/Pro-SQL-Server-2005-Assemblies/dp/1590595661
However, after 2+ years working with SQLCLR, I'll tell you that appropriate use cases for it are pretty uncommon unless you offload...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 22, 2009 at 8:02 am
Viewing 15 posts - 286 through 300 (of 956 total)