SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Creating indexes on all field of a table

  What are the drawback of creating indexes on all Columns of a table ?

  kamaleshray

  2 replies

  14 years, 9 months ago

  By: Gail Shaw

• data type for decimal

  In a sql 2005 ssis package, I want to pass a sum of a column (PaidAmt), which is a decimal (8,2) to…

  QQ-485619

  1 replies

  14 years, 9 months ago

  By: Orlando Colamatteo

• Left outer join and subquery.

  I have a question on left outer join and subquery as follows: Below is the code that gave me what I…

  todinhkhoi

  7 replies

  14 years, 9 months ago

  By: Grant Fritchey

• Select statement & dividing with zero's

  Hi All, I have a Select Statment, which as far as my knowledge goes with SQL should work, the issue…

  Alasdair Thomson

  7 replies

  14 years, 9 months ago

  By: shelleybobelly

• All Fields in a Table Under One Unique Key

  Hi Everyone, I'm looking for some ideas and or feedback here. I created a settings table which hol…

  DjH

  2 replies

  14 years, 9 months ago

  By: Grant Fritchey

• Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

  hi Friends i m getting following error msg on my production server Cannot initialize the data sour…

  yogeshkadvekar-619759

  3 replies

  14 years, 9 months ago

  By: azd.bpl

• Is this even possible?! Mass update agent jobs via script.

  Hi, I've got roughly 60 agent jobs that have a step in them to send an email to a list of email a…

  DataGuy

  4 replies

  14 years, 9 months ago

  By: DataGuy

• How to have a 'text' type column included in an index

  My text [type] column is not in any joins or where clauses, but it's one of the fields in the selec…

  andegre

  11 replies

  14 years, 9 months ago

  By: andegre

• Curiosity Question - Do you run only perfect, never fails software apps on your systems?

  I always believed that there was no such thing as %100 perfect/Bug-free software, at least not anyt…

  YSLGuru

  6 replies

  14 years, 9 months ago

  By: Grant Fritchey

• Selecting Rows with most recent date if amount exits

  I am trying to create a view/select certain rows. I am only using one table, AR_INVOICE, to create…

  //Ravi

  3 replies

  14 years, 9 months ago

  By: //Ravi

• Query tuning

  I am looking for a performance boost from this query, as the client wants to pull a year's worth of…

  ckeeler

  11 replies

  14 years, 9 months ago

  By: ckeeler

• Using CTE to do multiple Updates to table

  Hi All, Thanks in advance. I have a situation where I'm selecting data into a table and needing to …

  JimiJett

  5 replies

  14 years, 9 months ago

  By: LutzM

• SQL Server service won't start due to the mssqlsystemresource database files not accessible

  Hi, I have the following problem. We have a Production running SQL Server 2005 SP2 and it's replica…

  skelboo

  4 replies

  14 years, 9 months ago

  By: Brandie Tarvin

• STUFF FUNCTION

  Hi Guys, I have a column in a table that I have stored in the format; --/---/--/-- e.g 01/345/76/98…

  mugahjoseph

  12 replies

  14 years, 9 months ago

  By: TurnerC

• Error 18452, I've searched high and low and I'm stumped

  I'm getting the following error when trying to connect to a server using SSMS. Login failed for use…

  kurtyue

  10 replies

  14 years, 9 months ago

  By: kurtyue