Learn how to leave those Cursors and loops in the thrash, Nash... An article from longtime contributor and SQL expert, Barry Young.
2010-06-30 (first published: 2009-04-14)
33,932 reads
2009-04-13
4,695 reads
2009-04-09
4,159 reads
This article by new author Glen Schwickerath uses dynamic SQL and SQL Server 2008's MERGE statement to create a useful stored procedure tool for synchronizing tables.
2009-04-07
18,726 reads
2009-04-06
4,521 reads
Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.
2009-04-02
2,311 reads
Function to take a number as a string and return it with commas separating thousands, millions, etc.
2013-06-07 (first published: 2009-03-31)
2,413 reads
2009-03-26
4,737 reads
A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.
2009-03-18
3,116 reads
2009-03-17
4,085 reads
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
We value your privacy. This policy explains what personal data we collect and why. What...
Why would using variables in place of hard coded numbers impact a query's performance? ...
Hello SSC! I have been tasked with optimizing a stored procedure the imports data...
Hey everyone, I'm trying to access an XML file download from a government website...
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers