SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Page Life Expectancy

  Hi, I have always monitored our server and looked at performance stats. The page life has always be…

  markganley

  14 replies

  15 years, 10 months ago

  By: Grant Fritchey

• sys.dm_db_index_usage_stats. why are there multiple values in the Database_ID column?

  I believe the dmv sys.dm_db_index_usage_stats is database dependent. What i mean is if i set the co…

  winston Smith

  1 replies

  15 years, 10 months ago

  By: Grant Fritchey

• Foreign key displays null

  Attached is an example of the query. After writing this code and running the query , the Job Title …

  kennywashington2000

  10 replies

  15 years, 10 months ago

  By: kennywashington2000

• Some basic Clustering Questions

  I've been asked to build an Active/Active/Passive SQL 2008 R2 Cluster for our OLTP setup, and an Ac…

  PhilipC

  1 replies

  15 years, 10 months ago

  By: MysteryJimbo

• Buisness Intelligence (BI) Architect Document needed

  Hello Friends Can anybody please provide me Buisness Intelligence (BI) Architect Document ? Or Link…

  ajit.ghule

  4 replies

  15 years, 10 months ago

  By: steveb.

• TRIGGER and ERROR LOGGING

  Hi, I have a trigger that works well. But I do want errors logged. For starters, I added these line…

  Raymond van Laake

  3 replies

  15 years, 10 months ago

  By: Raymond van Laake

• SSIS Package or Script

  I do have one table in server - Production Server name.Table1 and second table in dev server- devel…

  EasyBoy

  6 replies

  15 years, 10 months ago

  By: saurabh.deshpande

• Apply partition concept to existing table

  I have created partition function and partition scheme. I already have a table with 70 lakhs of rec…

  amit-1143912

  4 replies

  15 years, 10 months ago

  By: winash

• Connecting to SQL Server from remote Linux box

  There are a few cases where I might need to connect to a SQL Server installation remotely, from a L…

  e1785

  1 replies

  15 years, 10 months ago

  By: Leju Geevarghese

• Duplicates returned even using DISTINCT and WHERE NOT IN

  I have a table with nearly 6,000 rows that needs to be updated with new rows periodically. The upd…

  jerry-621596

  10 replies

  15 years, 10 months ago

  By: Derrick Smith

• Calculating Balance based on the transaction

  I have two tables that stores balance and transaction information about an account. The first table…

  yogesh_pandey

  3 replies

  15 years, 10 months ago

  By: yogesh_pandey

• Restore SQL Server 2005 database in SQL Server 2008 instance

  Hi, I'm trying to restore a SQL Server 2005 database into a SQL Server 2008 instance and getting th…

  gary1

  5 replies

  15 years, 10 months ago

  By: Gail Shaw

• Naming a SQL server instance ".\SQLExpress"

  I am taking a Database Programming course. At my school they named the SQL server ".\SQLExpress" a…

  myavast

  6 replies

  15 years, 10 months ago

  By: myavast

• Sql 2008 license query

  Is there a query I can run for Sql 2008 to find out if a server is licensed under per processor or …

  amdavis

  4 replies

  15 years, 10 months ago

  By: MysteryJimbo

• Looping through the recordset to assign different balance value to each transaction row

  I have two tables that stores balance and transaction information about an account. The first table…

  yogesh_pandey

  6 replies

  15 years, 10 months ago

  By: yogesh_pandey