Viewing 15 posts - 781 through 795 (of 965 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...
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?
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...
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...
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...
November 12, 2008 at 11:52 am
Do you have CLR integration enabled and CLR objects being used in the database engine?
November 12, 2008 at 11:48 am
dphillips (11/12/2008)
November 12, 2008 at 11:36 am
george sibbald (11/12/2008)
katedgrt (11/12/2008)
Joe Johnson (11/11/2008)
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...
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...
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...
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...
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...
November 11, 2008 at 4:37 pm
Kishore.P (11/11/2008)
oyen_kai (11/11/2008)
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...
November 10, 2008 at 5:22 pm
Viewing 15 posts - 781 through 795 (of 965 total)