• What are the query optimization techniques used in SQL 2000?

    What are the query optimization techniques used in SQL?

    Gomsbk35 pointsBadges:
  • What is a linear recursive query in SQL?

    What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??

    Gomsbk35 pointsBadges:
  • Joining 3 tables in SQL Server 2005

    Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.

    Macha19735 pointsBadges:
  • Does SQL support nonlinear recursive queries?

    does sql supports nonlinear recursive queries

    Gomsbk35 pointsBadges:
  • SQL Server 2008 Management Studio evaluation edition a time bomb?

    Hi, I was just wondering if the Management Studio for SQL Server 2008 evaluation edition is also a time bomb? One of our client wants to just install the 2008 Management Studio and I was just wondering if we could use the Evaluation edition or do we have to purchase a license just to get the Client...

    Db23290 pointsBadges:
  • SQL server query to search for table and column data in database

    I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

    Linu438910 pointsBadges:
  • Spatial query optimizing

    I have a development machine and a production machine with identical databases, but I'm getting huge differences in execution plans when running a spatial query. First, my development machine: It's SQL Server Express x64 with Reporting Services running on Win7 with 8Gb RAM. Then my production...

    Overtech65 pointsBadges:
  • Subquery only returns column names

    I have the query below, but when I run it, I can only get column names to return. Can someone please help me??? For each subject there are multiple values at each marker. I want an average, by date, for each subject at each marker. I have spent literally hours on this... Thanks in advance for any...

    Docmom12315 pointsBadges:
  • Substring Query SQL

    Hi All, I'm trying to build a query to join names in one table to abbreviated names in another table. So for example I have - Harry Harold Harrison on one table, but in the other table I have just Har, this can vary in length so does anyone know how I can sum the amount of Har names with the total...

    Smillsie20 pointsBadges:
  • SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • SQL Server 2005 question self join query

    I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ------------ ----------- Book Commerce Commerce Accounting Science Math Commerce B.O. Material Pen Pen Link Pen Renolods I want ouput...

    Kotnimahesh5 pointsBadges:
  • How do I get the value of a lookup field stored in nvarchar field

    I have a list with a lookup field which is being stored in an nvarchar column. I'm trying to access the value in a Sql Server query, but what comes back is this: ↓ ъ䅃㒳ꅉ I've tried converting this column to every data type there is, and no success. Please help!! Thanks...

    3300Metairie35 pointsBadges:
  • query for join

    i have 2 tables unittypes,rules unittypes has unitid and description unitid description A1 description1 A2 description2 A3 description3 rules has id unitid 1 A1,A2 2 A1,A3 i am trying to get it to get a resultset like 1 description1,description2 2 description1,description3 the sql i wrote was...

    Rampradeep5 pointsBadges:
  • Optimize the query in sql server

    CREATE VIEW [dbo].[vwResults] AS SELECT r.ResultsPK, b.PersonID, dbo.ltcPerson.FirstName, dbo.ltcPerson.LastName, dbo.ltcPerson.PersonFriendlyID, b.DateCreated, b.FormName, r.FieldName, r.ValueString, r.ValueNumber, r.ValueDate, r.ValueTextInt, r.ValueBit, b.UserID, b.BatchID, b.ParentID, r.Active,...

    Rajupatil5 pointsBadges:
  • Querying database tables with their descriptions

    I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?

    Sheni5 pointsBadges:
  • Substract two fields SmallDateTime at SQL Server

    Hii.. IT Professional Helper, may i asked 1 question and hope IT Professional Helper can help me to answer my question? The Question is : Cm.CommandText = "Update Reminder Set IsDatang = 0, IsValid = 1 Where TglReminder - TglDatangKembali > 7" Cm.Execute If i get the error : Arithmetic overflow...

    Suryanto5 pointsBadges:
  • Link microsoft SQL server to Active Directory

    I am getting an error while running a qurey for excuting against OLE DB provide'ADSDSOobject' Please advice Thanks Rajaa

    IT45 pointsBadges:
  • Viewing distinct records in a SQL query result

    I have a set of records in a SQL query result. I only want to see one record, per the data field "ID". I am getting 2 records for some ID's, as there is one field that is different in the 2 records. This happens even if I start the query out with SELECT, DISTINCT, and then all of the fields I need....

    SQL Server Ask the Experts2,585 pointsBadges:
  • Searching for a T-SQL query to find data from multiple SQL 2005 servers

    I need a T-SQL query to find a list of all database names and sizes from multiple SQL 2005 servers that are connected in a local network. Does one exist?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server security bulletin MS09-004

    Has anyone dealt with issues related to this security bulletin ?

    Rik5 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.

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