SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• ? on merging fields

  Hi I have a table(Comments) two columns clientno and comment one clientno can have many comments I…

  jbalbo

  15 replies

  11 years, 5 months ago

  By: Sean Lange

• Question on data compression

  I have a table with with several XML columns stored as VARCHAR(MAX) because they some of the XMLs m…

  N_Muller

  16 replies

  11 years, 5 months ago

  By: Igor Micev

• Transactional replication: how to replicate new objects without re-creating replication?

  We have a transactional replication for a database with size 220 GB. It was created with backup/res…

  SQL Guy 1

  6 replies

  11 years, 5 months ago

  By: SQLRNNR

• Stuck stored procedure

  I have a stored procedure that creates backups of all the databases on my server. It is called from…

  pdanes

  5 replies

  11 years, 5 months ago

  By: ScottPletcher

• Audit connections via extended events

  Hi, I am looking for a little bit of advice on how to setup an extended event in SQL 2008 R2 which …

  RTaylor2208

  5 replies

  11 years, 5 months ago

  By: SQLRNNR

• Count of Membership per month starting beginning of each year

  I need some help with a script to count the total amount of members each month of current year. I h…

  QQ-485619

  1 replies

  11 years, 5 months ago

  By: Jack Corbett

• if where on update doesn't match do an insert

  hi, I have this UPDATE EPSBankRef SET OrthoID = '@Request.inpHidden~' WHERE BankID = SUBSTRING('@…

  mattech06

  3 replies

  11 years, 5 months ago

  By: SQLRNNR

• Detaching the database to free up space

  I am trying to free up some space in the server by detaching the unused database and deleting the l…

  Guras

  3 replies

  11 years, 5 months ago

  By: Guras

• Tempdb not releasing the space

  I did try shrink the tempdb database then file. Also, restart SQL Server to release tempdb space to…

  Admingod

  7 replies

  11 years, 5 months ago

  By: Admingod

• 4 Data files and 3 Log files on same drives!!

  I've got a Production server with 4 data files on D:\ and 3 Log files on L:\. which was migrated fr…

  Tac11

  4 replies

  11 years, 5 months ago

  By: Tac11

• Difference in Time for same query

  Query time having different timings Start Time End Time 2014-07-23 12:10:2…

  yuvipoy

  6 replies

  11 years, 5 months ago

  By: Grant Fritchey

• Update from another table using substring..

  Hi, I have a table BankRef with a BankID column that was populated from the first 24 characters of …

  mattech06

  1 replies

  11 years, 5 months ago

  By: Brandie Tarvin

• Having issues transferring file from 1 server to another.

  I d' like to get some help with the problem I am having transferring the backup file (42GB) from 1 …

  Chitown

  1 replies

  11 years, 5 months ago

  By: Ray Herring

• changing a columns data type

  Hi I have a requirement to change some fields from nvarchar(max) to something more suitable ie Nvar…

  PearlJammer1

  3 replies

  11 years, 5 months ago

  By: PearlJammer1

• Cannot add foreign key

  Hi, I dropped a foreign key constraint on a table and now trying to add it back again. However, I g…

  pwalter83

  3 replies

  11 years, 5 months ago

  By: Jack Corbett