These are good links when getting error "Out of memory"  when running report in Reporting Service 2005.

http://msdn2.microsoft.com/en-us/library/ms156002.aspx

http://blogs.msdn.com/lukaszp/archive/2007/01/31/how-to-diagnose-issues-when-running-reports-in-the-report-server.aspx

Truncating a data file

USE AdventureWorks;
GO
SELECT file_id, name
FROM sys.database_files;
GO
DBCC SHRINKFILE (1, TRUNCATEONLY);

To genereate a random number in SQL Server we can use random function.  Check example below where a random generated number is between 1 and 100:

Upgrading from SQL Server 2000

To alow darta access through linked server using OPENQUERY we need to set set linked server "DATA ACCESS" option to true:

MSQL_XP is the  wait type that occurs when a task is executing an extended stored procedure - XP. SQL Server does not have control over an XP even though it is executing within the SQL Server process. Investigation of these waits requires investigating the execution of the extended stored procedure code—the vendor may have provided diagnostic tools for the < ...

Emptying a file

sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO

Create a new trace in Profiler and select the "Blocked Process Report" event listeds under the "Errors and Warnings" event category.

After this setup, you should see all blockings taking longer than 10 seconds using this trace.

Microsoft released Service Pack 2 for SQL Server 2005. You can download the SP2 here.

Some of the changes are

To  download SQL Server 2005 Service Pack 1 visit: http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

To  download SQL Server 2005 Service Pack 2 visit: http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en

To download SQL Server 2005 service packs, tools, trial software visit: http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx

Importing Images with textcopy utility.

Use textcopy.exe utility. Check this: http://www.databasejournal.com/features/mssql/article.php/1443521 or http://www.windowsitlibrary.com/Content/77/03/4.html or http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm

In SQL Server 2005, the system tables are gone. The system tables from previous versions of SQL Server are now implemented as a series of views called catalogue views and all of these catalogue views can be found in the sys schema.

select * from sys.all_views

declare @tabid int
declare @tabname nvarchar(100)
set @tabid = 7
--select * from tabs where tabid = @tabid
select @tabname = tabname from tabs where tabid = @tabid
--select * from tabs where IsVisible = 1 and ParentID is null
select top 10 DIFFERENCE(@tabname,tabname),@tabname,tabname from tabs where IsVisible = 1 and ParentID is null order by DIFFERENCE(@tabname,tabname) desc

EXEC master.dbo.

SQL Server Injection

Great article and great tools:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1159434,00.html#

SQL Server Security Hacks
Top 15 free SQL Injection Scanners
http://www.security-hacks.com/2007/05/18/top-15-free-sql-injection-scanners

HP WebInspect performs web application security testing
...