The above query returns all unused indexes of all types. This query can frequently be found on the internet but isn’t an ideal/complete option. By using such a query to find and clean unused indexes may lead to unexpected behavior because this query does not take into account primary key ...
how to find the all databases sizes in sql server 2000 ? How to find the last execution time of stored procedure sql server 2005 How to find the most expensive operation in an execution plan - need to read xml and sort on calculated field How to find the space taken by Schema wise i...
One of my Application server has been restarted yesterday, we would like to know how to find the login information and the IP details of the server. Please help me how to get the information who did restarted SQL services! Thanks in advance, DBA DBAQuestion is quite confusing, if your sq...
1. Determine what version of SQL Server you have and double-click the link below to download the zip file of SQL templates. In the zip file, click on the TRACETMPL folder and double-click on the .tdf file for your version and SQL Profiler will automati...
quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip “Simple way to find errors in SQL Server error log” you discussed a method of searching the error log. Are there any other ways to search and find errors in the error log files...
It is located at %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\Detail.txt. If an error occurs during the Setup process, the exception or error are logged at the end of this file. To find the errors in this file, first examine the end of the file followed...
Select the Build tab if you're in a C# project or the Compile tab if you're in a Visual Basic project. On the Build/Compile page, enter the path to the Report Designer folder. The default path is C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE) in the Ou...
SQL Server How to find particular character in string [closed]It seems that you are having CSV ...
But the better way to run server side trace. You can export trace definition and run the script to do that. I’m not going to focus on the details how to set it up – you can find information in Books Online. So let’s see what information that trace produces. Let’s run the blo...
-- Microsoft SQL Server string to date conversion - datetime string format sql server -- MSSQL string to datetime conversion - convert char to date sql server -- Subtract 100 from style number (format) for yy instead yyyy (or ccyy with century) ...