Viewing 15 posts - 781 through 795 (of 956 total)
The simple answer to your question is yes, you can clear the memory but the more important question that you should be asking and looking at is why you 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]
November 19, 2008 at 3:17 pm
Post the value of SELECT @@VERSION, as well as the output of DBCC MEMORYSTATUS into this thread. Also what is the physical hardware configuration of the server #CPU's, RAM?
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]
November 13, 2008 at 12:39 pm
What is running when the stack dump generates? Non-yielding resources usually mean that something pre-emptive was executing which could be CLR, an XP, a OLE Automation Call, or 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]
November 12, 2008 at 1:01 pm
Yes, you will have downtime while you move your system databases to another drive. You can read one of the following articles on how to accomplish this task:
How 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]
November 12, 2008 at 12:07 pm
The_SQL_DBA (11/12/2008)
..like when the log file grows too large after a one off bulk operation DBCC ShrinkFile can be used effectively to reclaim the log space to OS
These operations...
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]
November 12, 2008 at 11:52 am
Do you have CLR integration enabled and CLR objects being used in the database engine?
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]
November 12, 2008 at 11:48 am
dphillips (11/12/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]
November 12, 2008 at 11:36 am
george sibbald (11/12/2008)
katedgrt (11/12/2008)
Joe Johnson (11/11/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]
November 12, 2008 at 11:27 am
Are you being blacklisted by the remote server, or by one of the service DNSBL's that the companies may be subscribing to?
http://en.wikipedia.org/wiki/DNSBL
If it is by the remote server, then as...
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]
November 12, 2008 at 11:18 am
I happen to work in an environment where I am just a DBA, and for a decently sized environment. However, having the dev background, I am quite competent in...
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]
November 12, 2008 at 10:50 am
You are supposedly able to P/Invoke it in SQLCLR, but since I have never had a COM need in SQLCLR, I don't have experience to tell you exactly how that...
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]
November 12, 2008 at 10:17 am
If you alter the assembly, and the stored procedure's parameter and outputs have not changed, then the procedure is altered by altering the assembly. If you added to or...
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]
November 11, 2008 at 4:48 pm
I am in complete agreement with Lynn on this. You are beating a screw with a hammer because all you have is a hammer. You might be able...
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]
November 11, 2008 at 4:37 pm
Kishore.P (11/11/2008)
oyen_kai (11/11/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]
November 11, 2008 at 5:39 am
If you don't know TSQL, and you have other objects in SQL CLR, then I would recommend that you start over on your design. In my opinion, 95% of...
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]
November 10, 2008 at 5:22 pm
Viewing 15 posts - 781 through 795 (of 956 total)