SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• job fails with linked server

  Hello everybody. I'm getting an error in a job that I can't explain myself. I have two servers: ERP…

  faberDB

  3 replies

  13 years ago

  By: chris.mcgowan

• Ghost Cleanup and CHECKPOINT after Migration to SQL 2008 R2

  I am migrating a database from SQL 2005 to SQL 2008 R2. As soon as the database is restored over to…

  apat

  6 replies

  13 years ago

  By: chris.mcgowan

• partitioning strategy for this scenario:

  HI Here is the scenario: Data is loaded in Table "ABC" every week and size of 1 week data is around…

  S_Kumar_S

  5 replies

  13 years ago

  By: Gail Shaw

• Performance Tuning

  I have a Table called Employees with following Columns EmployeeID INT EmployeeName VARCHAR(256) Sal…

  Anjan@Sql

  13 replies

  13 years ago

  By: Abu Dina

• adding a prefix to a column in an SQL view

  Hi all, Is it possible to add a prefix to a returned result in a view in sql. eg select productId…

  dallibabs

  7 replies

  13 years ago

  By: dallibabs

• get overtime hours

  i am have a problem to get overtime hours the table EmployeeNo TimeIn TimeOut BreakHours WorkingHou…

  sugiarttampubolon

  7 replies

  13 years ago

  By: Lynn Pettis

• Indexes with JOINs

  Hi all, I have some knowledge about indexes but it's very fuzzy when the queries become more comple…

  The Comedian

  6 replies

  13 years ago

  By: The Comedian

• In my laptop some times sqlserver getting problem while connecting in to the instance

  HI all , In my laptop some times sqlserver getting problem while connecting in to the instance 1.…

  naga.rohitkumar

  2 replies

  13 years ago

  By: Lowell

• Compare scripts B4 and After a Performance Fix !

  "How can I"/"what are all the ways I can" compare a query/SP before and after a Performance Fix, to…

  SqlServerPass

  1 replies

  13 years ago

  By: chris.mcgowan

• Count number of visits by week, ending on Saturday

  I am trying to get a count of visits by week with the week ending on Saturday. My problem is gettin…

  NineIron

  14 replies

  13 years ago

  By: NineIron

• xp_cmdshell slow response

  I am using xp_cmdshell to bcp out a small table to a file and than copy it inside the local disk. 1…

  Gil_Adi

  1 replies

  13 years ago

  By: Gil_Adi

• Update statement really slow but only on the first execution

  Hi, I have a standard update statement that updates one row at a time. The table size is 340,000 r…

  lewisdow123

  13 replies

  13 years ago

  By: lewisdow123

• Weekly report through whole year

  Hi there I have 2 tables and sample data: ---------------------------------------------------------…

  roman 19626

  6 replies

  13 years ago

  By: roman 19626

• Error on SQL job - SQL 2008

  Hi, Can someone help us to determine the resolution for the encountered error below. Message Execut…

  gracey

  3 replies

  13 years ago

  By: VickyDBA

• Creating array in sql server

  A string contains 3,4 suppose I want to store 3 in one parameter and 4 in another parameter similar…

  rama.king127

  5 replies

  13 years ago

  By: Mansfield