Many of you might be missing the "Show Server Trace" feature of SQL Server 2000 Query Analyzer in SQL Server 2005 Management Studio. As per the request filed in Microsoft Connect , the feature was introduced with a little tweak where by you can press...

If you are using Task Manager to monitor the Memory Usage of SQL Server, please note that Working set shown in Task Manager for SQL Server does not include memory committed by SQL Server using AWE allocations and Large pages. Also "Total Server Memory...

Code of sqlservr.exe and any other dll's it depends on need to be loaded into SQL Server memory space for execution. So if you are having VAS fragmentation, there are multiple causes and one of the cause is numerous dll's loaded by extended stored procedures...

While I was talking to a customer during a replication scenario, customer asked me a question about understanding the estimated completion time for a rollback. I was explaining that we have KILL WITH STATUSONLY but it will just report the progress...

Here is a handy reference for converting Page ID offset address to corresponding Page Number in SQL Server 2000: As per http://support.microsoft.com/kb/828339 : <offset>: This is the physical byte offset from the start of the file. Dividing...

Extended Events introduced in SQL Server 2008 is a detailed event infrastructure for SQL Server. If your environment is running with more SQL Server's of version > 2008, it is the right time to learn about Extended events since they help you a lot...

SQL Server has encountered x occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Drive:\MSSQL\MSSQL.1\MSSQL\Data\xyz.mdf] in database [database]. The OS file handle is 0x00000000. The offset of the latest long I/O is: 0x00000000000000...

You can check the status of a SPID using any of these queries: SELECT status ,* FROM sys . sysprocesses SELECT status ,* FROM sys . dm_exec_requests SELECT status ,* FROM sys . dm_exec_sessions EXEC sp_who2 It should be noted that all these...

I know that there are lot of articles over the internet world with this topic... But this article is from my perspective which has detailed troubleshooting steps... The main problem with troubleshooting connectivity issues with SQL Server is because...

I wrote this script today and thought of sharing since it might be useful for you. I wrote it because there is no option to set rollover of a existing server side trace and we have lost the original script which created this server side trace in SQL Server...

I was working in a SQL Server 2005 setup case which failed while starting SQL Service with error: SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed...

Error: Installating DEFAULT instance of SQL Server 2008 R2 Express Edition with Advanced Services on a Windows 7 64bit with AMD Phenom(tm) II X4 945 Processor failed with error: --------------------------- Rule Check Result -----------...

I worked on a customer service request where SQL Server 2008 Enterprise edition installation was throwing error: Wait on the Database Engine recovery handle failed. After examining SQL Error log from the Setup logs folder, noted: 2010...

Designing an effective SQL Server backup/Restore strategy Designing an affective backup and restore strategy is required to bring database online when you encounter these situations: 1. Database gets corrupted due to I/O issues 2. Need to roll...

Here is how to find out who is connected to your server when you are in single user mode : METHOD 1: ------------- à Start your SQL Server in normal multi-user mode and enable login auditing for both successful and failed logins ...

Hello! My name is Sakthivel Chidambaram. I work with SQL Server Product Support team at Microsoft. I'm going talk about some simple SQL stuffs here. Have a great day! Legal Disclaimer: These postings are provided "AS IS" with no warranties...