SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SP not working same on SQL 2008 as SQL 2005

  I have a VB.Net console application that works with a SQL server DB using stored procedures. I have…

  DaGmen

  12 replies

  16 years ago

  By: Ben Teraberry

• Clustered Index Modification

  I have a database with a lot of 'too-wide' clustered indexes, many of which include uniqueidentifie…

  Garadin

  10 replies

  16 years ago

  By: Paul White

• IO of backup

  Is using a backup command with STATISTICS IO a good way to calculate how much IO a backup will take…

  repent_kog_is_near

  3 replies

  16 years ago

  By: SQLRNNR

• Fast Query Slow when using Table Variable

  I have a query that does a number of left outer joins. The query returns only a single row and is f…

  stroebele

  6 replies

  16 years ago

  By: Paul White

• sys.dm_db_index_usage_stats

  Is this DMV populated for all the indexes for all the databases? or does it get filled as indexes a…

  repent_kog_is_near

  2 replies

  16 years ago

  By: Paul White

• Same user id on Prodcution and DR

  I have production SQL server and DR Sql Server, want to restrict some users from running query on m…

  sh.jigar

  2 replies

  16 years ago

  By: sh.jigar

• SSAS + SSRS 2008 SET DEFAULT DATE / DATEPICKER

  LS, Is it possible to set the default value for a date-parameter in an SSRS report (using OLAP as a…

  cees van diermen

  1 replies

  16 years ago

  By: cees van diermen

• Datawarehouse advice

  I've got execs breathing down my neck for "BI BI BI" and how we should use this tool or that tool. …

  Matthew Cushing

  2 replies

  16 years ago

  By: Matthew Cushing

• SQL Server 2008 installation failed

  I am attempting to install SQL Server 2008 developer onto a brand new Dell (32 bit) running Windows…

  twelchercp

  3 replies

  16 years ago

  By: Ben Teraberry

• Help with ..FAILED TO CONVERT PARAMERTR VALUE FROM STRING TO INT32

  I have a table with different columns ( CourseCode int, title nvarchar,creditHour int...) courseCod…

  teddy.sfsu

  1 replies

  16 years ago

  By: Ben Teraberry

• Table level backup

  Hi Experts, Is it possible to take a table level backup? TIA

  VastSQL

  6 replies

  16 years ago

  By: SQLRNNR

• Sql Server 2008 Installation

  All: OS Windows 2008 R2 Server Processor: 64 bit I have been given a CD of Sql server 2008 when I e…

  basha.adil

  2 replies

  16 years ago

  By: Perry Whittle

• To find out actual owner of the table

  Does any body know how we can get the actual owner (username) of the table using a query?

  srivishiva

  11 replies

  16 years ago

  By: SQLRNNR

• Help with Query-one primary key in a table linked to many column in the second table as a forein key

  I have two tables( Eg EMPLOYEE and TRANSACTION). EMPLOYEE table has columns ( EmpID,EmpFirstname,Em…

  teddy.sfsu

  3 replies

  16 years ago

  By: teddy.sfsu

• Find first missing number

  I have a table with a column which is not a primary key but which I increment by 1 each time a new …

  webskater

  6 replies

  16 years ago

  By: WayneS