SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Create user and Assign Password

  Hello Every Body. I am very new in SQL Server 2008 and using XP as a operating system. i want to cr…

  smbilal_84

  1 replies

  15 years ago

  By: Suresh B.

• Sql server restarted

  I found yesterday evening one of our sql server are restarted; I checked with some guys who are the…

  sqlfriend

  8 replies

  15 years ago

  By: Ian Scarlett

• Reindexing

  I do reindex for 1 clustered index and 16 nonclusterd in my table using the cmd ALTER INDEX ALL ON …

  premkuttan

  6 replies

  15 years ago

  By: smackie1973

• Memory limit < Memory used?

  Hi there, Im just wondering if anyone can shed any light on this: We have a sql 2008 x64 on win ser…

  Rin Sitah

  8 replies

  15 years ago

  By: Gail Shaw

• Connection Manager in SSIS - Facing an issue

  Hi all, I've a SSIS package which has many data flow tasks. Each data flow tasks pulls data from di…

  ramkaay

  3 replies

  15 years ago

  By: ramkaay

• Can not start the SQL Server Agent

  Hi I installed SQL Server R2 on my local machine(office laptop) yesterday It was ok yesterday. I …

  rohaandba

  3 replies

  15 years ago

  By: Syed Jahanzaib Bin hassan

• Could you help with my Fuzzy Lookup Problem? No error message but no result in destination table and source/lookup are in yellow

  I made sure that the reference table and the lookup table have common values first. But still the e…

  jennefer115

  1 replies

  15 years ago

  By: Gail Shaw

• Upgrade to MSSQL 2008 R2

  I use the developer edition of MSSQL . (64 bit I think) The developer edition is the enterprise ver…

  Digs

  6 replies

  15 years ago

  By: Digs

• windows and sql server restarted by itself

  Recently one of our SQL server restarted in different times by itself. Windows restarted too. What …

  sqlfriend

  1 replies

  15 years ago

  By: Welsh Corgi

• Deleting Files older than n days using SSIS

  Hi, I'm having an issue with trying to figure out how to delete files in a folder location older th…

  stormsentinelcammy

  9 replies

  15 years ago

  By: Orlando Colamatteo

• UPDATE query question

  This query was given to me today and performs very poorly but I'm not sure why. UPDATE table1 SET f…

  raistlinx

  17 replies

  15 years ago

  By: LutzM

• Help with long running query

  Hi Everyone, Can anyone possibly help with a solution for re-writing this query? The query is v…

  adamwhelan4

  8 replies

  15 years ago

  By: Gail Shaw

• Automation of table partition.

  I have a partitioned table by quarterly wise. now it has 6 fixed partitions. I want to make it auto…

  theunique1011

  5 replies

  15 years ago

  By: Evil Kraig F

• Reporting Services Execution Logging

  Hello, We just turned on Reporting Services Execution Logging. When I view the tables , there is on…

  jhill-959840

  1 replies

  15 years ago

  By: jhill-959840

• Need a SQL query to calculate the average datetime column

  Here is the condition : To calculate the average days to pay for each customer by taking the (SUM(D…

  Dhruva25

  9 replies

  15 years ago

  By: Evil Kraig F