• SQL MERGE

    I have a view like below generated from my time and attendance software. staffNo EmployeeName title TransactionType Cdate time 556 JOHN WEB DEVELOPER IN ENTRY 24/01/2008 13:47:30 556 JOHN WEB DEVELOPER OUT ENTRY 24/01/2008 16:38:33 556 JOHN WEB DEVELOPER OUT ENTRY 24/01/2008 16:40:03 556 JOHN WEB...

    Binu.emiliya10 pointsBadges:
  • Settng Memory Sql Server 2005 SP2 64Bit

    Hi I've a SQL Server 2005 sp2 64bit , i have to set memory and my server has 12gb fisical memory and 20gb paging file, what is the best pratices to set sql server memory for best performance? Thank You Best Regards Vincenzo

    Nuanda777720 pointsBadges:
  • Securing dynamic file uploads to a SQL 2005 Server database

    I need to determine what is the best (practices) method for scanning of files/documents (.DOC, .XLS, .JPG, .TIF, .PDF) before they are dynamically uploaded into an SQL 2005 db as BLOBs..Thanks

    RJpoorvin0 pointsBadges:
  • 29 Feb incorrect in DateAdd and GetDate command

    Hi, Does anyone know Why the day of date different ? when i used : select GetDate() --> It's Return 2008-02-29 11:01:45.310 and then when used : select DateAdd(yyyy,543,GetDate() ) ---> It's return 2551-02-28 11:01:45.310 My SQL Server is MS SQL Standard Edittion VERSION 6.5 Anyone have any...

    283036050 pointsBadges:
  • Using SELECT statements

    Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?

    OracleATE190 pointsBadges:
  • Performance Tracking of Stored Procedures

    we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each...

    Pcrum735 pointsBadges:
  • Fixing a corrupted file

    I have a 2801 router, but the Nvram file is corrupted. When we try to copy the Running config is not working. The command I use is the following: copy running-config startup-config The error says it cannot save it. I don't know what's wrong. What should I do? Do I need to download the new IOS in...

    NetworkingATE1,545 pointsBadges:
  • RPG with Dynamic SQL Problem – SQLCOD 501/312

    I'm trying to do simple dynamic SQL in a program to select records for a subfile but it doesn't seem to be working. sSql = 'SELECT orderno FROM ordhdr ' 'WHERE custno = :scSrchCust '; following this I have: exec SQL CLOSE @Orders; exec SQL Prepare Stmt from :sSQL; exec SQL Declare @Orders SCROLL...

    MMAGuy85 pointsBadges:
  • Replication in SQL Server 2005 deleting records

    We just converted from SqL 2000 to 2005. We were replicating from 2 instances on the same server every 30 minutes. A record from Intsnace A was copied to Instance B, then the record in A was deleted. Worked great for years. Now with 2005 it is deleting the records on B on the second pass. We think...

    Getmygto5 pointsBadges:
  • rows to columns

    I have a table containing answers from different forms. the forms are created dynamically so some forms will have 3 answer fields, some will have as much as 20 answerfields. ex : form_id field_id unique_id field_value 1000 631 1 john doe 1000 632 2 washington 1000 633 3 john@ws.com 1000 631 4 anny...

    Aabbccddee25 pointsBadges:
  • How to control SQL Server transaction log growing to a maximum size

    Transaction log in SQL Server getting completely growed to maximum size frequently even when it is being backed-up and shrinked.. Please provide early and feasible solution.. What is the possible cause for the growth of transaction log to that extent.. and how to avoid it...

    1909198110 pointsBadges:
  • Problems with sp_send_dbmail in SQL Server 2005

    I am trying to convert my stored procedures in SQL 2005 from using xp_smtp_sendmail to using sp_send_dbmail. When I use the "Send Test Email" option in the management studio, I am getting the following error message from the sp_send_dbmail: The mail could not be sent to the recipients because of...

    Randym1,740 pointsBadges:
  • Upgrading two instances of SQL 2000 running on the same SVR to SP4

    I currently have two instances of SQL 2000 running on the same SVR. recently I commissioned a new CRM SVR and as I'm sure your all aware that the minimum requirement for the CRM to work correctly is SQL 2000 SP4. I downloaded and installed SP4 on the SVR running SQL 2000, however, my problem is...

    Cridgy35 pointsBadges:
  • SQL Server transaction log problem

    An error like" Transaction log full.. backup thelog and shrink the database .. " occured.. Many times the transaction log was backed up and shrinked.. Niow a stage has come where even doing the phenominal process.. the error still re occuring.. Afetr going thru a website transaction log was...

    1909198110 pointsBadges:
  • documents on sql server upgrade from 2000 to 2005

    Hello, If anyone has following documentation on SQL SERVER UPGRADE FROM 2000 TO SQL SERVER 2005, I will appreciate. 1) Pre-Checklist for the Upgrade 2) Process for the Upgrade 3) Post Check list for the Upgrade Thank you so much. If you kindly email me at cqldba@gmail.com, will appreciate thanks Sam

    Pslsql10 pointsBadges:
  • ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:
  • Need to create SQL DTS Package

    We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also i want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script??

    JimmyIT1,725 pointsBadges:
  • view and temp. table which one works better in T-SQL?

    please tell me which one performs better view or temp table ?

    HL5 pointsBadges:
  • SQL Server Command String

    What is the max length of the Command String that can be submitted to SQL Server?

    Hank103925 pointsBadges:
  • Problem with MSSQL? .NET application? or Win Server?

    Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application that fetches data from...

    georgesmith55 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following