SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Knowing which tables to drop - HouseKeeping

  Hi, Over the years our DWarehouse has expanded and there are a few tables on the Databases that we …

  SQL_Kills

  1 replies

  13 years ago

  By: Grant Fritchey

• SQL 2000 Install

  I need to install SQL 2000 on a VM that already has 3 instances of SQl 2008 R2 installed. Something…

  Super Cat

  6 replies

  13 years ago

  By: Super Cat

• Log Shipping using Virtual Servers

  Good morning all, I'm looking at implementing log shipping on two virtual servers running VMWare an…

  WWDMark

  3 replies

  13 years ago

  By: WWDMark

• How to update string based on Dates.

  Create Table #temp ( Lnno varchar(15), Inst_Date Datetime , Amount Numeric(12,2) ) Create…

  avdhut.k

  5 replies

  13 years ago

  By: avdhut.k

• Clustered Indexes on Identity columns

  Hello, I had a quick question for everyone... I often wondered why Clustered Indexes are usually p…

  DaveDB

  10 replies

  13 years ago

  By: ScottPletcher

• Insert Temp Table help.

  I have a query that "Mickey" on here helped me with that I made some changes and it works wonderful…

  thomashohner

  1 replies

  13 years ago

  By: thomashohner

• Caclulating two-tailed Student's t-distribution

  I would like to calculate the two-tailed Student's t-distribution from within T-SQL. Excel does th…

  jnp15

  3 replies

  13 years ago

  By: Yelena Varshal

• sql 2008 r2 cluster installation failed

  While installing sql 2008 r2 cluster ,it failed with below error. " microsoft sql server 2008 r2 cl…

  bala2

  1 replies

  13 years ago

  By: Loundy

• Update Script to handle databases where Inactive

  Hi, I am looking to find script that works for updates to handle databases which have been Inactiv…

  mac_live

  5 replies

  13 years ago

  By: mac_live

• TSQL QUERY HELP

  Can anybody help with the following query: Basically its returning 100% when all records are popul…

  PearlJammer1

  11 replies

  13 years ago

  By: PearlJammer1

• Trimming column values in place (without temporary tables, etc)

  I have four tables containing the regular chars and varchars. Unfortunately, no one bothered to tri…

  jhom

  2 replies

  13 years ago

  By: jhom

• make VARCHAR field longer on a large table

  >>>>Scenario: SQL Server 2008 R2 on a Windows cluster, 256 GB RAM, 32 CPU there is a no…

  Sergei Zarembo

  4 replies

  13 years ago

  By: Sergei Zarembo

• Merge_Replication_Tables_Not_In_Sync(MSmerge_tombstone)

  We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by de…

  nadeem.mmd

  1 replies

  13 years ago

  By: Sean Lange

• Fastest way to read a 600MB table (in memory)

  A few days ago I came across this interesting problem: I cannot get more than 15-19mb/s is there an…

  noeld

  20 replies

  13 years ago

  By: Erland Sommarskog

• Sql Server Objects Naming Conventions

  Hello all I have recently been tasked with putting a naming convention in place for a new Sql Serve…

  OTF

  5 replies

  13 years ago

  By: Ed Wagner