Search Results

Conversion from GUID to integer;

Thread by: jr81, Jan 26, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, We have a database in sql 2000 where there are number of GUID columns, we want to migrate the database to sql 2008. I was wondering whats the...

Alter database modify file

Thread by: jr81, May 30, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, If i increase the database size by running alter database modify file, command, will it lock the whole file/filegroup? how can i check what...

SQL Server restarting itself and closing connections;

Thread by: jr81, Apr 9, 2008, 11 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, We have a 2 node active/passive 32 bit sql 2005 9.0.3200 cluster SERVER A. The total memory on the box is 8 GB, sql is allocated 6 GB. AWE is...

Distributed Transaction

Thread by: jr81, Nov 19, 2007, 2 replies, in forum: SQL Server 2005 Integration Services

Hi, I have a SSIS server which has a package,the package is trying to update/insert two sql server boxes all the three boxes are in the same domain....

DBCC memorystatus returns 0 for AWE allocated

Thread by: jr81, Nov 14, 2007, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi, I have two x64 clusters, both have 8 GB of memory. Both the servers have lock pages in memory for sql server service account.This KB article...

Lock Pages in Memory X64 server

Thread by: jr81, Nov 14, 2007, 7 replies, in forum: SQL Server 2005 T-SQL Performance Tuning