Update Statistics for databases where you have access
Run this stored procudure to update statistics for those SQL Server databases where you have permission
2015-01-27 (first published: 2015-01-08)
1,228 reads
Update Stats
RE: help with rewriting query (performance optimization)
Barring me having botched order here since I don't have anything to test against this should be pretty colse to what you are after.SELECT ST.student_id, ST.last_name + ', ' + ST.first_name + '(' + ST.grade + ')' AS [Name], R.program_provider_activity_id, PPA.program_activity_name + ' Currently Reg : ' + (CASE WHEN (R.registration_is_active = 1) THEN 'Yes' […]
2005-01-21
RE: Best way to change the data type of a replicated column/table
Nicholas,Thank you for your reply - I have never scripted replication before, how should I do this?
2004-06-15
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers