Viewing 15 posts - 196 through 210 (of 956 total)
johnzabroski (12/17/2009)
Dumb question...What's wrong with using WITH EXECUTE AS? http://www.mssqltips.com/tip.asp?tip=1227
The stored procedure in the article uses WITH EXECUTE AS. Not sure what you are asking specifically or that you...
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]
December 17, 2009 at 11:37 am
You can see how to use a certificate signed assembly on my article Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents[/url] to keep from having to...
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]
December 17, 2009 at 10:53 am
Edogg (12/16/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]
December 16, 2009 at 6:05 pm
GilaMonster (12/15/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]
December 15, 2009 at 1:50 pm
Is it possible that Ghost Cleanup just hasn't run yet?
Inside the Storage Engine: Ghost cleanup in depth
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]
December 15, 2009 at 7:44 am
Look at Perry Whittle's articles on here:
http://www.sqlservercentral.com/articles/65994/
http://www.sqlservercentral.com/articles/66246/
He uses Virtual Server 2005 but the fundamentals of the cluster configuration are the same regardless of the virtual platform you are building it...
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]
December 13, 2009 at 11:00 pm
A few examples are on my blog post:
Getting log space usage without using DBCC SQLPERF
Make sure to read the comments section as well.
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]
December 13, 2009 at 10:17 am
Microsoft provides a couple of stored procedures that can do this for you. Pick the appropriate version of their code from the following link:
Transfer Logins between Servers via Script
and...
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]
December 13, 2009 at 10:06 am
GilaMonster (12/13/2009)
Everything? There have been entire books written on clustering that still don't cover everything. I don't think that anyone's going to give you everything in a forum thread.
Exactly my...
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]
December 13, 2009 at 10:00 am
sbowell (12/10/2009)
I'm not using any COM objects in the SQLCLRManager.
Also worth noting is that this has been working fine for several weeks.
C# Screw,
That is exactly what its for....
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]
December 13, 2009 at 9:50 am
Jack is correct here. The actual concurrent worker limit would be dependent on what platform you are running on. A 32bit installation would only have 256 workers, and...
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]
December 12, 2009 at 6:19 pm
Dean Jones-454305 (12/12/2009)
1) how many physical spindles underly your tempdb partition.
2 spindles for system DB's, as there is a seperate LUN for this, and the size needed is small,...
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]
December 12, 2009 at 5:58 pm
What is your PAGE_VERIFY set to currently? If you are on SQL Server 2005, CHECKSUM is the recommended best practice setting for this, which stamps each page with a...
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]
December 11, 2009 at 11:24 am
One thing to keep in mind is that if you use Lock Pages in Memory, you won't see SQL Servers memory consumption in Task Manager. You have to track...
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]
December 11, 2009 at 10:55 am
Not for servers that are dedicated to SQL Server, have a lot of RAM (more than 8GB), and have a proper configuration setting for max server memory.
Locking pages...
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]
December 11, 2009 at 10:33 am
Viewing 15 posts - 196 through 210 (of 956 total)