Search Results | SQL Server Performance Forums

Can network problem corrupt a database?

Thread by: NewDBA, Apr 7, 2010, 8 replies, in forum: SQL Server 2005 General DBA Questions

I am wondering if network connectivity issues can cause corruption of the database.

Summary page is missing

Thread by: NewDBA, May 8, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi I don't have summary page in SQL Management studio . How do i find it? I need to see taskpad info

How to retrieve file from image data type?

Post by: NewDBA, Mar 27, 2008 in forum: SQL Server 2005 General Developer Questions

Hi I thought I add to my question. It seem that my image field keeps actual text pointer to the text, in other words my field contains what normaly...

How to retrieve file from image data type?

Thread by: NewDBA, Mar 26, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi I have an image data type column where a pointer to the file being stored. When using textptr with readtext functions the result which I am...

Snapshots on transaction log shipped database not a good idea/

Thread by: NewDBA, Mar 3, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Looks like there is no benefit of creating snapshots on tranaction log shipped database? I applied snapshot to my db and since then new tranasaction...

Create endpoint - cannot see output of stored procedure

Post by: NewDBA, Feb 27, 2008 in forum: SQL Server 2005 General Developer Questions

sorry for duplication - save operation look like stuck so I tryed to post smaller message. Anyway - I don 't see result of my stored procedure - and...

Create endpoint - cannot see output of stored procedure

Thread by: NewDBA, Feb 26, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

HI I created endpoint successfully but when I hit the website only see xml and no output of my stored procedure Maybe I don't understand how it is...

Create endpoint - cannot see output of stored procedure

Thread by: NewDBA, Feb 26, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

HI I created endpoint successfully but when I hit the website only see xml and no output of my stored procedure Maybe I don't understand how it is...

sql job runs forever - no blocking

Post by: NewDBA, Jan 17, 2008 in forum: Performance Tuning for DBAs

I seem to be 100 % sure that index added to the table which I query degrade performance. I copied db to other server, run my query : it took 5 hours...

sql job runs forever - no blocking

Post by: NewDBA, Jan 17, 2008 in forum: Performance Tuning for DBAs

Hi I tested couple of scenario: it is not insert that causing the issue - the select statement is the issue. Select statement is selecting records...

sql job runs forever - no blocking

Post by: NewDBA, Jan 16, 2008 in forum: Performance Tuning for DBAs

thanks for those questions - I will investigate them now. but looks like I found some changes done to the table being queried. We had vendor of this...

sql job runs forever - no blocking

Thread by: NewDBA, Jan 16, 2008, 7 replies, in forum: Performance Tuning for DBAs

Hi My stored procedure that takes to execute usually for 4-5 hours suddenly runs for 3 days. It happened 2 weeks ago , at first I killed that sp 2...

how to run sql 2000 dts package in sql 2005

Thread by: NewDBA, Dec 11, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi While I will expore SSIS in future , I need quickly put back all my DTS packages (sql 2000) rutine back to sql 2005. I saved my packages as...

Is there any benefits for using stored procedure over views? performance wise?

Thread by: NewDBA, Nov 26, 2007, 2 replies, in forum: General DBA Questions

Hi I always thought that stored procedure are better then views or regular TSQL statement because they have ther execution plan saved in system...

check integrity of database on other server

Post by: NewDBA, Oct 4, 2007 in forum: SQL Server 2005 General DBA Questions

O, I am checking integrity only once a day on that standby server - what I ment by 1 hour - I am shipping log every 1 hour.thanks for your answer So...

check integrity of database on other server

Thread by: NewDBA, Oct 2, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hello , I am checking integrity of the database on other server. I log ship my production database every 1 hour and then check integrity . Is that...

Cannot see migrated package ?

Post by: NewDBA, Oct 1, 2007 in forum: SQL Server 2005 Integration Services

Can someone please help me - I am half dead with trying to find my package that sits nicely in msdb database ( when I query it ) and I cannot find...

Cannot see migrated package ?

Post by: NewDBA, Sep 28, 2007 in forum: SQL Server 2005 Integration Services

I need step by step how to get to the point where I can see my package. I know it sounds wierd but the article mentioned above - doesn't help me - so...

Cannot see migrated package ?

Post by: NewDBA, Sep 28, 2007 in forum: SQL Server 2005 Integration Services

Yes that is exactly where i stuck . And I do open Object browser but see all those classess in it like for example: Microrsoft.CSharp...

Cannot see migrated package ?

Thread by: NewDBA, Sep 27, 2007, 5 replies, in forum: SQL Server 2005 Integration Services

Hello I just migrated DTS package from 2000 to 2005 and cannot see it. I opened Integration services on server . Book on line says I should open it...