Ask Paula!

...bringing you notes from the field...

  Home  |   Contact  |   Syndication    |   Login
  147 Posts | 5 Stories | 133 Comments | 0 Trackbacks


Copyright © 2008-2018 Paula DiTallo

Tag Cloud

Article Categories


Post Categories

.NET Development

Enterprise Integration

Entertainment - Games

Java Development

Mobile/PDA Development

Professional Affiliations

December 2015 Entries

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 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 ......

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 AS 'SchemaName' , 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 = 'Schema' AND = 'TableName'GROUP BY,o.nameORDER BY,;GO ......

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 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%'; ......