SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Select Max date ???

  Hi I have two tables I need to get info from Client Services I need to find clients with whose las…

  jbalbo

  12 replies

  12 years ago

  By: bkmooney

• Multiple joins to the same temp table

  Hi all I'm looking for some advice on speeding up a query that seems a bit long winded. I've manage…

  richardmgreen1

  5 replies

  12 years ago

  By: lnardozi 61862

• Insert Records into a table if it does not exist

  Dear Data Wizards, Please help a simpleton looking to learn SQL. In this case 2 users are missing f…

  the.roof

  6 replies

  12 years ago

  By: the.roof

• SSMA and SYSDB

  We have a system that has been ported from Oracle using SSMA. I can find very limited info about pe…

  five_ten_fiftyfold

  9 replies

  12 years ago

  By: Baggy

• Schema

  I have sysadmin access to the sql server, long time back i created SQL User called DB_SQL and I cre…

  Nita Reddy

  5 replies

  12 years ago

  By: Nita Reddy

• CXPACKET. What are the downsides of this wait type?

  This wait type occurs because a query has been "parallelised" and the organizer/coordinator thread …

  tct_sql_admin

  5 replies

  12 years ago

  By: Grant Fritchey

• How to Identify collection amount is against which due amount

  Hi Below is the table related to my requirement, For a lnno, I had Due and collectio…

  avdhut.k

  5 replies

  12 years ago

  By: Matt Miller (4)

• Update records in table..

  Hi everyone Hope somebody can help... I have a table of records that contains 2 records per custome…

  ByronOne

  9 replies

  12 years ago

  By: higgim

• grant select

  i have 100 + of tables want to provide select permissions to all the tables which starts with A i…

  ramyours2003

  2 replies

  12 years ago

  By: Perry Whittle

• Linked Server: Trusted SQL server Error

  I have two database one is SQL2008 (on Windows 2003 server) and SQL2000 (on Windows 2000 Server). I…

  nitin jain-250047

  4 replies

  12 years ago

  By: amy26

• Migrate GUID TO BIGINT

  Hi Can we migrate GUID TO BIGINT at non peak hour ? I am having a table with around .5 billion reco…

  yuvipoy

  6 replies

  12 years ago

  By: Grant Fritchey

• BACKUP command hanging

  I'm running the following command to backup a 500GB database to a USB drive that's attached to the …

  Abu Dina

  15 replies

  12 years ago

  By: Abu Dina

• blocking session id does not release its key

  Hi All, I have a strange problem. I just migrated datawarehouse db from windows server 2008 to 2012…

  Akayisi

  12 replies

  12 years ago

  By: Gail Shaw

• make a full script of a database using query

  hello all. i need a query that make a full script (schema & data) from a database. i can do it…

  khosro.forum

  4 replies

  12 years ago

  By: khosro.forum

• Database connection failed

  Dear Steave, I am facing one problem with SQL connectivity from the application. Please guide me th…

  Raamamohan

  13 replies

  12 years ago

  By: SQLBuddy123