Viewing 15 posts - 151 through 165 (of 965 total)
Pooja-462303 (2/5/2010)
" AppDomain 35 (DBName.DBName[runtime].34) is marked for unload due to memory pressure. "
I...
February 5, 2010 at 10:43 am
What is Max Server Memory configured to on the server and is it using Lock Pages in Memory?
January 28, 2010 at 10:07 am
What is your C# code for the function? I am guessing that this is a 32 bit SQL Server? It may not have anything to do with a...
January 28, 2010 at 9:12 am
FreeHansje (1/18/2010)
I wish to say thanks again. I must have done something wrong, different then you describe in your solution. I could have sworn I used the same construction to...
January 22, 2010 at 10:00 pm
ChiragNS (1/18/2010)
After signing the procedure with certificate can the procedure be executed only by the login/user created from the certificate? Can other users...
January 22, 2010 at 9:58 pm
David Portas (1/22/2010)
abhishes (1/20/2010)
I am doing a presentation for all the features of SQL Server, and one of topics is SQL CLR.
Intensive byte level operations within large objects are hard...
January 22, 2010 at 1:48 pm
Barry,
I beleive there is an example on Adam Machanic's blog post :
January 21, 2010 at 5:31 pm
Pedro DeRose [MSFT] (1/21/2010)
3. Easier access to external data sources: much simpler in .NET than T-SQL.
Funny you should mention that because there is no SAFE or EXTERNAL ACCESS support...
January 21, 2010 at 3:24 pm
Shredding XML is hands down faster with SQLCLR and becoming more and more common in database work. Binary Serialization and deserialization of data with Service Broker is another great...
January 21, 2010 at 6:41 am
Charles Kincaid (1/19/2010)
Clustered Indexes remove the data from the base table and store the data along with the pointer to the row in the table in the Clustered Index.
...
January 19, 2010 at 11:49 am
The best resolution for database corruption is to restore to the last known good backup.
I am with you here.
This is unfortunately not always possible.
But then you immediately lost me here....
January 19, 2010 at 6:40 am
Krasavita (1/12/2010)
Target Server Memory (KB) ...
January 12, 2010 at 12:49 pm
For those interested, you can use the same method to give SA rights or access like VIEW SERVER STATE to users with no access. For example to call sys.dm_exec_sql_text()...
January 11, 2010 at 12:13 pm
FreeHansje (1/11/2010)
I need to call master.sys.dm_exec_sql_text(to find the last used sql-statement) from a trigger, or sp, in another database,...
January 11, 2010 at 11:56 am
sqlnsg (1/8/2010)
My last option left would be increaseing max worker threads from 255 to 288 .
I think I ran out of space because it threw an error saving my last...
January 8, 2010 at 8:45 pm
Viewing 15 posts - 151 through 165 (of 965 total)