Search Results

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

Hi, I have to create a new database . I need around 15 Tables to be created . 2 of the Tables have around 80 columns . Rest of them have 5-10...

Thread by: kasaranenikiran, Jan 28, 2011, 9 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I have an excel sheet with the Specific Backup Details. 1.Server Name (Eg: Prod) 2.Database name ( Eg:ABC) 3.Backup Job (Eg: Prod...

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

Hi, I queried select * from sysdatabases and got list of 30 databases. But I have 29 databases in the instance (GUI) . Why doesn't the DB...

Thread by: kasaranenikiran, Jan 4, 2011, 11 replies, in forum: SQL Server 2008 General DBA Questions

Hi , WE have a PROD environment with around 200 DB's. We used native SQL backups for DB backups. Recently, one of the DBA installed Quest...

Thread by: kasaranenikiran, Aug 13, 2010, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi All, Its not a real time question,,, But a question I faced in interview. Just wanted to if some one could answer it . We have a database...

Thread by: kasaranenikiran, Jan 12, 2010, 3 replies, in forum: SQL Server 2005 Integration Services

In our existing environment, We have SQL 2005 and Varicent Tool on same box. We have specific SSIS Packages which were put in a batch files and...