Viewing 15 posts - 601 through 615 (of 646 total)
Hey Steve. This is not really about streaming data back to the application; it is really about streaming the results of a TVF back to the calling query, which...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
December 23, 2009 at 10:34 am
FZelle (6/10/2009)
If there is none, it will open one and Commit or Rollback depending on the result.
So...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
December 12, 2009 at 12:57 pm
I think that the CLR is great for doing things not natively available in T-SQL, such as RegEx, File System, and Internet related functions (just to name a few). ...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
December 11, 2009 at 11:29 am
noeld (11/9/2006)
exec (' USE dba_data
SELECT object_name(i.id)table_name, rows, rowmodctr,''Index Name'' = i.name, ''Statistics Date'' = STATS_DATE(i.id, i.indid)
...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
August 11, 2009 at 9:26 am
Bill Nicolich (7/2/2009)
Solomon suggests that unit testing doesn't deal with performance features. Is this a universally-understood rule? Thank you.
Hey there, Bill. I guess you ultimately want someone else to...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
July 2, 2009 at 12:48 pm
Personally, I am a huge fan of the DbFit tool (hence: http://www.sqlservercentral.com/articles/Testing/64636/). I like it because it not only provides repeatable, automated testing (both from GUI and from command-line),...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
July 1, 2009 at 10:19 am
Florian Reischl (7/1/2009)
@Solomon RutzkyJust want let you know, your article is referenced in current German SQL PASS newsletter! 😉
Sweet! Danke for sharing :-).
Zai Gezundt.
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
July 1, 2009 at 9:42 am
Glad you found it helpful. 🙂
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
June 30, 2009 at 9:41 pm
Sam Stange (6/29/2009)
For those stuck at 8000 bytes setting for MaxByteSize, SQL Server 2008 has bumped this amount to 2 GB! Just set MaxByteSize = -1.
Hi Sam. Yes, in...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
June 29, 2009 at 7:25 pm
john hill (5/29/2009)
I downloaded your code and tried adding an option to do an import via SQLXML...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
June 1, 2009 at 8:18 am
LP:
Correct: I had not thought of the XML solution and so that would be an incorrect statement that I made about single inserts being the “only” way to load data....
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 28, 2009 at 11:05 pm
Hello "dm_unseen" and thanks for that suggestion.
Matt Whitfield (5/28/2009)
A minor benefit...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 28, 2009 at 7:19 am
SanjayAttray (3/27/2009)
Good article, Solomon. Will try to implement it on our siebel server.
Hello Sanjay and thanks. However, the author of this article is Ryan Cooper so he...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 27, 2009 at 11:40 am
Excellent article! Thanks 🙂
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
December 14, 2008 at 10:51 am
Thanks for this list. Very handy info 🙂
Another free tool is SQL# (SQLsharp). SQL# is a CLR-based suite of over 120 Stored Procedures, User-Defined Functions, User-Defined Types, and...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
December 4, 2008 at 8:57 pm
Viewing 15 posts - 601 through 615 (of 646 total)