• Resources for learning about SQL Servers

    Can someone point me in the right direction on learning about SQL Server?

    Mulky5 pointsBadges:
  • Slowdown of the SAN due to overusage of temporary tables

    We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. Should we...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • What is SQL ingestion?

    Please explain SQL Ingestion with a example?

    Mayurkhe295 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to SQL table and vice versa through Windows service. So, please help me.

    VBNET5 pointsBadges:
  • Visa and SQL compatibility issues

    Do you have any solutions for the compatibility issues I am having with Microsoft Vista and SQL server Data Engine?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Oracle DECODE and SSMA

    Does the SSMA or SQL Server Migration Assistant actually have a custom DECODE function that can be used in SQL Server? I've installed SSMA and can't find that function in the sysdb database. I assumed there was such a function based on a blog posting made by Kevin Kline.  If there is a function...

    Dirk5 pointsBadges:
  • Moving SQL 2005 databases with no downtime between servers

    We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a...

    Theitman25 pointsBadges:
  • Linking to a table in SQL with Visual Basic

    How could I link to a table in SQL using Visual Basic?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieve images from SQL database using VB.NET

    How do I store and retrieve images in SQL Server using VB.NET?

    AnandKanade5 pointsBadges:
  • Sponsor Post: VMware Expert Live Chat – Tuesday 10/26 at 11am EDT

    Join us on October 26 from 11am-2pm EDT for Virtualizing Business-Critical Applications. In this LIVE chat with VMware experts, you’ll learn about application performance considerations, best practices and use cases for deploying Tier 1 applications on VMware. Click here for reminder email to...

    EmNichs3,250 pointsBadges:
  • Parameter in select statement

    Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND...

    Plugsharma40 pointsBadges:
  • I am unable to find “Create Partition wizard” in SQL Server 2014

    I want create Partition on one table, I have SQL Server 2014. Where can I find "Create Partition wizard". I have done same in 2012, under table option "Storage->Create Partition"

    VikramD5 pointsBadges:
  • Search Data in SQL Server database

    What can I do to prevent from the data that doesn't have in database in SQL Server alert message? Don't I have to use connection a VB.NET to SQL Server from use textbox to search?

    dara925 pointsBadges:
  • Converting an Excel 2013 file to a flat file in notepad for SQL Server 2008 R2 export/Import Wizard

    I am a student. I have to convert an Excel 2013 spreadsheet with 7 tabs of different table information. I have to then import it from my host computer into SQL Server 2008 R2 which is located on my virtual machine. Please help me and if you need more information, then let me know. Thanks in advance!

    Ronnibelle5 pointsBadges:
  • I want to create backup of SQL database and set a password.

    HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password .... is this Possible....? if Yes please tell me How...? Thanking You Raviraj

    Raviraj1235 pointsBadges:
  • SQLRPGLE – How to override data set data structure at run time

    I currently have an SQLRPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • How can I make backup 4 file only and restore in SQL Server 2000

    How can I make backup 4 file only and restore in SQL Server 2000?

    01058478505 pointsBadges:
  • SQL – Pass the result of the first query as the second query select column name

    I want to pass the result of a SQL query as the column name in another query eg. (note there will be a single result for the first query): SELECT CASE WHEN fld_type1 = 'A' THEN 'VAL_ALPHA1' WHEN fld_type1 = 'D' THEN 'VAL_DATE1' ELSE 'VAL_NUM1' END AS FIELDNAME FROM TABLE1 I want the result of the...

    Chris12325 pointsBadges:
  • Website and SQL database connection

    Can anybody tell me how to connect the MS SQL database with the JSP pages. I got the IP address and username with the password. I know how to connect it in a local system but I don't know how to connect it with the database in the web server. Please help me to solve this matter.

    Advancedjava25 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