December 2015 Entries

GMAIL: How do I get rid of all the emails in a folder?
This took me longer than it should have to figure out. In just a few simple steps, all those emails can easily be dealt with in sets.Go to the folder you are interested in.click the top check box--or the "select all" . You'll see a text line appearing just above the trash can icon that says something like "All 999 conversations on this page are selected." (see below).Click on the underlined text that says "Select all 999 conversations in YourFileFolderName". The text line will change to something ......

Posted On Wednesday, December 30, 2015 5:12 PM | Comments (0)

SQL Server: Alternative to Count(*) for VLDB
If you have a very large data base (VLDB) a select count(*) can take a long time to resolve. Try this statement as an alternative:USE YourDatabasename;SELECT s.name AS 'SchemaName' ,o.name AS 'TableName' ,SUM(p.row_count) AS 'RowCount'FROM sys.dm_db_partition_stats p JOIN sys.objects o ON o.object_id = p.object_id JOIN sys.schemas s ON o.schema_id = s.schema_idWHERE p.index_id < 2 AND o.type = 'U' AND s.name = 'Schema' AND o.name = 'TableName'GROUP BY s.name,o.nameORDER BY s.name,o.name;GO ......

Posted On Friday, December 4, 2015 8:26 AM | Comments (0)

SQL: Locate stored procs, views, etc. by text
This will locate specific text within an object on a given database. In this case, it will find all views, stored procs which have the text string "Department" somewhere in the body.use [databaseInstance]goSELECT DISTINCT o.name AS Object_Name, o.type_descFROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition Like '%Department%'; ......

Posted On Tuesday, December 1, 2015 12:24 PM | Comments (0)