Viewing 15 posts - 316 through 330 (of 956 total)
Ok. I misunderstood your problem. You don't have to sign the serialization assembly. How are you signing your original assembly? Validate that:
1) In the project where...
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 5, 2009 at 8:10 am
Create a keyfile and then use the Assembly linker to sign the assembly with the key file.
http://msdn.microsoft.com/en-us/library/xwb8f617.aspx
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 4, 2009 at 2:32 pm
Remoting is not supported or allowed under SQLCLR. It uses connections that can not be done inside the hosted environment.
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 4, 2009 at 2:27 pm
EdVassie (6/4/2009)
BOL is Books Online.GSquared has a good idea about spiltting your RAID group.
I'd test that with SQLIO before implementing it in production use. A 8 disk RAID 10...
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 4, 2009 at 6:01 am
aparna.athmanathan (6/2/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 3, 2009 at 5:17 am
You are already changing the architecture based on the original design you mention in your first post. I don't understand what would make doing it the correct way, any...
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 2, 2009 at 7:14 am
Why are you trying to do this through SQL Server? Why don't you let your application talk to the WCF Service directly to get the report? Calling WCF...
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 2, 2009 at 6:44 am
TRACEY (6/1/2009)
I was under the impression that when the lock in memory is set that there be more memory in the "available memory" bucket......in task manager
Not to my best...
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 1, 2009 at 4:12 pm
Dave Ballantyne (6/1/2009)
http://www.sommarskog.se/dyn-search-2005.html discusses this and many other similar methods
+1 Erland has covered this topic better than anyone else.
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 1, 2009 at 12:19 pm
Use the sys.dm_db_index_physical stats DMF to get the fragmentation information:
http://msdn.microsoft.com/en-us/library/ms188917.aspx
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 1, 2009 at 12:12 pm
What do the index fragmentation and density levels look like between the two partitions? What differences are there in execution plans, and what if any differences exist for the...
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 1, 2009 at 11:39 am
The reference for Lock Pages in Standard Edition is:
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 1, 2009 at 11:37 am
You have to apply CU4 to SP3 for Standard Edition, but even then, I don't think your expectations match what Lock Pages in Memory will do. What exactly are...
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 1, 2009 at 11:26 am
Mike Gray (6/1/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 1, 2009 at 10:17 am
Rebuilding an index does a fullscan update of the statistics. Unless you specify the WITH FULLSCAN option of UPDATE STATISTICS, you get a sampled update which may or may...
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 1, 2009 at 10:12 am
Viewing 15 posts - 316 through 330 (of 956 total)