Navigation | Category » Database
Here is a simple to create and drop temp tables:
to think that ALL temp tables reside in tempdb database, not releated to the user database at all, and it’s same for Global temp tables (##temp) which is why this would work in any User database.
IF OBJECT_ID(‘tempdb.dbo.#tempTable’) IS NOT NULL
DROP TABLE #tempTable
CREATE TABLE #tempTable [...]
Filed by Paul Gu at June 11th, 2009 under Database, Programming
No comments on this post yet
Execution of the BizTalk Server SQL Agent jobs are crucial for managing the BizTalk Server databases and for maintaining optimal performance. The Backup BizTalk Server job is the only supported method to backup the BizTalk Server databases and requires that all of the BizTalk Server databases are configured to use the SQL Server full recovery [...]
Filed by Paul Gu at February 10th, 2009 under BizTalk, Database
2 persons have commented this post
As BizTalk Server processes more and more data on your system, the BizTalk Tracking (BizTalkDTADb) database continues to grow in size. Unchecked growth decreases system performance and may generate errors in the Tracking Data Decode Service (TDDS). In addition to general tracking data, tracked messages can also accumulate in the MessageBox database, causing poor disk [...]
Filed by Paul Gu at February 9th, 2009 under BizTalk, Database, Programming
No comments on this post yet
This error is probably one of the most frustrating ones for the SQL Server database folks. MSFT has an excellent KB article that covers the details on how to fix this issue – KB 811889. It goes into the details of Kerberos and NTLM, registering and de-registering SPNs etc..
At one of the client sites, [...]
Filed by Paul Gu at October 8th, 2008 under Database
No comments on this post yet
I continue to get this error whenever i try to use the Taskpad view of adatabase in my SQL Server Entriprise Manager.“An Error has occurred in the script on this pageLine: 307Char: 2Error: Unspecified ErrorCode: 0URL: res://C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html
Do you want to continue running scripts on this page?”
with Yes and [...]
Filed by Paul Gu at June 13th, 2008 under Database
2 persons have commented this post
Is it impossible to shrink the Trucated Log file?
Yes, following code always shrinks the Trucated Log File to minimum size possible.
1) Replace DatabaseName with your database name
2) Replace TransactionLogName to database log name
USE DatabaseName
GO
DBCC SHRINKFILE(TransactionLogName, 1)
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY
DBCC SHRINKFILE(TransactionLogName, 1)
GO
Is is simple?
Filed by Paul Gu at May 26th, 2008 under Database
No comments on this post yet
DELETE logs the data for each row affected by the statement in the transaction log and physically removes the row from the file, one row at a time. The recording of each affected row can cause your transaction log grow massively if you are deleting huge numbers of rows. However, when you run your databases [...]
Filed by Paul Gu at April 8th, 2008 under Database
No comments on this post yet