Forum Replies Created
Viewing 15 posts - 631 through 645 (of 646 total)
-
RE: Searching Objects for Text
Thanks, Jaroslaw, for the compliment and for the code. I will incorporate that into the next version.
PS. Regarding the Linked Server name: yes, it is best in brackets...
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 -
RE: The CLR
Matt Miller (5/13/2008)
All right - let me wipe the egg off my face for a second. You're right - I overlooked the SQLChars as an output parameter for Functions....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 -
RE: The CLR
developmentalmadness (5/13/2008)
- the Table-valued functions need to materialize their entire recordset before being able to return anything, so they can quickly "swamp" the memory area.
This is true for...
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 -
RE: The CLR
Tom Garth (5/13/2008)
Pardon the redundacy, but does anyone have knowledge of, or better yet experience, porting 32 bit CLR functions to a 64 bit SQL Server.I'm pretty sure that the...
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 -
RE: The CLR
JohnG (5/13/2008)
inexplicably not able to handle outputting Varchar(MAX), being stuck instead @ varchar(8000), so you can't play with the full specturm should you need to.
That's a real bad limitation! ...
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 -
RE: Tip for determining I/O Heavy Queries
Gary G (11/9/2007)
Do you know anyway to actually capture the SQL being executed?Hey again, Gary. Now, some events simply do not offer that much info, unfortunately. However, I...
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 -
RE: Tip for determining I/O Heavy Queries
KB (11/8/2007)
But when I try to implement the trigger provided by Solomon on table IndexCapture ( I changed the table name in the trigger), the trigger gets created successfully but...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 -
RE: Tip for determining I/O Heavy Queries
Gary G (11/8/2007)
What could be causing this lack of content in the TextData column?
Hello Gary. I don't think I mentioned this in my article, but one requirement of the...
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 -
RE: A New (and Hopefully Better) Approach to Constants
Jonathon Prosper (10/21/2007)
On another note I do appreciate you sticking your head out and writing the article on what is a common database design issue. I'd hate to think that...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 -
RE: Oracle
I haven't used Oracle since 8i (if I remember correctly) but here are two things that I loved about Oracle and really miss in SQL Server:
1) BEFORE triggers: SQL Server...
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 -
RE: Capturing Missing Information From SQL Profiler
Hello Noel and thanks. While I do agree that triggers 99% of the time should be coded to handle batches, I felt it was a good assumption here that since...
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 -
RE: Hibernate
Please see discussion at:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=375196
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 -
RE: Am I Old-Fashioned?
Please see discussion at:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=375196
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 -
RE: n-hibernate and dynamic sql - DBA vs Developers
(sorry this is so long but "the devil is in the details"
)Hello. I am a DBA facing pretty much the same issue...
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 -
RE: Cannot pass string longer than 4k to C# SP
As someone who had the same problem and was excited to find this thread and was then disappointed to not see the answer, I felt I would share...
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
Viewing 15 posts - 631 through 645 (of 646 total)