SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• WildCard Performance Impact

  Hi everyone, I am using WildCard % in one of my queries. Weird is that when the wildcard % is used …

  tanvishriya

  2 replies

  13 years, 6 months ago

  By: Evil Kraig F

• Retrieve data between 2 '.'

  Hi geniuses! Hi have a field (VALUE), which contains data like: MNN.helloworld GFF.goodbyeworld SSW…

  davdam8

  19 replies

  13 years, 6 months ago

  By: CapnHector

• I would like to be able to trace who or what process made a change to a stored procedure

  I would like to be able to trace who or what process made a change to a stored procedure. I am usi…

  stevenplee

  2 replies

  13 years, 6 months ago

  By: Jason Selburg

• spId -2

  Hi , While running some transaction i got blocked by spid -2 and i'm not sure what it is.. We are t…

  tripri

  1 replies

  13 years, 6 months ago

  By: Mike.Hahn

• WOSYST database to a SQLserver db

  Does any one know how to convert a wosyst database (St. Croix Systems) to a sql server. I have trie…

  knakka99

  3 replies

  13 years, 6 months ago

  By: Joie Andrew

• Query performance change

  The following query was executing within 1 minutes for the past 2 years without any issues. upda…

  twoeyed

  8 replies

  13 years, 6 months ago

  By: DiverKas

• Select ... For Xml Auto, XmlSchema

  Agradeceré mucho a quien me resuelva esta consulta. Tengo una tabla muy sencilla llamada DIVISAS y …

  Hans MZ

  9 replies

  13 years, 6 months ago

  By: Mikael Eriksson SE

• Removing only contiguous/adjacent duplicate records from a rowset

  In SQL 2008, is there any way to remove only adjacent/contiguous duplicate records? Only if a recor…

  praveen_vejandla

  15 replies

  13 years, 6 months ago

  By: Jeff Moden

• How to copy a System Stored Procedure to another server

  Hey, We have a Production SQLServer and a Report SQLServer (on which reporting queries are run). On…

  Raymond van Laake

  5 replies

  13 years, 6 months ago

  By: Bhuvnesh

• SSRS 2008 R2 - print problem

  What has to be done in Report Properties besides specifying page dimensions (e.g. 8.5 by 11 vs. 11 …

  david.kratz

  2 replies

  13 years, 6 months ago

  By: david.kratz

• How can I sort this?

  CREATE TABLE #tblTasks ( TaskID int, BaseTaskID int ) GO INSERT INT…

  webskater

  10 replies

  13 years, 6 months ago

  By: T_Dot_Geek

• Why does my SUMFUNCTION doesn't work?

  Hi geniuses! Can anybody detect the error here? The real info is: NP |:| VT |:| DtL2010 |:| Analisy…

  davdam8

  6 replies

  13 years, 6 months ago

  By: Eugene Elutin

• Deadlock on the same resource with incompatible locks

  Hi, I have a table named ClientContext that has only the clustered index. I have a procedure sp1 th…

  ioani

  2 replies

  13 years, 6 months ago

  By: ioani

• How to store massage of SQL server Query Results

  Hi , I want to store Massages of SQL server Query Results in variable or table . Or Is there any w…

  nikki_d

  4 replies

  13 years, 6 months ago

  By: twoeyed

• SQL Schema Foreign key Relationships Diagram

  have a SQL Server 2008 DB (A)with more than 400 tables where in tables have many constraints(foreig…

  sanoasis

  2 replies

  13 years, 6 months ago

  By: Lowell