SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Table size and indexes

  How many rows does a table need to have before you start thinking about adding an index?

  NineIron

  38 replies

  9 years ago

  By: Eric M Russell

• Matrix not Sorting

  Hi, I have a query that select exported products by sea and air per month but now when i put the in…

  kgeeel240

  2 replies

  9 years ago

  By: kgeeel240

• high availability sql server 2008 r2

  Dear All Complements of the season !!! I am using MS SQLSERVER 2008 R2, my question is related to H…

  satish 61764

  4 replies

  9 years ago

  By: Mr. Brian Gale

• Error 0x80131904, I need some help with connection string.

  Hello everyone.My friend has a server at home, doing some work with accounting with an SQL custom c…

  installerrev

  4 replies

  9 years ago

  By: Mr. Brian Gale

• Override Columns in Insert and Update

  I hope someone can give me suggestions on how to handle this situation of triggers.  An a…

  bobd125

  1 replies

  9 years ago

  By: Gail Shaw

• calling back function

  hi.. how can i call back the function dynamically? i create a function. ALTER FUNCTION [dbo].[test]…

  girl_bj

  9 replies

  9 years ago

  By: sgmunson

• Query processor could not produce a query plan because of the hints

  Hello all I have a "weird" case on my hands I have two servers one a 16 core with SQL Server 2008 R…

  ricardo_chicas

  7 replies

  9 years ago

  By: Johannes Fourie

• Import from File

  Hello,I've searched, and while there is some info, I've been unsuccessful as of yet.  I'm able…

  John524

  6 replies

  9 years ago

  By: Jeff Moden

• Change tracking when does run sys.sp_flush_commit_table

  Hi As the subject line says, what's the trigger for the sys.sp_flush_commit_table stored proce…

  alex.palmer

  1 replies

  9 years ago

  By: Sue_H

• how to limit table row and display remaining data in next column in sql

  My table data.id    clientname    contactperson  …

  abuzar_ansari123

  9 replies

  9 years ago

  By: abuzar_ansari123

• How to find which procedure is compiled in sql server many times

  Hello, If I want to search which are all procedures are recompiling part of the with recompile opti…

  SQL_Hunt

  2 replies

  9 years ago

  By: SQL_Hunt

• Using Case in a Where Clause.

  Hello, Using the following example tables and query: create table AccountTable (AcctNum int p…

  bubs

  2 replies

  9 years ago

  By: bubs

• Extended Events locks

  Dear colleagues,I am setting up extended events in a SQL Server 2008R2 SP3 with an interests in get…

  Lou

  2 replies

  9 years ago

  By: Lou

• Running Total

  I have the following dataset:CREATE TABLE #mytable (PartNum varchar(50),DueDate datetime,Requiremen…

  robertopmorris

  18 replies

  9 years ago

  By: Jeff Moden

• redesigning table to accommodate new data types

  i have a table in which there is  column called Marks of type int. This is used to save the ma…

  hlsc1983

  32 replies

  9 years ago

  By: ScottPletcher