SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL Server Service Accounts

  Hello, Quick question for you all, do you tend to add your (Standard Domain User) SQL engine and ag…

  Duran

  4 replies

  14 years, 12 months ago

  By: SQLServerMS

• Problem please help me ?

  Hello Thanks for your website. I have a question about distributed system. we have a project about …

  Larry Page(Ehsan.Akbar)

  18 replies

  14 years, 12 months ago

  By: Larry Page(Ehsan.Akbar)

• Archive older data

  Hi all, I have a server(Sql server 2008 R2) with large amount of data (about 2TB). How can I divide…

  farax_x

  13 replies

  14 years, 12 months ago

  By: farax_x

• Calculating MTD Figs in SQL 2008

  hi all im fairly new to SQL so struglling a bit here, i have a table where it has the Daily sales, …

  bhavya_manoharan

  3 replies

  14 years, 12 months ago

  By: John_Hill

• SQL 2008r2 Upgrade from 2005 Fails

  I'm trying to upgrade our SQL 2005 std to 2008 r2 std. The install gets 3/4 the way done, then thr…

  grcarter

  4 replies

  14 years, 12 months ago

  By: grcarter

• dataconversion (yyyy-dd-mm to yyyy/dd/mm)

  need help with converting (yyyy-dd-mm to yyyy/dd/mm) using data conversion

  koolme_85

  8 replies

  14 years, 12 months ago

  By: Jeffrey Williams

• How do you use social media as a database professional? Students need your input! Chance to win $50 Amazon gift card!

  We are a group of students from Northwestern University and we need your help for our research. As …

  mage1gr

  1 replies

  14 years, 12 months ago

  By: Ron McCullough

• date time question

  Hello, I have two columns 'date' varchar (8) and 'time' varchar (4) I want to club 2 columns in to …

  ranuganti

  4 replies

  14 years, 12 months ago

  By: WayneS

• Linked Server (MYSQL) links ok, but cannot see tables and queries return errors

  I followed the steps in this article and successfully got a Linked Server on SSMS. http://www.ideae…

  mariann harper

  13 replies

  14 years, 12 months ago

  By: Orlando Colamatteo

• how to check if my database triggers and other objects are invoking tables that it's not exist

  Hello, I'm trying to know how to check if my database triggers and other objects are invoking tabl…

  Earl Downs

  7 replies

  14 years, 12 months ago

  By: Earl Downs

• Strange SQL 2008 R2 Missing Configuration Parameters?????

  Does anyone have any experience with this? How can this happen? I have a number of development ser…

  Melissa.Fischer

  1 replies

  14 years, 12 months ago

  By: jorgepc

• An Alternative for DISTINCT AND GROUP BY by using ROW_NUMBER()

  An Alternative for Distinct AND GROUP BY using row_number() How can I generate distinct values fr…

  ASFSDJG

  4 replies

  14 years, 12 months ago

  By: krisgomathi

• Recursively update tree item count

  I have a table as such that is self joining with child and parent IDs. There can be infinite level…

  SQLDev1

  3 replies

  14 years, 12 months ago

  By: Orlando Colamatteo

• Deploy SQL Database

  Hello... I am trying to build a deployment package for a couple of databases to automate the proces…

  sqlsponge2

  3 replies

  14 years, 12 months ago

  By: steveb.

• Need right direction to load monthly data

  I have to load monthly data in sql. Data comes from flatfile and loading in staging sql table throu…

  patla4u

  5 replies

  14 years, 12 months ago

  By: TheSQLGuru