Finding unused objects11071 (9/12/2010 8:03:48 AM) Using the following DMV I get to know which of the objects in the DB is in use
dm_exec_trigger_stats, dm_exec_procedure_stats, dm_db_index_usage_stats
Is there a DMV to have this data about a View?
Possible problem with differential backups7242 (9/8/2010 5:30:35 PM) Hi all,
I have a 170GB OLTP database that only processes INSERTs and SELECTs,
no UPDATEs or DELETEs. I add about 1.8GB of data every day, as
verified with my transaction log backups taken every 15 minutes. A... JoshBond
SQL IN3283 (9/10/2010 8:03:05 PM) Hi all,
Using ASP.NET, SQL SVR Express 2008
I want to use IN to select records that have one of a list of values like
SELECT * FROM MyTable WHERE MyField IN ("Value1","Value2","Value3")
MS SQL 2005 to SDF0302 (9/10/2010 6:38:41 PM) I want to convert a MS SQL 2005 Database to sdf (Compact), and include all
the tables, views and stored procedures.
Is there a good tool available to do this or can it be done thru SQL Server
Management ... Brian
Mirroring: High safety. (Data loss question).1243 (9/10/2010 9:40:35 AM) This is a multi-part message in MIME format.
Locking in merge statement2713 (9/10/2010 11:52:46 AM) Hi All,
I have a table which contains some status information.
Table1 (device varchar(200) primary key, NumberOfUsage int)
Now I have a store procedure in which I would like to insert new
devices, if they... schaf