Hello Ravi, There are two ways in which you can start SQL Server: - Open the Control Panel from the Start Menu and go to the Services applet. You...
Hello Ravi, You mean you are trying to connect to the SQL Server from Query Analyzer? Because you are writing "start the server using query analyzer...
Hello, May I ask what you get back currently and could you also send the query you are issuing? I would imagine (but can't try at the moment) that if...
Hello, Have you had a look at sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats (doc'ed in Books Online)? If you do a web search,...
Hello again, Glad we cleared out you first concerns! I am not sure I understand your follow up question though - are you wondering whether a large...
Hello, You can use the following SELECT to see all permissions explixitcly granted on an object (or securable as it is called): SELECT * FROM...
Hello Thulasi, You made the right decision, it is NOT a good idea to put any backup files (database or transaction log backup) on the same disk(s)...
Hello Shawn, Is this by any chance a cluster and 2003A is a node in that cluster? Do you see anything different if you are logged on locally on...
Hello, Yes but ultimately is due to what you are doing in your code and that's also where you have to solve the problem - not in the SQL Server. This...
Hello John, Have a look at http://blogs.technet.com/cotw/archive/2009/03/18/analyzing-storage-performance.aspx for a walk-through on the different IO...
Hello Fais, The whole point of "replication support only" is to not apply the snapshot at the subscriber. If you must use this option - even though...
Hello Sandy, Provided that you have left the settings for your database with the default values, statistics are automatically created on all your...
Hello, I am sure you, although perhaps not your manager, realize it is quite impossible to answer those questions. It's a little bit like asking "how...
Hello Sachin, Could it be there is not enough diskspace to perform the shrink operation? What does DBCC SHRINKFILE or this code snippet return:...
Hi, This quick and dirty script will give you the Filegroup and then 1 row for each File in that Filegroup (the heap or clustered index - indid 0...
Hi Stefano, Re-start SQL Server with the -f flag. This bypasses your configuration and starts up SQL Server in minimal configuration mode. You can...
Hi, You need to re-create the table/indexes on the new filegroup. If you have a clustered index, recreating that will move all your data. You then...
Hi John, That sounds just about right! However, bear in mind that SQL Server heavily favours sequential reads because they are so much faster than...
Hi John, The clustered index is the table with all pages sorted on the clustered index key.¨If you create a table with just a non-clustered index,...
Hi John, Basically there are 3 different structures; heap (which is a table that has no clustered index), clustered index (which is the table sorted...
Separate names with a comma.
