2007-04-24 (first published: 2007-04-05)
389 reads
MS Word VBA to Format T-SQL Text as Rich Text
This VBA script was written for MS Word. It formats the text and sets default colors for keywords. SQL 2005's Management Studio now does this by default but the previous Query Analyzer did not offer this functionality. This is useful if you prefer to print and review code from time to time (not recommended for […]
2006-01-23 (first published: 2006-01-11)
216 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
To show the count per month from the date provided
I have two tables namely Vendors & Visits. Create Table Vendor (VendorId BIGINT IDENTITY(1,1)...
Two tables per page
I have this report, see below, that works great. Enter the employee number and...
How to find out HOW MANY inserts, HOW MANY updates happend in merge
How can i get the counts of how many records updated and how many...
Ask SSC