SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Investigating deletes from a table

  Hi! This is my first post here, but I'm a longtime reader. I'm investigating who or what is deletin…

  daniel.harper

  5 replies

  11 years, 6 months ago

  By: MMartin1

• CSV CRLF Issue

  Hi All I have a user who is providing a csv of SQL data exported from ssms. When she exports the da…

  MichaelMontgomery

  4 replies

  11 years, 6 months ago

  By: MichaelMontgomery

• Repeat a value for 'n' times

  Hi guys, I have a table with a column id_log that has different values: | id_log | +-------+ 1…

  MariusC

  2 replies

  11 years, 6 months ago

  By: MariusC

• High Queue in Service Broker

  Hi SQL Master, I would like to ask you about Service Broker. It is urgent. My production database s…

  WhiteLotus

  5 replies

  11 years, 6 months ago

  By: Jack Corbett

• Proper Shutdown of SQL Servers in a Cluster

  I was just wondering what the best approach should be for shutting down an Active/Active Cluster wh…

  PhilipC

  9 replies

  11 years, 6 months ago

  By: PhilipC

• can you call a linked server within a function

  I'm trying to create a function that will select using a linked server. Am getting error "remote ta…

  Denise McMillan

  3 replies

  11 years, 6 months ago

  By: Sean Lange

• Varbinary(max)

  Hi Guys, I have a Table "Candidate" which has column "Resume" which is in VARBINARY(MAX). Now we ne…

  Mr. Kapsicum

  6 replies

  11 years, 6 months ago

  By: Koen Verbeeck

• unable to connect or ping the server.

  I am wondering if I can get some help from the community? I am connected to the network and trying …

  LearningDBA

  2 replies

  11 years, 6 months ago

  By: LearningDBA

• Problems doing point in time recovery

  Hi, I have a database which has one full back and 3 transaction log backups which were taken straig…

  navtec

  9 replies

  11 years, 6 months ago

  By: navtec

• Profiler Trace - 'blocked process threshold'

  Hi, Configured Sql Server side trace to capture dead locks, declare @on bit set @on = 1 exec sp_tr…

  Minnu

  8 replies

  11 years, 6 months ago

  By: Grant Fritchey

• things to consider while rebuilding indexes online

  Hi All, I have no experience with rebuilding indexes online, so i would like to know if i need to k…

  Akayisi

  2 replies

  11 years, 6 months ago

  By: Akayisi

• batch requests/sec and Compilations/sec

  Hi Is it correct in saying that if your compilations/sec are greater than 10% of your batch reques…

  PearlJammer1

  4 replies

  11 years, 6 months ago

  By: Gail Shaw

• SQL Server RUNNABLE SPID - KILLED/ROLLBACK

  Hi All, I had 3 spids in a runnable state from 3,2 and 1 days back. These had been caused by some S…

  bugg

  10 replies

  11 years, 6 months ago

  By: bugg

• keeping size of DB down

  Hi I archive a table daily: The ArchiveDB (mdf file) continues to grow in size. Even though I delet…

  terry999

  3 replies

  11 years, 6 months ago

  By: terry999

• Copy whole instance to different server.

  Hi, What is the best method to copy everything (including jobs, maintenance plan, alerts) to differ…

  Tac11

  4 replies

  11 years, 6 months ago

  By: Perry Whittle