0
POPSdotNET, ASPNET, SQLSERVER, VBNET, & CSharp Video Tutorial Instructors http://myqol.com - When looking for an instructor, it is good to seek out the very best. The video presenters listed here represent the "ivy league" for dotNET technology. These instructors know their material backwards and forwards and can present it in a streamlined manner. We need to know the material backwards and forwards too. We need to be able to "think in code" in the same way that most people "think in words." These videos present over 50 very interesting people to get to know. Please click on the links to view their bios, blogs, and photos.
0
POPSProgramming Philosophy Underlying IdealProgrammer.com http://idealprogrammer.com - Brief overview of the philosophy behind idealprogrammer.com website. Shows how we feel tension when we fall short of being our ideal self and how we can reduce that tension by taking massive, intelligent, and organized action.
1
POPSSQL Server 2005 List all IDENTITY columns When I upgraded one of my databases to MSSQL2K5 compatibility mode, I noticed that many of my insert statements on tables with identity columns started generating primary key violations. I realized that I needed to run DBCC CHECKIDENT on all of those tables to fix the problem. I found this script, which lists all of the tables, in a database, that have identity columns. Then a copy/paste and regex search/replace generated a script for me to run the DBCC CHECKIDENT for each table listed. After running the DBCC CHECKIDENT, the problem went away.
0
POPSTable Spool should alert you to a potential problem I was looking at a query plan today and saw a Table Spool icon. I had never seen one of those before. I thought that it might not be so great. I found this little bit of text on spooling data to work tables and thought it was interesting.
Pops
Newest Clips
Latest Comments
Most Pops
Print
Save
Turn on live update