Finding unused objects12017 (9/12/2010 8:03:48 AM) UtfUsing 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 backups7771 (9/8/2010 5:30:35 PM) JoshBondHi 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...
SQL IN3789 (9/10/2010 8:03:05 PM) kpgHi 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 SDF0834 (9/10/2010 6:38:41 PM) BrianI 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
Mirroring: High safety. (Data loss question).1775 (9/10/2010 9:40:35 AM) benThis is a multi-part message in MIME format.
Locking in merge statement21376 (9/10/2010 11:52:46 AM) schafHi 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...