Replacing Cursors with Set-Based SQL Queries – Part 2
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a recent post I discussed...
2011-07-06
12,480 reads
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a recent post I discussed...
2011-07-06
12,480 reads
A brief mention that we are done with the school year flip process for transitioning to the new school year.
I...
2011-07-01
800 reads
Part 1 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a previous post I discussed...
2011-06-27
7,964 reads
A discussion of how Google can serve as an invaluable resource when facing a SQL-based challenge.
Today I briefly want to...
2011-06-23
732 reads
A discussion of how a separate database is used for storing table backups.
In a recent article, one of the things...
2011-06-20
880 reads
Why being careful is such an important mindset when working with SQL and databases.
At the Boston Public Schools, certain processes...
2011-06-17
1,126 reads
A small post regarding a couple SQL books I bought from Amazon.
A couple new books arrived in the mail from...
2011-06-15
842 reads
A continuation of the data dictionary discussion with information about how the documentation is done.
Today I’m going to continue discussing...
2011-06-13
1,468 reads
A brief discussion and links to a series of YouTube videos from Stéphane Faroult.
I’ll continue the discussion of the table...
2011-06-11
1,201 reads
Why table and column documentation is useful and some SQL for setting up the data dictionary tables.
At Boston Public Schools,...
2011-06-10
1,855 reads
Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
Access db wanting to move sql server, how much control does business have over...
I'm trying to create an SSIS package that will query a master control table...