Viewing 15 posts - 841 through 855 (of 956 total)
GilaMonster (10/19/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]
October 19, 2008 at 10:48 am
I can provide you a number of theories about what may or may not be causing this. The best way to determine for certain why you are getting 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]
October 17, 2008 at 8:30 am
There are a couple of ways for you to go about creating this linked server. The first thing you have to do though is ensure that the SQL Express...
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]
October 15, 2008 at 8:37 am
Create a Linked Server between the two and call the stored procedure over the link. I would expect that you will have some performance issues with this since 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]
October 14, 2008 at 8:26 am
GilaMonster (10/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]
October 11, 2008 at 1:49 pm
I'd recommend that you read up on ANSI standards for SQL. I might be hardheaded, but I understand what I am talking about. You also might pickup Kalen...
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]
October 11, 2008 at 7:21 am
If you are having this kind of issue, then you have something that is not thread safe in your implementation, which we can't see in the little bit of code...
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]
October 10, 2008 at 4:45 pm
It is obvious from your post that you have no idea how the Query Engine in SQL Server works. The fact that CLR Integration was added to SQL Server...
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]
October 10, 2008 at 4:31 pm
The database engine understands TSQL. It doesn't build a expression tree from the TSQL, it creates an optimized execution plan so that the database engine knows how best 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]
October 10, 2008 at 12:00 pm
Describe what you mean inverse query. If you simply mean to get the opposite set of rows for the two queries then use NOT LIKE and 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]
October 3, 2008 at 8:50 am
What version of SQL Server is this for? How do you want the contents of the table sent, as a CSV attachment, inline to the body of the message,...
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]
October 2, 2008 at 10:13 am
The BOL is probably the best reference point for you:
http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.match.groups.aspx
Is there something specific that you are having a problem with this? Can you provide an example of your...
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]
October 1, 2008 at 11:16 am
Thanks for sharing that. I learned something new.
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]
October 1, 2008 at 9:44 am
Same question also asked on MSDN Forums:
http://forums.microsoft.com/Forums/ShowPost.aspx?PostID=3944576&SiteID=1&mode=1
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]
September 30, 2008 at 5:31 pm
Perform the encryption operations external to SQL Server is the only thing I have ever seen recommended. System Administrators have the keys to the kingdom, it is one 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]
September 30, 2008 at 5:21 pm
Viewing 15 posts - 841 through 855 (of 956 total)