Viewing 15 posts - 901 through 915 (of 956 total)
Use nvarchar(max) instead of 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]
July 21, 2008 at 11:14 am
What version of Oracle and is SQL running on x64 or x86?
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]
July 21, 2008 at 10:51 am
It is impossible to really provide a good answer to your question about whether to index the view or not without seeing execution plans and other information. I would...
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]
July 21, 2008 at 9:48 am
Enabling CLR doesn't do anything in reality, it just allows CLR to work if it exists in the database. You can create assemblies in SQL even with CLR disabled,...
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]
July 21, 2008 at 9:44 am
rbarryyoung (7/20/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]
July 21, 2008 at 9:32 am
rbarryyoung (7/20/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]
July 20, 2008 at 8:42 pm
Pavel Spálený (7/20/2008)
CREATE ASSEMBLY SystemWeb from 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Web.dll'
with permission_set = unsafe
System.Web is unsupported in SQL Server for a reason. Even if you can get it loaded, you can't get...
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]
July 20, 2008 at 5:59 pm
rbarryyoung (7/20/2008)
FYI: sp_MakeWebTask is deprecated in 2005 and supposedly removed in 2008 (I haven't checked this).
So far it still exists in SQL 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]
July 20, 2008 at 5:30 pm
Ryan,
I haven't ever actually implemented one, but I am certain that it would be fairly complex, given the fact that there is no international standard, and not all timezones participate...
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]
July 17, 2008 at 1:28 pm
You can do this from TSQL by building your app as a Console Application that accepts CommandLine arguments, and then calling that app from xp_cmdshell inside a stored procedure with...
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]
July 17, 2008 at 9:25 am
I guess to me and probably most people the question back to you would be why do you want to do this from TSQL? This isn't a task 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]
July 17, 2008 at 8:11 am
Rather than store the name, why don't you store the offset from UTC? Or you can create a lookup table with the Name/Offset pair and use an ID field...
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]
July 17, 2008 at 8:04 am
Is it always going to be based on the SQL Servers Local Time Zone?
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]
July 17, 2008 at 7:58 am
This might help you some, but here is a function that gets the current UTC Time:
[Microsoft.SqlServer.Server.SqlFunction]
public static SqlDateTime UTCTimeConversion()
...
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]
July 16, 2008 at 10:36 pm
What are you doing in the procedure before the connection portion you show here? It is almost impossible to look at this small a piece of code and offer...
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]
July 16, 2008 at 7:13 pm
Viewing 15 posts - 901 through 915 (of 956 total)