Viewing 15 posts - 361 through 375 (of 646 total)
rmechaber (4/14/2015)
So there seems to be no intrinsic reason why tools or suites or packages included as ancillary components to the engine cannot or will not be adopted by 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
April 14, 2015 at 3:50 pm
DennisPost (4/8/2015)
I've made that mistake before and seen others make it. It can be tricky to detect.
A colleague told me of a nifty trick today.
When releasing a trigger...
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
April 9, 2015 at 12:07 am
Eirikur Eiriksson (4/4/2015)
Solomon Rutzky (4/3/2015)
fw200811 (4/3/2015)
Moved to SQL Server 2012 specific forum.Link to moved post?
That would be here
😎
Thanks Eirikur. Just FYI, the link you posted was wrapped in JavaScript 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
April 6, 2015 at 12:11 pm
Hi there. Please post the exact error message. Thanks, Solomon..
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
April 6, 2015 at 12:09 pm
fw200811 (4/3/2015)
Moved to SQL Server 2012 specific forum.
Link to moved post?
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
April 3, 2015 at 12:24 pm
Eirikur Eiriksson (3/30/2015)
Tossing in my 2 Cents, I feel the NULL/Nothing/Unknown/Empty discussion is digressing towards the ancient NULL debate.
I don't know about "ancient". It seems to be alive and well....
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 30, 2015 at 3:50 pm
mister.magoo (3/30/2015)
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 30, 2015 at 9:07 am
TomThomson (3/26/2015)
Solomon Rutzky (3/26/2015)
peter-757102 (3/26/2015)
Because a row functionally constitutes an identified sub-string in compliance with the declared separator, I would expect no rows at all with NULL as input.
An empty...
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 29, 2015 at 12:13 pm
Theo, I just found something that might help.
Is it safe to say that you are only checking mount points where you currently have data and/or log files? These are 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
March 26, 2015 at 10:58 am
peter-757102 (3/26/2015)
Gary Harding (3/26/2015)
Solomon Rutzky (9/4/2014)
Jeff Moden (9/3/2014)
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 26, 2015 at 10:01 am
dwain.c (3/17/2015)
brett 41274 (3/17/2015)
• Normally if you execute a standalone (“atomic”) INSERT, UPDATE, DELETE or MERGE statement you don’t really need...
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 19, 2015 at 2:38 pm
peter.barnet (3/17/2015)
I would have thought that a SQL CLR function would provide the ideal solution here?
It does 🙂
.NET is the right language to process complex types in a RBAR/loop...
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 19, 2015 at 2:09 pm
Nuhamovici (3/19/2015)
Can you share the code that does this? Calling sp_who from within a function?
I cannot think of a reason why anyone would even be using sp_who, let alone want...
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 19, 2015 at 10:39 am
jeffrey yao (3/13/2015)
Really love this SQLCLR series. Many thanks Solomon for your hard-work.
Hi Jeffrey. You are quite welcome. And thank you for sharing that :-).
Take care,
Solomon..
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 17, 2015 at 2:00 pm
SumOfDavid (3/11/2015)
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 11, 2015 at 3:50 pm
Viewing 15 posts - 361 through 375 (of 646 total)