T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.
2008-06-13 (first published: 2006-01-17)
55,042 reads
Reporting Services was one of the most popular add-ons to SQL Server 2000 and the next version has been greatly improved. Author Kamran Ali brings us a look at some of the new features and enhancements in this platform.
2006-02-22
19,760 reads
By Steve Jones
I wrote about arrays in PowerShell last week, but I realized one of the...
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
I recently created a synapse link for Dataverse. The resultant Lake Database in Synapse...
This is something I've never seen before and I can't think of the right...
Hi All, I need some assistance and not sure how to achieve the expected...
Ask SSC