Want to see all stored procedure in database at once? Run SELECT * FROM sys.procedures. This simple query works only with SQL Server 2005.
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
What is Third Normal Form and what is its advantage? I ask this in every interview I take. Here are the rules of 3NF and its cost in performance.
SQLAuthority News – SQL Server Compact 3.5 Downloads and ReportViewer Visual Studio Download
SQL Server Compact 3.5 downloads in one place: Books Online and samples, the Windows Mobile install, and the ReportViewer Visual Studio download.
SQL SERVER – Upgrade Advise – From 2000 to 2005 or 2008
Should you upgrade from 2000 to 2005 or 2008? My advice: move to SQL Server 2005 with Service Pack 2 now, as SQL Server 2008 needs time to settle.
SQL SERVER – 2008 – November CPT5 New Improvement
What is new in the SQL Server 2008 November CPT5 build: IntelliSense, Resource Governor, backup compression, Transparent Data Encryption and geo-spatial support.
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.
SQL SERVER – Generate Incremented Linear Number Sequence
A reader asked how to generate an incremented linear number sequence in SQL Server, like a sequence in Oracle. A short WHILE loop script does it.