SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Space

  I am facing major issue on one of my sql db which contain 311 Tables and some of the table zie is l…

  Nita Reddy

  2 replies

  15 years ago

  By: parthi-1705

• Inner joining columns, but with different names?

  Hey guys, So here's sample syntax for joining two tables: SELECT Persons.LastName, Persons.FirstNam…

  rizen3377

  2 replies

  15 years ago

  By: rizen3377

• Space Used number is not decreasing as expected

  Good morning all, Environment: SQL Server 2008 x64 I've got a very large (750m) row table to which …

  Tim Mitchell

  2 replies

  15 years ago

  By: Tim Mitchell

• Identify duplicate records where all fields, except one field, are the same.

  I have a temp table with 9 fields.( Customer number, size, description, brand, etc.) The table als…

  GElwood

  7 replies

  15 years ago

  By: GElwood

• Sort Data by Time but start at specific time

  Hi, I have a table which contains 24 hours worth of events for a TV channel (running from 11:30:00:…

  JayK

  4 replies

  15 years ago

  By: JayK

• How many users authenticated againsts DB in a day

  Hi, We need to know how many users are authenticating against the DB on a daily basis and how many …

  rgarayia

  1 replies

  15 years ago

  By: rgarayia

• Merry Christmas and Happy New Year 2011

  Hello All, Wishing you and your family have the blessing, happy, and joyful Merry Christmas and hap…

  Ed7

  1 replies

  15 years ago

  By: GSquared

• partition table,File group on Single hardDrive

  Hi All, I was reading about partition tables in sql server 2008. there are few questions in my mind…

  fawwad

  7 replies

  15 years ago

  By: Gail Shaw

• How to Use BINARY_CHECKSUM operation.

  Hi How to do this GO CREATE TABLE #myTable (column1 int, column2 varchar(256)); go CREATE TABLE #…

  parthi-1705

  3 replies

  15 years ago

  By: Lamprey13

• BackupDisk File Errors?

  I have been receiving sporadic errors saying: DESCRIPTION:BackupDiskFile::OpenMedia: Backup device…

  craig-404139

  1 replies

  15 years ago

  By: David Benoit

• Data Compression and Index Rebuild

  Hi I have 'page' compressed an index on a 250 million row table and did observe better SELECT perfo…

  brian118

  5 replies

  15 years ago

  By: Nadrek

• Need help on Microsoft SQL Server 2008 R2 Service Pack

  I installed Microsoft SQL Server 2008 R2 (10.50.1600.1 RTM Enterprise Edition 64-bit) on Window…

  Ed7

  4 replies

  15 years ago

  By: Ed7

• product key

  Hello, Is there a way to find the product key after I installed sql2008? We have several servers wi…

  roy.b

  5 replies

  15 years ago

  By: Elliott Whitlow

• Query help - using results from one query in another

  Hi I'm rather a newbie to ssrs and t-sql, my previous experience in business objects, crystal repor…

  elkirk75

  2 replies

  15 years ago

  By: Daniel Bowlin

• Index usage in a server

  Is there any way to find out the number of objects(procs) used an index of a table. Sya I have tabl…

  Latheesh NK

  11 replies

  15 years ago

  By: SQLRNNR