SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Transaction log full in sql server 2008

  I read the following artticle from MSDN for resolving transaction log issues if it becomes full. I …

  Craig G

  2 replies

  11 years, 5 months ago

  By: Ant-Green

• Full Text Search Problems

  Hi I have a single table which I populate periodically from other tables, and then I have a full te…

  Atat Rowcount

  1 replies

  11 years, 5 months ago

  By: Atat Rowcount

• delete large chunk of data on replicated DB

  Hi, I have 4 SQL Servers 2008 with a merge replication. Replication runs every 10 minutes. Now, my …

  Dominic Gagné

  7 replies

  11 years, 5 months ago

  By: Dominic Gagné

• SQL Server Agent running powershell commands

  Hi All, I am trying to run the following powershell script as a job from SQL server Agent (2008 R2…

  forco02

  5 replies

  11 years, 5 months ago

  By: tuyendq

• Recording record changes in a history table?

  HI, I'm using sql server 2008 express and VB.net 2010 I have a database that records an employees p…

  Tallboy

  1 replies

  11 years, 5 months ago

  By: Ron McCullough

• improve Performance for update queries and most frequently used queries.

  please suggest me some way to improve the performance for the below mentioned type of queries.. 1)H…

  IT researcher

  1 replies

  11 years, 5 months ago

  By: Gail Shaw

• Combining multiple rows into one row

  I have a table in sql server which has more than 100 columns with rows like this eg: IDKEY INTKey…

  vnj

  1 replies

  11 years, 5 months ago

  By: J Livingston SQL

• CozyRoc Data Flow Source

  I'm having issues with CozyRoc's Data Flow Source. It seems pretty straightforward: I've created th…

  Langston Montgomery

  1 replies

  11 years, 5 months ago

  By: Langston Montgomery

• Altering a column impact on indexes?

  I feel kind of silly asking this but really don't know...does altering a column's length have any i…

  MyDoggieJessie

  2 replies

  11 years, 5 months ago

  By: MyDoggieJessie

• SSIS help needing script task to get excel schema.

  Hi guys, I need to create a package, which would load multiple excel files into an OLE DB destinati…

  Briceston

  1 replies

  11 years, 5 months ago

  By: Evil Kraig F

• SQL database shrink takes over many hours

  we truncated tables and we found over 300 gb unused or free space. So we went to shrink the databa…

  Craig G

  7 replies

  11 years, 5 months ago

  By: SQLRNNR

• Many redundant UNUSED INDEX

  HI All, I wonder why after running the "unused indexes script " as below : SELECT OBJECT_NAME(S.[…

  WhiteLotus

  1 replies

  11 years, 5 months ago

  By: Jack Corbett

• For replicated database recovery model must be full?

  Hi all, We are creating replication for various databases. Some of them have Full recovery model, s…

  SQL Guy 1

  4 replies

  11 years, 5 months ago

  By: SQLRNNR

• Coalesce for a FQN?

  The attached image is a small result set from a table in a database I have. To give an example of w…

  ken_cox

  3 replies

  11 years, 5 months ago

  By: ken_cox

• DDL Trigger Unable to access under security context

  I have an interesting issue which may have a simple solution but I'm not seeing it. There are myste…

  Erin Ramsay

  4 replies

  11 years, 5 months ago

  By: Erin Ramsay