In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.
2020-07-09 (first published: 2019-09-24)
22,523 reads
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
22,062 reads
User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax.
2017-07-21
5,686 reads
It's a well known fact that Scalar UDFs are the stuff of performance nightmares in T-SQL. But are they really as bad as they say? SQL Server MVP Jeff Moden shows us that they might not really be as big a problem as you might think and what you can do when they actually are.
2014-06-24 (first published: 2012-08-01)
24,601 reads
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-07
12,319 reads
A useful SQL function to parse a single string with delimited values for the "N"th occurrence
2009-11-06 (first published: 2009-10-15)
1,347 reads
Hi everybody,When i send E-mails through SQL Mail, they end up in the inbox of MS Outlook account. Only when i press 'send' mails are sent. I have Microsoft Outlook 2002. I have configured my Hotmail account in it as i don't have MS Exchange.I have SQL Server 2000 with Service Pack 3. And my […]
2005-01-28
quote: I agree also with the normalization aspect as well. Unfortunatly sometimes in the real world (or at least my world ) we get handed a probelem and have to deal with it. And I appreciate all the people who really try to help solve it. and to the rest I enjoy learning new words […]
2003-12-23
It was very tricky ... and annoying. The next QOD should be: "write a query to grant 2 points to all people that answered "none of the above"
2003-12-17
1 reads
We have to use a VPN to connect to a remote system to download data, then upload it to a local server. The VPN client software closes all other ports while connected, so none of the local servers can be seen (except for the database on the VPN client computer). The client software also requires […]
2003-11-17
1 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers