Viewing 15 posts - 151 through 165 (of 956 total)
Pooja-462303 (2/5/2010)
" AppDomain 35 (DBName.DBName[runtime].34) is marked for unload due to memory pressure. "
I...
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]
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?
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]
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...
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]
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...
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]
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...
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]
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...
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]
January 22, 2010 at 1:48 pm
Barry,
I beleive there is an example on Adam Machanic's blog post :
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]
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...
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]
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...
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]
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.
...
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]
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....
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]
January 19, 2010 at 6:40 am
Krasavita (1/12/2010)
Target Server Memory (KB) ...
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]
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()...
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]
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,...
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]
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...
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]
January 8, 2010 at 8:45 pm
Viewing 15 posts - 151 through 165 (of 956 total)