• Best value for fillfactor in SQL?

    What is best value for fillfactor in SQL?

    mukeshkumar1210 pointsBadges:
  • How to find a word starting with (‘a’,’b’,’c’,’d’,’e’ or ‘f’) and end with ‘z’ from table.

    How to find a word starting with ('a','b','c','d','e' or 'f') and end with 'z' from table.

    mukeshkumar1210 pointsBadges:
  • What’s the best way to run SQL Server on Amazon EC2?

    We've been setting up a Windows based web application on Amazon's cloud service but we've run into several obstacles that we didn't see coming (especially when it came to the limitations surrounding the ephemeral local drives). So we're looking for any help / recommendations / insight from anyone...

    ITKE347,460 pointsBadges:
  • In a single CL Program, can we read a database file more than once?

    In a single CL Program, can we read a database file more than once

    Chraghuveer25 pointsBadges:
  • What’s the difference between SQL Azure Web Edition and Business Edition?

    Could someone tell me the difference between SQL Azure Web Edition and Business Edition (other than the database sizes)? I'm really looking for how their different when it comes to SLA, replication, scalability, cost, etc. Thanks for the input.

    ITKE347,460 pointsBadges:
  • How to open a RDL file in SQL Server 2012

    Hi I'm using SQL Server 2012, I'm download the RDL file in my location but the RDL file is not open. If open the RDL file, I have the error message. The error message is “unknown error”. Please help me open the RDL file.

    selvakumarrk5 pointsBadges:
  • MySQL Stored Procedures with Parameters in Crystal Reports 9?

    Hi, I'm using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way...

    Les za30 pointsBadges:
  • SQL Server multi-user programming with VB 6 and Access

    Hi! I am a new to SQL Server.  Since, I am a beginner, I want to test first before using 2 machines for 1 server and 1 client. Can we use SQL Server Express 2008 for client and server on a same machine where VB 6 is installed having Windows XP operating system (I know I am using old software, but...

    vikasjains20 pointsBadges:
  • How can I scale SQL Azure?

    I'm trying to host my WCF services in Azure for scalability reasons (There will be some read data action / be under High Load). Now, my service will be connected with SQL Azure but I need to know how many concurrent connections can Azure hold per instance? Can I scale it after it reaches its limit?...

    ITKE347,460 pointsBadges:
  • Best way to manage multiple connections in Azure

    My team and I have an application that we're currently migrating to SQL Azure. We've been using "web.config" transformation to manage the changing database connection string development/staging/production environments. What's the best way for us to manage multiple connections in Azure?

    ITKE347,460 pointsBadges:
  • Open IT Forum: What tech blogs and Twitter feeds do you follow?

    Each month, we cast the net asking what [Insert tech topic here] Twitter feeds and blogs you read, but this month is a free for all! We want to know any and all tech blogs or Twitter feeds you trust, admire, and follow religiously. We want links and we'd love to hear why you love them and how long...

    MelanieYarbrough6,345 pointsBadges:
  • Amazon EC2 and SQL Server licensing

    Now, I didn't want to make any assumptions but if I read it correctly, Amazon EC2's Windows with SQL option has the licensing costs bundled with their instance charges. Anyone know if that's actually true? Has anyone used a SQL instance to see if the charges are from Amazon (so you won't have to...

    ITKE347,460 pointsBadges:
  • Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

    I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as v_inputfile            ...

    jkeri360 pointsBadges:
  • Calling MS Server from iSeries Stored Procedure

    Hi, I have an ODBC linked server connecting MS SQL Server to my iSeries. What products (other than Java), if any, would I need to be able to call a MS SQL Server Stored Procedure from an iSeries Stored Procedure?

    JeffreyStark5 pointsBadges:
  • Would SQL Azure be PCI DSS compliant?

    I'm trying to figure out if I were to separate Windows Server (which was PCI DSS compliant), would it still be compliant if SQL Azure was hosting the back end? I'm only storing permitted values and I'm compliant at the application layer too.

    ITKE347,460 pointsBadges:
  • SOP for cleaning Server rooms

    Hi there, I have been tasked with organizing cleaning of comms, IDF, MDF rooms at our offices. This includes: removing dust from racks, actually all surfaces - cleaning floor , light fixtures etc. Does anyone have a SOP / Method statement of how this should be carried out? Does it require...

    Sinead5 pointsBadges:
  • Add’l CPU per index?

    I'd love to use the LASTUSED column on SYSIBM.SYSINDEXSTATS introduced in DB2 9 to eliminate indexes. I can show my client a number of indexes that have not been used since DB2 9 was installed in July 2009. But I know they will ask 'what is the ROI on deleting these indexes?'. Is there any 'general...

    kjolson5 pointsBadges:
  • Instance specific error when connecting to SQL Server

    What is instance specific error? It is occuring while connecting to SQL Server  ... how can i fix this error?

    FAIZAHAFEEZ5 pointsBadges:
  • How to open .db files with Excel

    Hi, how to config Excel to allow opening of .db files?

    cfs0105 pointsBadges:
  • What data should be stored in SQL Azure and Table Storage?

    My team and I are in the planning phase for the typical social networking type of a web application. It includes profiles, messages, chats, groups, albums, etc. But now we're trying to figure out the deciding factors on what data should be stored in SQL Azure and what should be stored in Table...

    ITKE347,460 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