Search Results | SQL Server Performance Forums

Final data file size

Thread by: Joben, Apr 6, 2011, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, How do we get the final size of the data file? Can somebody please let me know. Thanks

spid in sleeping mode

Thread by: Joben, Mar 21, 2011, 1 replies, in forum: General DBA Questions

Hi Everybody,Why does a query get into sleeping status? Does it take any resource?Is there any way that we can find which query is in sleep status?...

How to configure SQL server

Thread by: Joben, Feb 5, 2011, 3 replies, in forum: SQL Server 2008 General DBA Questions

Hi Friends, Can somebody please let me know any articles, case studies or their own experience on what needs to be done while planning and...

TempDB Configuration

Thread by: Joben, Feb 5, 2011, 3 replies, in forum: SQL Server 2008 General DBA Questions

Hi, Can somebody please let me know that how we can have SQL to select the drive that we want when SQL server starts. Thank you for your help!!

SQL Query

Thread by: Joben, Jan 7, 2011, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Does any body know the script to list all the tables. I would appreciate your help. Thank you

Migrating SQL server to a new Server

Thread by: Joben, Jan 7, 2011, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi Friends, What is the best way to move databases from one to another server? Thank you

SSRS

Thread by: Joben, Dec 26, 2010, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hi Friends, Is it possible to create a report on the secondary server configured for log shipping? Please let me know. Thank you, Joben

SQL 2008 Clustering Setup

Thread by: Joben, Dec 20, 2010, 4 replies, in forum: SQL Server 2008 Clustering

Hi Friends,Can somebody please let me know about Website that provides video tutorials on setting up a SQL Cluster. Also can somebody please let me...

SQL Logins

Thread by: Joben, Dec 11, 2010, 5 replies, in forum: SQL Server 2008 General DBA Questions

Hi, I have a question about SQL Logins. If we have to move the users from one server to another how can we do that? Also do we have to change...

Backup automation and archive old back up

Thread by: Joben, Dec 6, 2010, 2 replies, in forum: SQL Server 2008 General DBA Questions

Hi Friends, I need to set up a process which would take a full and transactional backup everyday and automatically overwrite the previous days...

TemPDB

Thread by: Joben, May 20, 2010, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I need to do the following in my Production Server. Can somebody please share their experience or please give me some tips on how to do it. 4....