I read the other day about indexing small tables I’d like to test this on my database but first I would need to find out which tables do not have an index and/or a primary key. Pinal Dave wrote about finding tables without a clustered index or a primary key: SELECT DISTINCT [TABLE] = OBJECT_NAME(OBJECT_ID) [...]
Archive for August, 2009
Find Out Tables With No Primary Key/Index – SQL Server 2005
Posted in SQL Server, tagged diagnostic, performance, tips on 11 August 2009 | Leave a Comment »
Querying sp_who2
Posted in SQL Server, tagged tips, tsql on 7 August 2009 | Leave a Comment »
Wouldn’t you wish sometimes you can just query the sp_who2 results? The only way to do this is to create a temporary table to dump the result, and then query the table. You can use SELECT statement as per normal. CREATE TABLE #who (SPID INT, Status VARCHAR(1000) NULL, Login SYSNAME NULL, HostName SYSNAME NULL, BlkBy [...]
Uninstall SQL Server 2005 Express Instance
Posted in SQL Server, tagged administration, installation on 5 August 2009 | Leave a Comment »
Following my previous post on how to uninstall SQL Server 2008 instance, this time I am writing about how to uninstall the SQL Express 2005. Here’s the thing: I have already had a SQL Server 2005 Developer instance when I installed the SQL Express 2005. I can’t tell apart the double-installed SQL Server 2005, so [...]
