SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Tricky Calculation, Multiple Query?!?!

  Guys, First off I just want to say that I am not looking for anyone to do this for me, just pointin…

  methexis

  6 replies

  13 years, 10 months ago

  By: methexis

• Help me solve my problem (getting idle time of my business process)

  I have this table: From | To 1 | 500 900 | 1020 5220 | 5340 6000 | 7000 9000 | 10000 I want to outp…

  rktn_odin

  6 replies

  13 years, 10 months ago

  By: rktn_odin

• Copy a view from one server to another by restricting the number of values?

  Hi , I am trying to copy a view from prod to test , but need to restrict the rows based on a c…

  SVR

  4 replies

  13 years, 10 months ago

  By: Steve Jones - SSC Editor

• Deploying Sql Server Database !!

  Hi, i am new in this field so i don't know where exactly my problem stands but i will try to explai…

  amet_1908

  1 replies

  13 years, 10 months ago

  By: Neal Sivley

• CLRs and minimum permission set

  I've been looking for some down to earth explanation of TRUSTWORTHY permissions concerning CLR asse…

  happiestgirl

  1 replies

  13 years, 10 months ago

  By: PaulB-TheOneAndOnly

• ODBC Data Source

  Hi All, I have MS SQL Server 2008R2 running on a remote server on my network, there are several dat…

  tomrc

  2 replies

  13 years, 10 months ago

  By: tomrc

• Query Optimization

  Hello everyone. Please critique the follow query and give me your suggestions on how to optimize it…

  troe_atl

  15 replies

  13 years, 10 months ago

  By: GSquared

• Updating a table based on another

  I have two tables A and B A has A.ID,A.Name, A.add, A.lastname B has B has B.ID,B.Name, B.add, B.la…

  SQLTestUser

  6 replies

  13 years, 10 months ago

  By: GSquared

• Remove SQL Server 2005 Manually

  I have tried everything to remove an instance of sql 2005 from a server, and still when I try to re…

  xxxxxxxxxxx

  2 replies

  13 years, 10 months ago

  By: xxxxxxxxxxx

• One database, copied to two identical servers. Performance bad on second server. Why?

  Hi All, I'm not a DBA and I'm confused at the cause of the behavior I'm seeing. I have two identic…

  Paul Koanui

  3 replies

  13 years, 10 months ago

  By: Jack Corbett

• How to get a user to run a SQL query themselves

  Hi guys I have a SQL query that the business users want to run themselves on an ad-hoc basis. How c…

  G_Dubyah

  5 replies

  13 years, 10 months ago

  By: G_Dubyah

• Combine 2 Queries to work out percentage

  Hi Guys, I know there is a way to do this, I have done similar things with nested queries but I jus…

  methexis

  9 replies

  13 years, 10 months ago

  By: methexis

• Concatenation insde Case Statement

  I'm having a problem with seeing the proper results from a concatenation using a case statement wit…

  cbrown 66440

  11 replies

  13 years, 10 months ago

  By: GSquared

• Views and Order By

  Why the order by clause cannot be used in the query which makes up the query in a view??

  mohnish_khiani

  5 replies

  13 years, 10 months ago

  By: ChrisM@Work

• Receiving "Error Renaming File or Folder" when attempting to rename .MDB and .LDB of a detached database

  We have 2 SQL2008 databases whose file names do not match the names of the database and we would li…

  CherylNH

  9 replies

  13 years, 10 months ago

  By: Ant-Green