Search Results | SQL Server Performance Forums

Jobs Fail with non-sa user as owner: After applying a Patch

Thread by: arunyadav, Jan 20, 2010, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All,I have seen in our environment, that whenever a patch is applied to SQL Server, the jobs having non-sa user (domain account) as owner fails....

Key Lookup when reteriving one column twice

Thread by: arunyadav, Nov 2, 2009, 10 replies, in forum: SQL Server 2005 General DBA Questions

Hello Friends, In the below query I am reteriving a column (C_type) twice. While doing so, I am getting a key lookup. The column is included in one...

Knowledge Sharing: Maximum Length of UserName and password in SQL Server 2005

Thread by: arunyadav, Aug 4, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hello Experts, Greeting of the day! Today one of my collegues asked about the maximum length of a SQL Server USerName and Password. I checked into...

Cannot perform SET operation on a TABLE SYNONYM

Thread by: arunyadav, Jun 23, 2009, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hello All, I have 02 DBs on different servers. I am facing some problems in writing after insert triggers (when ever a record is inserted in...

Binding Variables

Thread by: arunyadav, Jun 15, 2009, 4 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello All, To increase performance of dynamic queries, variable binding is used. Can you please tell me the syntax/ example of doing it??

MSSQL 2005/2008 32-bit on 64-bit machine?

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

Hello Guys, Please advice if a 32-bit SQL Server 2005/ 2008 can be installed on 64-bit machine. If yes, are there any special steps/ considerations...

Need Select query to return a part of the result/row content

Thread by: arunyadav, Apr 16, 2009, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hello All, I have the below query: select top 5 TRANSACTION_CONTENT from EVALUATION_TRANSACTION_CONTENT order by...

Cannot Connect to Instance after changing Default Port

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

Hello All, I have a database running on default instance of SQl Server 2005 SP3. I tried to change the TCP port through SQL Server Configuration...