Viewing 15 posts - 1 through 15 (of 30 total)
David, I appreciate the candor and articulation of the process that you went through. I realize that writing/formatting/proofreading the article was probably just as time consuming as writing the...
September 22, 2015 at 3:59 pm
So let me get this right. You're suggesting Password123 be my duress password instead of password123? Yah, I think that might work! 😀
I think there are...
April 21, 2015 at 3:46 pm
Solomon, you know I'm already a fan, but wow!! I agree with Phil, this article is completely unique across the internet. Anybody considering SQL CLR development should start...
March 11, 2015 at 2:48 pm
Love these types of tips!! Keep em coming.
Now I just gotta close the 200 query windows I have loaded and upgrade SQL Prompt :hehe:
January 22, 2015 at 5:32 pm
Personally, I think that SQL Server (set based RDBMS) is a fairly focused product. Yes, SQL in all its flavors is a language, but it have a specific purpose....
January 20, 2015 at 4:15 pm
I think Phil's thoughts and concerns are spot on. The specific knowledge required to code, secure, test, optimize, deploy, maintain, and document SQL CLR functionality between SQL devs, system...
January 18, 2015 at 8:57 pm
I use CLR extensively, and while it may be possible to kludge some convoluted solutions together to accomplish the same thing, if coded correctly, and used appropriately, it makes code...
February 21, 2014 at 3:00 pm
I solved this issue by using the SQL# (www.sqlsharp.com) library. The Date_FormatTimeSpan function (which is part of the free functionality) is very flexible. For example, here are 3...
September 26, 2013 at 7:07 pm
Thank you. I had read that article and was hoping I wouldn't have to create another 11 filegroups/files and move and then remove. I guess I didn't realize...
December 1, 2010 at 4:38 pm
Jim, excellent thought. I had created a function to script out the create and drop indexes for a table, and I should have just used that idea instead...would make...
July 13, 2010 at 5:49 pm
No, the server is SQL 2008.
The script works fine (the auditing works fine) if I execute the scripts through SSMS.
The objects get created if I execute them via the batch...
July 8, 2010 at 1:57 pm
SQL 2008 Enterprise
July 6, 2010 at 12:27 am
You're right, I was creating the indexes WITH (ONLINE = ON).
After looking at some research and my situation, I think I'll eliminate the ONLINE attribute.
June 9, 2010 at 4:54 pm
I too am having issues trying to connect a 64 bit (x64) SQL Server 2005 to Teradata.
Has anybody had any luck?
I did get the 64 bit OLE DB for ODBC...
March 16, 2010 at 11:38 pm
I haven't played with SQL 2008 yet. Does anybody know if anything along these lines has been introduced in SQL 2008?
If not, almost makes me want to start sending...
February 27, 2009 at 3:40 pm