SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Is trace flag 4199 needed after hotfix and CU have reached a Service Pack

  I know that several hotfixes need you to turn on trace flag 4199 to activate them. But after readin…

  GoofyKC

  1 replies

  11 years, 1 months ago

  By: Dave Mason

• Database Mirroring timeout setting

  Hi, I have setup database mirroring with witness server. To prevent unnecessary failover because of…

  Ryan007

  5 replies

  11 years, 1 months ago

  By: 1azeem.baig

• Query running very slow

  Hi, I need to re-write a part of the SQL query to make it run fast. I need help to replace the MAX …

  pwalter83

  11 replies

  11 years, 1 months ago

  By: CKX

• any way to return from script instead of drop existing for ddl scripts?

  Hello, Let's say I have a function named MyCustomFunction and I want to ensure that it exists in th…

  sqlguy-736318

  4 replies

  11 years, 1 months ago

  By: Luis Cazares

• Transferring 3 SQL databases from both SQL Express 2005 and Standard to a new physical server

  I am trying to figure out the best method for transferring SQL 2005 databases from 2 different phys…

  bradh 14842

  3 replies

  11 years, 1 months ago

  By: Gail Shaw

• script to return the replication status

  I need a script that will return the replication status as small int. Can someone help me with it?

  Srl832

  1 replies

  11 years, 1 months ago

  By: SQL Guy 1

• Undistributed Commands telling fibs

  I have transactional replication from two separate publishers going to same subscription instance (…

  quackhandle1975

  1 replies

  11 years, 1 months ago

  By: quackhandle1975

• bulk insert

  I want to bulk insert data into a table named scd_event_tab inside a database named rdb. when I do …

  Srl832

  9 replies

  11 years, 1 months ago

  By: Srl832

• Want to return character(s) after a dash (-)

  Hi Everyone, I want to return the character(s) in a string directly after a dash (-) character. For…

  david.dartnell

  6 replies

  11 years, 1 months ago

  By: Mike.Hahn

• Must declare the scalar variable "blah"

  I can create a temp table like this, and immediately read the data: declare @NAICSGroups table (NAI…

  showell

  2 replies

  11 years, 1 months ago

  By: showell

• Update binary column

  The last two columns in one table is [StarText](varchar(20)) and [Star] (binary). It stored data li…

  adonetok

  2 replies

  11 years, 1 months ago

  By: adonetok

• Microsoft.SqlServer.Management.Common.dll

  Hello, do you know how I can get the following dll?: Microsoft.SqlServer.Management.Common.dll I ha…

  sqlguy-736318

  4 replies

  11 years, 1 months ago

  By: sqlguy-736318

• Elegant way for returning all results when subquery returns no results?

  I have four tables: Customer (CustomerId INT, CountyId INT), County (CountyId INT), Search(SearchId…

  TheGreenShepherd

  4 replies

  11 years, 1 months ago

  By: TheGreenShepherd

• SSMS Performing Slow over remote connection

  Hi Mates, One of the instance is hosted in a cluster node with 128GB of ram and 80 processors alloc…

  abendigeri

  2 replies

  11 years, 1 months ago

  By: sihaab

• Help with finding multiple Character Occurence in String

  Hello all, I am trying to figure out how I can find the names of people who have a double occurrenc…

  thomashohner

  10 replies

  11 years, 1 months ago

  By: thomashohner