• T-SQL Programming Tutorials

    I am looking for a website that is free and where I can learn to write better T-SQL views and stored procedures.  Also, would like to find some good books to learn more about managing a SQL 2005 database.

    Luby10 pointsBadges:
  • SQL Server 2005 query

    Hello sir I am new to sqlserver when retriving data like name gender sal deptno df F 100.00 10 mf M 1100.00 10 if M 1010.00 10 uf M 1000.00 20 yf F 1200.00 20 gf F 1030.00 20 hf M 1005.00 30 ff F 1040.00 30 from this i want retrive deptno maletotal sal female total sa 10 2110 100 20 1000 2230 30...

    Udaya5 pointsBadges:
  • SQL Server 2005 with SAN storage problem

    i have a very strange problem: - i have an  windows 2003 server - a SAN storage attached to that server - i installed SQL server 2005 proffesional into the server - database files in the san storage - when i attach the database into the san storage it gives an error that it cann't see the drive E...

    Masterofpcs5 pointsBadges:
  • SQL I/O Best Practice

    I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?

    Rick Martinez585 pointsBadges:
  • Value of() in SQL Server?

    what is the equivalent statement of valueof() of oracle in sql server?

    Prcvjr220 pointsBadges:
  • How to create data security in SQL server 2005 so that the code will not be opened

    how to create data security in sql server 2005 so that the code will not be opened

    Gkhlhlhjhhghgg15 pointsBadges:
  • Question on SQL 2005 table

    tablename:-software pname             packagename                    cost MARY               README                             1200 ANAND             PARACHUTES                     6000...

    Vijaykumar45625 pointsBadges:
  • SQL Server 2005 procedure to Create stored procedure

    sir,plz tell me the procedure from strating that how to create stored procedure

    Gkhlhlhjhhghgg15 pointsBadges:
  • Crystal Reports 8.5 compatibility with SQL 2005

    Is crystal 8.5 compatible with SQL Server 2005?

    CrystalPrincess5 pointsBadges:
  • Add an Active node to SQL Server Active Passive Cluster

    how will i add an active node to an existing Active/passive SQL Server 2005 Cluster. so that when any active node fails the passive will be used.will there be a down time for the current cluster Jasina

    Jasina30 pointsBadges:
  • Can’t bring master database back online

    hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did't get that one into online(production side)wht is root cause for that?

    241219840 pointsBadges:
  • How to transfer database from SQL Server 2008 to SQL Server 2005

    how to attach database of  sql 2008 into sql 2005

    Itready5 pointsBadges:
  • How to convert XML data into tabular form in SQL Server 2005

    Hi, I have a concatenated string of XML data. I need to convert the string into tabular form. Please suggest how it can be done. Thanks in advance!

    Shama5 pointsBadges:
  • Microsoft SQL Server BCP Utility password

    I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the 'in' argument, a format file and an error file.  I have 'hard coded' the user name and password in the command line using the 'U' and 'P' arguments. I am looking for a method...

    Redwine20 pointsBadges:
  • Is it safe to delete SQL Server Transaction Log?

    In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but I want to make sure that...

    Vahemelikian10 pointsBadges:
  • How to add an article in transactional replication in sql server 2005?

    How to add an article in transactional replication in sql server 2005? and what are the prerequisites for trnsactional replication?

    Suneelsqldba5 pointsBadges:
  • SQL SERVER SAN Setup

    I do not know much about SAN's, I want to setup a SQL Server to use a SAN. 1. Should I use a SAN drive to install the OS or is it best practice to install the OS on a local drive on the server? 2. Should I install SQL SERVER on the SAN or on a local drive on the server?

    Rick Martinez585 pointsBadges:
  • Filename from SQL 2005 Query

    I have a batch file that runs a SQL query command overnight once a week and outputs the results of that query to a file as a .csv file. The query produces, amongst other things, a week ending date. Is it possible to to name the output file with result of the week ending column in the query. All...

    Apbarker5 pointsBadges:
  • Linking Access to SQL Server

    Hi ive got alot of linking tables in Ms Access and I want to link in onto Sql Server 2005.how to i do the liking part

    Ilse5 pointsBadges:
  • How do I INSERT records into AS400 DB2 file from SQL server?

    I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back.  This is a very small process, I only need an item number and date. Also, the date on the SQL db is "datetime".  I'll need to convert that to a more recognizable date field to put in the AS400...

    Normap2275 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