SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Difference between query in same database or linked query

  Hi! I have a database from which I would like to move some tables(log tables) to another database. …

  amns

  9 replies

  11 years, 4 months ago

  By: amns

• Long running update stats exclusive lock

  Hi, We're seeing an exclusive lock on a table with only a few rows (4) which seems to relate to upd…

  dwall 30994

  3 replies

  11 years, 4 months ago

  By: Gail Shaw

• Carriage Return in SQL Server

  Hi, would like to convert carriage return in to new fields?? can replace by comma or something else…

  Conficker

  3 replies

  11 years, 4 months ago

  By: Ed Wagner

• glen berrys script results

  Hi I am using Glen Berry's sql server diagnostics scripts and was wondering how I tell if the resul…

  PearlJammer1

  1 replies

  11 years, 4 months ago

  By: spaghettidba

• Clearing Plan Cache

  Hi, I am experiencing slow performance in SQL Server. This is resolved by executing DBCC FREEPROCCA…

  navtec

  23 replies

  11 years, 4 months ago

  By: navtec

• Group by using one column only

  Hi, I am stuck on this query if someone could please help me. For a sub-query, I need to use the Gr…

  pwalter83

  10 replies

  11 years, 4 months ago

  By: David Burrows

• i want to help

  i want to split IREDELL_NC_0_0,MARICOPA_AZ_0_3.5 this thing so can you help me

  ajaychaturvedi20

  2 replies

  11 years, 4 months ago

  By: ajaychaturvedi20

• Last Updated SP's Details?

  Hi All, We are having around 60 sp's, All the developers will work on those sp's. In that i want to…

  Chowdary's

  9 replies

  11 years, 4 months ago

  By: Chowdary's

• max degree of parallelism / statistics

  Hi Everyone, I have been reviewing at a nightly SQL Server optimisation Job we have running on our …

  TerrenceTheCat

  3 replies

  11 years, 5 months ago

  By: tye 20249

• SQL dba role with limited access/permissions.

  I would like to allow SQL dba's to be able to do their normal jobs administering the database as we…

  sKreetz!

  7 replies

  11 years, 5 months ago

  By: Eric M Russell

• Maintenance Plan DB integrity check questions!!!

  I have almost a 1 TB database. Is Maintenance Plan wizard is good enough to check integrity check f…

  Tac11

  7 replies

  11 years, 5 months ago

  By: Anonymous

• Column content is truncated when I view but there when I process

  I'm using 2008 R2 and I have a column with a test field. I know that there are 497 records in the f…

  allenb-717661

  7 replies

  11 years, 5 months ago

  By: allenb-717661

• sp_spacesued output into a table.

  Hi Just trying to make weekly reports for 'Adventure works' database using sp_spaceused (not table…

  Tac11

  4 replies

  11 years, 5 months ago

  By: Bill Talada

• Rebuild Index first or Update statistics first?

  I am planning to use Maintenance plan to rebuild index and update statistics. I know, rebuild index…

  Tac11

  8 replies

  11 years, 5 months ago

  By: Gail Shaw

• Deleting the foreign key reference

  Hi All, I have two tables. Main table name is Department which has below mentioned columns DeptId i…

  priyanka.ks

  2 replies

  11 years, 5 months ago

  By: priyanka.ks