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
School Data Move Done!
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
Replacing Cursors with Set-Based SQL Queries – Part 1
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,963 reads
Google as the Ultimate SQL Repository
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
Table Backups and the TableArchive Database
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
Being Cautious With SQL Based Processes
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
SQL Books Arrived Today
A small post regarding a couple SQL books I bought from Amazon.
A couple new books arrived in the mail from...
2011-06-15
841 reads
Database Documentation with a Data Dictionary Part 2
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
Some Good SQL-Related YouTube Videos
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
Database Table Documentation with a Data Dictionary
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,850 reads
Blogs
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Introducing… Data On Rails!
By DataOnWheels
Data On Rails is a Data On Wheels project designed to give a platform...
Forums
"ID" primary key from two separate tables as a foreign key in a new table
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
blocking issue
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
Identity column and "EntityID" column naming convention
This isn't* specific to 2022, but SQL in general. I will be joining a...
Ask SSC