• Query Optimizer not Selecting Index on a Computed Column – Performs Table Scan

    Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by.  The computed column is not persisted and there is a non-cluster index on it (the only index on the...

    Steve005 pointsBadges:
  • SQL Server Management Studio Express 2005

    I have installed Studio Express on my system but I am not able to start with it. I am not able to connect to the server. Error-40 and Error-26 is coming.What is the procedure to connect?

    Sweetu20 pointsBadges:
  • VS 2005 SQL Reports – Need to convert 5 character string to datatime

    Hey there. I am relatively new to SQL and have a problem. I am building a report that gets a summation of a column called 'Duration'. The datatype is char(5) e.g. "00:30" to represent a half hour. I suppose I need to change the datatype to sum it but can't figure out how to. What would my query...

    Haxatron15 pointsBadges:
  • Free IT Book: Development with the Force.com Platform

    These days enterprise applications are all the rage, with the ultimate question being: Who's going to build it? You know the saying, If you build it, they will come, and while I'm not quite sure how the second part of that saying fits, we have the resource to help you build it. Development with the...

    MelanieYarbrough6,345 pointsBadges:
  • How to search more than a word in a column SQL database?

    i have an array of words to be search in my sql database like: searchword = array(['Arrays','Logistics']) for word in searchword:     conn.BeginTrans()     cursor = conn.Execute("SELECT idf FROM instance WHERE instance='"+ word +"'")     conn.CommitTrans() but some of the searchword cannot be...

    Semantic855 pointsBadges:
  • Free Centralize backup solution

    Hi, anyone has idea of any freeware centralize backup solution or low cost best centralize backup solution. i have 12 lcoations with File and print servers. SQl server Database server 2 web serevrs 1 Domain controller i want to backup the files at my central IDC. locations backup has only Excel,...

    Thmohan50 pointsBadges:
  • Stored Procedure and crystal reports resources

    Can anyone please tell me where to buy store procedure and crystal reports book in one.  Thanks.

    Khanhhoa5 pointsBadges:
  • ASP.net SQL Server Need Experienced Webdeveloper

    I have a website I need an experienced webdeveloper to help me get my website running again. Fired my Webmaster. Does anyone have this experience to help me? Pat

    CharlestonRealtor5 pointsBadges:
  • SQL database design

    i have slary system using vb.net  and sql server there is  27 user the compute up to  700 employ salary every monthe i collecte (700 *27) number of row and adding them programaticaly to a table called salary the table salary have 40 column with one primery key  is there any proplem with this...

    msmj8675 pointsBadges:
  • Run time error 3265 VB6.0/SQL2005

    I am making a report inwhich i want to insert some values from a diffrent Table ( By making a module) Coding of Module is:- Public Function Deposit(ByVal M) Set conn14 = New Connection Set rs14 = New Recordset With conn14 .ConnectionString = Connection = "provider=SQLOLEDB.1;Integrated...

    DEEPSOFT40 pointsBadges:
  • Name Pipe work arounds in SQL 2005 database

    I am working on a SQL 2005 data base, the supplirer is telling me that the reason I am unable to find the SQL Data Base when i run there Client install software through a VPN connection is that the Name Pipes are keeping the Data base from being accessed.   Can anyone herlp me with this issue I...

    greatjubee165 pointsBadges:
  • Windows Server 2003 cluster resources

    what are the services will involve while moving resources from one node to another. If fails in moving resorces how we can trouble shoot it. Any links can help for this. exampmle - If any sql resources fails while moving. Please help me.   Thanks. Aravind.  

    UK75 pointsBadges:
  • Free IT Book: The Official Ubuntu Book

    Take full advantage of Ubuntu - the complete, free operating system "that emphasizes community, support, and ease of use without compromising speed, power, or flexibility" - by winning this week's free IT book: The Official Ubuntu Book, 6th Ed. Answer one of five questions and post the link to your...

    MelanieYarbrough6,345 pointsBadges:
  • Open IT Forum: What to consider when building a data center?

    What are some of the key factors the enterprise should consider when building a data center that can last? We'd love to hear stories from your own experience, or see lists of your own must-haves when it comes to a new data center. Share your thoughts and we'll share 100 Knowledge Points!

    MelanieYarbrough6,345 pointsBadges:
  • SQL Server profiler duration empty

    Hi I choosed all events with starting and completed but still duration is empty, tried also by swithching to microseconds from tools/options, but still empty. any reasons for this? thanks Elod

    Zsoelod15 pointsBadges:
  • Open IT Forum: What data center fads should be avoided?

    There's always something new and improved, especially in something as complex as a data center. What are some recent technologies you've seen that strike you more as fads rather than essential additions to the data center? Share your opinion, and we'll share 75 Knowledge Points!

    MelanieYarbrough6,345 pointsBadges:
  • MSSQL 2008 sudden and drastical slow down – IT telephony

    Hi, I'm a newbie, greeting everybody from Hungary, and thanks for your time :) Generally the SQL system runs smoothly. There is a SP which runs two times daily, and it logs the begin/end times. It takes about 20 minutes each time, normally. Suddenly I see that it takes 3-4 hours. Each time the same...

    Sandy6015 pointsBadges:
  • Connecting to SQL Database

    We are no longer able to connect to our SQL database or open the DB manager on Windows Server 2008. This is SQL 2005 how can we troubleshoot this issue? We have a 2.9gb database and backups from each night.

    NewnanIT1,110 pointsBadges:
  • How do I create jobs using steps in SQL Server 2008 R2 Management Studio

    How do I create jobs using steps in SQL2008 r2 Management Studio? I am really having a problem with the syntax when using operating-system commands and transact-SQL commands. Examples would be great.

    Stingeree5 pointsBadges:
  • Update SQL Server 2005 Scripts

    I don't right code & don't have the confidence to try on my own so, I'm asking for help. I need to run an update script to clear out the data from iweb_conf_demo.Attendee_ribbons.Then I’ll need to run multiple scripts to update multiple records on the same field iweb_conf_demo.Attendee_ribbons...

    DJandLO130 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