General

This category contains general information relating to SQL Server

Return the MAX of all dates within all tables within all databases

0
10 months ago
in ,
I wanted to produce a list of the MAX of date fields (DateTime, SmallDateTime, TimeStamp) for all tables within all databases held in an instance of SQL Server. The script below was written for SQL Server 2000, but should be easily customisable for SQL Server 2005 As always, please ensure you test [...]

Maintenance Plan Error “Server: Msg 22029, Level 16, State 1, Line 0 sqlmaint.exe failed.”

1
1 year ago
in
Earlier today, I discovered that the database maintenance plan on one of our SQL Server machine wasn’t working. When I reviewed the logs, it simply said “sqlmaint.exe failed”. I ran the following command (copied from the SQL Server Agent job) using Query Analyzer (as this was a SQL Server 2000 [...]

SQLBits – The 7 Wonders of SQL

0
1 year ago
in
www.sqlbits.com SQLBits – The 7 Wonders of SQL conference, is taking place from September 30th to October 2nd at York University. SQLBits is the largest SQL Server conference in Europe and the previous six conferences have established it as a must-attend event for DBAs, developers and BI [...]

FREE Level 400 SQL Server Performance Monitoring and Tuning Webcasts

0
1 year ago
in
FREE Level 400 SQL Server Performance Monitoring and Tuning Webcasts at http://www.sqlworkshops.com/webcast This is a great resource for performance monitoring and tuning

Red Gate’s SQL Search

0
1 year ago
in
Hi. I have just downloaded Red Gate’s FREE SQL Search tool from http://www.red-gate.com/products/SQL_Search/index.htm Features: Find fragments of SQL text within stored procedures, functions, views and more Quickly navigate to objects wherever they happen to be on your servers Find all references [...]

SQL Server Versions

1
2 years ago
in
I have just found a very good website that lists the various version numbers for SQL Server.  You can see from the list which services packs and updates have been applied. http://www.sqlteam.com/article/sql-server-versions

Save (Not Permitted) Dialog Box

0
2 years ago
in
The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created. The following actions might require a table to be re-created: Adding a new column to the middle of the table Dropping a [...]

Non-clustered indexes

0
3 years ago
in
When creating non-clustered indexes, you should never include the clustered index key fields (commonly used for the primary key) as part of the non-clustered index. This is because the fields will always be used within queries.  There is no need to specify them again. The only exception to this, [...]
Go to Top