Viewing 15 posts - 661 through 675 (of 956 total)
I only work on my production servers via RDP to my work desktop. It's just not worth any kind of risk being on VPN as well as having 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 22, 2008 at 6:11 pm
My numbers in testing seem to line up with what you are seeing. Change the last query out to be:
SELECT
CAST(Size AS BIGINT)/1024 AS [Free size, KB]
FROM
VAS_Summary...
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 22, 2008 at 5:48 pm
RBarryYoung (12/22/2008)
kotlas7 (12/22/2008)
Could you plz tell me what can we do to improve the performance.
Frankly I am not seeing any evidence that you have a performance problem. The peformance...
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 22, 2008 at 5:19 pm
You are seeing the nature of Sharepoint, you can't change how it behaves except as prescribed by Microsoft in KB articles and supporting documentation. Is there a specific 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]
December 22, 2008 at 3:10 pm
Let me double check that query. I know it is one I provided elsewhere, but something could be wrong with it... I'll get back to you in 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 22, 2008 at 3:08 pm
Steve Jones - Editor (12/21/2008)
Have you enabled the DAC? It's disabled by default. Use the Surface Area tool to turn it on.
Steve,
Isn't the DAC enabled by default? You only...
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 22, 2008 at 3:06 pm
You really need to goto x64. I can certainly understand that might not be an option, but for what you are trying to do x64 is so much better....
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 22, 2008 at 1:54 pm
Jeff Moden (12/22/2008)
Kit Brandner (12/22/2008)
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 22, 2008 at 1:47 pm
timothyawiseman (12/21/2008)
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 22, 2008 at 1:43 pm
You should be able to do a inplace upgrade from Evaluation to Developer in 2008 without problems.
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 22, 2008 at 1:37 pm
Be really careful implementing the recommended missing indexes from the DMV's. In some cases they will recommend a duplicate index with a different list of included columns. 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 22, 2008 at 1:36 pm
The URL and example of doing this with SQLCLR is:
http://msdn.microsoft.com/en-us/library/cc655659(SQL.90).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]
December 22, 2008 at 1:33 pm
If you are open to SQL CLR, Microsoft has a TVF Sample that you can use to do it with a simple select statement.
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 22, 2008 at 1:32 pm
Change the application to use connection pooling. It isn't a SQL Server 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]
December 22, 2008 at 1:31 pm
Marios Philippopoulos (12/22/2008)
I tried it on our server last week (added -g384) and, after rebooting the server, I ran the attached query in my instance to determine the total 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 22, 2008 at 1:15 pm
Viewing 15 posts - 661 through 675 (of 956 total)