SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• US Date Format in SQL Server

  How to store date in the USA format (05-09-2012 19:28:35) in SQL Server Table? I already have date …

  park1432

  7 replies

  14 years ago

  By: park1432

• How to manage common tasks

  We have multiple databases installed at mutilple customer sites. But we do not have all databases a…

  Joe-420121

  3 replies

  14 years ago

  By: Jeff Moden

• drive space issues trying to index 2.4TB table

  OK, this landed on my desk this morning: user created a 2.4TB table without a Clustered Key. He now…

  RP_DBA

  5 replies

  14 years ago

  By: Jeff Moden

• SSRS Reports RUnnine very slow

  Hey guys any idea or what steps to take if Reports suddenly starts running slow... Before it was …

  SQlLogic

  2 replies

  14 years ago

  By: Jeff Moden

• Where clause with view returns super slow!!!

  Hi All, I have a query running very wired: Query:" Select * from view1 where score1 > 3.5 and sc…

  princa

  12 replies

  14 years ago

  By: Jeff Moden

• Is the following possible

  I'm pretty new to this, so sorry if this is a silly question. I'm querying 2 tables and have joined…

  kirkm 55368

  25 replies

  14 years ago

  By: kirkm 55368

• Run Procedure with breaks in between

  Hi, This is a strange requirement that the .Net people working in my team came up to me with. Is t…

  vinu512

  27 replies

  14 years ago

  By: Devendrakumar

• caching a view

  Hi I have a view that is used very regularly and joins several tables. Is there a way of caching th…

  erics44

  3 replies

  14 years ago

  By: Matthew Darwin

• foreign keys across databases

  Hi I have a database and the is an area of that database that is concerned with housing. Now this a…

  erics44

  2 replies

  14 years ago

  By: Matthew Darwin

• I NEED MS SQL SERVER 2008 LICENSE URGENTLY

  Please, I need a valid Processor License for MS SQL Server 2008 ASAP. Please if you have contact me…

  sodams007

  1 replies

  14 years ago

  By: Gail Shaw

• need help with duplicate records in a table

  Hello, Hope someone can help me out here... I have a calling application that needs to query a tabl…

  Labneh

  12 replies

  14 years ago

  By: vinu512

• Performance in joining annual totals to a monthy subset for a report

  Hi all! For performance purposes I'm trying to improve a view used to attach to a resultset of dail…

  Oscar Janson

  10 replies

  14 years ago

  By: Evil Kraig F

• record last rundate

  i need to record the last successful job run date in a table. As soon as the job is completed I wan…

  peacesells

  4 replies

  14 years ago

  By: ScottPletcher

• need help with query speed.

  does anyone have any suggestions to improve the query below? SELECT dh.deviceid, dh.archived, lastp…

  diat150

  32 replies

  14 years ago

  By: ScottPletcher

• avg max salary

  hi everyone select * from personnel where salary > ALL (SELECT AVG (salary) from personnel group…

  johnny1walker

  11 replies

  14 years ago

  By: johnny1walker