• Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • DATETIME calculation

    Hi there, this is probably very simple but i just can't get it working. I want to subtract one month from a variable month. So if the datetime variable is equal to 10 Feb 2008 the result should be 10 Jan 2008. Please help. Thanks

    Barend IT15 pointsBadges:
  • list sales by year

    You are to generate a set of sales reports using the tables above. 1) Build a rpeort of sales by year (you can use order total colum) 2) Expand this to include the employee name of the sales rep so now you will show sales by rep by year 3) Also get the sale reps job descriptio and see what type of...

    Kkd7775 pointsBadges:
  • Converting from 2000 to 2005

    I was given an existing application/database with stored procedures to work on. The existing database is in 2000 however the manager would like it converted to 2005 (she thought it already was a 2005 database). My system is only configured for 2005 so my analysis tools are not working on the...

    GUI Girl5 pointsBadges:
  • Duplicate Spatial Data

    I"m looking for some help on how to find duplicate geometry for area, line and point features that are stored in an spatial SDO database. Any help would be greately appreciated. Regards, Sam

    SamAvella30 pointsBadges:
  • SAP HR

    Hi, what are the tables in SAP HR to select the name and salery with sql on oracle

    Wolloc5 pointsBadges:
  • Stored Procedure Problem

    Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select *...

    Anilak singh5 pointsBadges:
  • HOw to Find Duplicate Geometry in Oracle Spatial

    If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if she\he can share this with me. A million thanks in advance... Regards, Sam

    SamAvella30 pointsBadges:
  • SQL multiple files

    On our iSeries I need to find out if fld01 or fld02 or fld03 in file "C" contains a value that is obtained from file "B" using a value from file "A". How would I do this using SQL?

    Floyd02320 pointsBadges:
  • Using Case Statement Inside SQL Join

    Hi, I am trying to convert dynamic sql into static sql due to permission issue, I faced a challange when i am trying to convert this part of code given below -- join to ADDR_DETAIL SET @join_sql = 'inner join ADDR_DETAIL on ADDR_DETAIL.GRP_CONTACT_ID = pm.GRP_CONTACT_ID AND ' IF (@ChannelEntity =...

    Bmdayal5 pointsBadges:
  • maxdop hint

    I have encountered the bug with MS and the processor issue with Mutlitple processors, the solution is to put the MAXDOP hint. SInce I have never used this and all the MS KB say to use it but not where and how, what is the proper syntax. ( I have a dual processor quad-core new dell)

    tcstl95 pointsBadges:
  • Tagged text in Windows to be inserted into Db2 Clob column on Mainframe

    I have a string-combinatino of rich text and tagged test: ex: "test msg <p><STRONG></P>" on Windows machine. How i can insert data 'AS IS' without any data loss into a Db2 clob column. Db2 is residing on mainframe and we are using Db2 version 8.

    Narayananv5 pointsBadges:
  • Daily trigger in SQL

    I'm trying to create a trigger to execute daily and calculate a few averages for me. Please help!

    Barend IT15 pointsBadges:
  • SQL (Oracle) Date Constraints

    Can someone tell me how to create a constraint to prevent entering a date prior to 1 Jan 2007? I am tryin g to do it in a create script. Thanks Lock

    Lock10 pointsBadges:
  • C#.Net

    Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

    Cmcwag0 pointsBadges:
  • ms sql case statement

    I have written a case statement in MS SQL that is returning a single phone number for a single id. This is valid as the database contains multiple phone numbers attached to the same id number, with differentiation based on phone type. Once I have found the prefered phone number, I do not want to...

    Espqueen5 pointsBadges:
  • SQL Right Trim Nulls

    How can I trim any trailng nulls from a selected record set. I have a table with up to 17 cols that I need to extract data from which included all embedded nulls but no trailing nulls

    Tim442025 pointsBadges:
  • Using SQL and given a table X with columns labeled A, B, C, and D -how do you get the count where column A = ‘TREK’

    Using SQL and given a table X with columns labeled A, B, C, and D - how do you get the count where column A = 'TREK'?

    Shellken6940 pointsBadges:
  • Using SysObjects Table

    I have a database that I need to know what tables are in it and also what views. I also need to know what tables are used in the views. Is this possible with the Sysobjects table? Any help would be greatly appreciated. TIA SQL Newby

    Gdckboyer20 pointsBadges:
  • Why is the query using the index even though the perecentage of unique values is 52%?

    I have a table with no primary key and a non-clustered composite index of two columns. When I look at the number of distinct values (selectivity ratio), the table has a ratio of 52% unique values. I thought an index should be at least 90% unique in order for it to be used. Yet when I run the query...

    Abbi20 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