SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Allocating new partition on existing partitioned table

  I have a table with millions of rows in it that a previous DBA partitioned about 3 years ago. This …

  Garick Newtzie

  2 replies

  14 years, 2 months ago

  By: Garick Newtzie

• columns of the primary key of all tables of all schemas

  I want to list all columns of the primary key of all tables of all schema Could you please help me?…

  aslhanhanc

  4 replies

  14 years, 2 months ago

  By: aslhanhanc

• Convert double to varchar

  I need to convert one old order table tOld to new table tNew. There is a column [OrderID] (data typ…

  adonetok

  2 replies

  14 years, 2 months ago

  By: Ant-Green

• mySQL and not SQL2008?

  We have 4 production servers still running sql 2000. I finally convinced business that it is time t…

  Casper101

  10 replies

  14 years, 2 months ago

  By: CapnHector

• Sql Server Schema backup

  Do I take backup of a single schema of a database in sql server?

  Sherlock

  6 replies

  14 years, 2 months ago

  By: Gail Shaw

• Need Help: select record with auto id for a combination of columns

  I have a table with below details OrderId, PersonId, Name, Product, Date 1, 1, AA, AA, 01/01/2012 2…

  iam777here4u

  3 replies

  14 years, 2 months ago

  By: iam777here4u

• txt import to sql

  Hi Guys, I need to import .txt file into sql server 2008 R2 & i want to schedule the import. K…

  Mayur Dhumal

  7 replies

  14 years, 2 months ago

  By: Mayur Dhumal

• about restore database

  Hi all RESTORE HEADERONLY FROM DISK = 'C:\Backup\Adventureworks.bak'; I ran this command and got th…

  praspras42

  5 replies

  14 years, 2 months ago

  By: Gail Shaw

• Keep both version of BIDs and client tools

  We have some servers are SQL server 2008, some are SQL server 2008 R2. I have my work station insta…

  sqlfriend

  1 replies

  14 years, 2 months ago

  By: Koen Verbeeck

• Selecting minimum value per ID from Table.

  Urgent Help required in implementing below using SQL SERVER 2008. I have a table with the following…

  sunnyepgc

  13 replies

  14 years, 2 months ago

  By: sunnyepgc

• Change the name of the constraint

  Hi everybody..i got a problem i add a constraint PK1 Use test GO ALTER TABLE tablo1 ADD CONSTRAINT …

  johnny1walker

  5 replies

  14 years, 2 months ago

  By: Jeff Moden

• how often we need to update the windows patches in production and reboot them?

  Hi, I just wanted to know how often we need to update the windows patches for SQL Server in product…

  gary1

  1 replies

  14 years, 2 months ago

  By: CapnHector

• defaut

  i have one column with int data type .and i want default values for that 12/31/2099.how i can do th…

  weston_086

  3 replies

  14 years, 2 months ago

  By: Lowell

• SQL Statistics on a sequential DATE table

  I have seen and use a DATE table for a db that I use for weather reporting The date table is typica…

  stuff 56271

  5 replies

  14 years, 2 months ago

  By: Gail Shaw

• SQL Server has encountered XXXX occurrence(s) of I/O requests taking longer than 15 seconds to complete on file

  Hi guys.. Any idea about this message ? SQL Server has encountered 4375 occurrence(s) of I/O reque…

  SQlLogic

  8 replies

  14 years, 2 months ago

  By: Gail Shaw