SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• query help

  hi friends i am new to sql i have a table with fields Table=ATTENDANCE Attenid studentid t…

  sameergadade1

  1 replies

  13 years, 10 months ago

  By: Brandie Tarvin

• OPENROWSET issue with 64bit vs 32bit

  I have windows 7-64bit/ SQL Server 2008 R2-64bit; but my MS office is 32 bit/ ODBC Drivers 32 bit. …

  Joe-420121

  6 replies

  13 years, 10 months ago

  By: Joe-420121

• Database MDF File Size Issue

  Hi, I have a Database which size is 80 GB, and It has duplicate table for all tables. So I dropped …

  amitsingh308

  7 replies

  13 years, 10 months ago

  By: amitsingh308

• why nvarchar using in sql?

  why nvarchar using in sql?

  artcvmna

  3 replies

  13 years, 10 months ago

  By: the.kaustubh

• !HELP! T- SQL Script which displays DataName, Physical_location, DataSize, DBGgrowth, DB Max, Available Free Space Data LogSize, LogGrowth, Log Max Available Free Space Log

  Urgent help needed, Thanks in advance. Can I get T- SQL Script which displays for all the database…

  anzz

  1 replies

  13 years, 10 months ago

  By: SQLRNNR

• Help with join types/usage

  Hello, We are working with a table that has a list of ~400 uniquely identified products. I need to …

  cjcolton

  5 replies

  13 years, 10 months ago

  By: cjcolton

• optimization of query

  This is there any way that i can optimize this query.If i run it takes too long.i want to write it …

  weston_086

  12 replies

  13 years, 10 months ago

  By: ScottPletcher

• domain login with dollar sign

  Hi guys, I've recently inherited a sql server and I've noticed there are quite a few logins like be…

  RedDoorSQL

  3 replies

  13 years, 10 months ago

  By: RedDoorSQL

• monitoring DBsize, DBfree, DBGrowth, DBMax, LogSize, Logfree, LogGrowth, LogMax.

  Hi, need help in monitoring DBsize, DBfree, DBGrowth, DBMax, LogSize, Logfree, LogGrowth, LogMax. I…

  anzz

  1 replies

  13 years, 10 months ago

  By: Jack Corbett

• sql server2008 query- To split the delimited values in the table ibnto multiple rows

  Hi, Iwould like to have the delimited values in one of the columns in sql server table to be split …

  arubala75

  3 replies

  13 years, 10 months ago

  By: arubala75

• Getting Select suspended Lock out

  Hi Guys, I am running an application where there is happening insertion and updation with select by…

  prafullaranjan.swain

  2 replies

  13 years, 10 months ago

  By: Jack Corbett

• How to check if column has set to identity??

  How to check if column has set to identity??

  komal145

  3 replies

  13 years, 10 months ago

  By: komal145

• Push versus pull replication when all else is equal

  Hello, I've read the various things on deciding whether to use push or pull replication. Like serve…

  kevinv

  2 replies

  13 years, 10 months ago

  By: MysteryJimbo

• linked server connectivity fails between SS2k8 R2 and MAS90

  Hi, I am getting the folowing error when configuring the linked server between ss2k8r2 and mas90 da…

  Pyman

  3 replies

  13 years, 10 months ago

  By: Welsh Corgi

• Updating Stats on Non-Indexed Data

  Hello, Does anyone know if update statistics works on everything or if it can be tweaked to only up…

  Libby1981

  1 replies

  13 years, 10 months ago

  By: Jeffrey Williams