Viewing 15 posts - 706 through 720 (of 956 total)
Developer Edition of SQL would have Profiler as a part of the Workstation Components. For Express only though, you can download the following free Profiler for SQL Express 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]
December 17, 2008 at 4:04 pm
Jeffrey Williams (12/17/2008)
This really shows a fundamental lack of understanding client/server principles. And here I was, thinking that was basic knowledge that any programmer in IT should know.
Go figure...
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 17, 2008 at 10:25 am
GilaMonster (12/17/2008)
Jonathan Kehayias (12/17/2008)
Why can't I use a MessageBox.Show() in my Assembly.
<Blink> WT#@$#%$%^????????
To me that shows a fundamental lack of understanding of SQL, CLR within SQL or probably both.
Definately both....
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 17, 2008 at 10:21 am
GilaMonster (12/17/2008)
Jack Corbett (12/17/2008)
I'm amazed at some of the problems people have with SQL Server and some of the requirements that they have to deal with.
I'm amazed...
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 17, 2008 at 9:32 am
Jack Corbett (12/17/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 17, 2008 at 9:28 am
Jeff Moden (12/17/2008)
GilaMonster (12/17/2008)
r.hensbergen (12/17/2008)
Do posters think we're answering bots instead of real people?
I suspect that some do, or think that we work for SSC. I recall someone apologising...
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 17, 2008 at 8:55 am
Grant Fritchey (12/17/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 17, 2008 at 8:53 am
r.hensbergen (12/17/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 17, 2008 at 8:10 am
My first guess would be that you are storing your data as varchar() columns, and LINQ only creates nvarchar() parameters, so you lose a whole lot of performance in the...
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 17, 2008 at 7:38 am
Without seeing your code, I couldn't begin to say. Try creating the simple configuration file and function from the article I linked to above, and see if it will...
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 14, 2008 at 6:56 pm
It should be sqlservr.exe.config, and it should be under the \Binn folder for the root path of the SQL Instance.
http://www.sqlclr.net/Articles/tabid/54/articleType/ArticleView/articleId/33/Default.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 14, 2008 at 6:38 pm
No problem Edwin. It is always best to address licensing questions directly to Microsoft. It can be confusing how things actually work together and what exactly you need...
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 12, 2008 at 10:11 am
Satheesh Mohan (12/12/2008)
Issue has been solved.
Have a new issue.
In my assembly i have used Enterprise library - cryptography, that required app config.
when I run my function it throws an...
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 12, 2008 at 10:09 am
You know something I thought about reading the last post. At our local user group one of the guys presented on monitoring SQL Server with RSS. He used...
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 11, 2008 at 2:00 pm
I would make them in writing define the role of DBA for you. You might be in a lose/lose situation and you don't even know it. If 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 11, 2008 at 11:44 am
Viewing 15 posts - 706 through 720 (of 956 total)