SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Where can I find the definistion of this table value function

  Consider this ..... UPDATE t SET t.Anesthesia_Start_DT = ct.Anesthesia_Start_DT ,t.Patient_…

  mw_sql_developer

  14 replies

  11 years, 3 months ago

  By: MMartin1

• Running DBCC CHECKDB Against Mirrored DB

  Hi Would anyone happen to know how I would run a full DBCC CHECKDB against the database that is act…

  wak_no1

  8 replies

  11 years, 3 months ago

  By: lalit.asky

• Index creation and Updated date in 2008

  Hello everyone How do i know when index was created and updated in SQL Serve 2008?

  EasyBoy

  2 replies

  11 years, 3 months ago

  By: minjunma

• Multiple SQl Server Instances on Same Server

  We are building a database server that we intend to use to give all developers their own SQL Server…

  dlq1211

  4 replies

  11 years, 3 months ago

  By: spaghettidba

• Netbackup Restore - Encrypted Database

  Hello - I am working with a storage admin to recover an encrypted database using netbackup. (The st…

  NJDave

  2 replies

  11 years, 3 months ago

  By: NJDave

• View return "Statement(s) could not be prepared" "and Invalid column name 'Col9155'."

  Hello! I have two server with SQL-2008 in different place with different name. Each server have the…

  pashy

  24 replies

  11 years, 3 months ago

  By: spaghettidba

• Partition Level Lock Escalation Problems

  Hello Experts, Making escalation level to auto will create escalation to partition on a partitioned…

  er.mayankshukla

  1 replies

  11 years, 3 months ago

  By: Gail Shaw

• Measuring Duration in SQL PROFILER

  Hallo All, I have an issue in my production with long running query .. After analysing the index , …

  WhiteLotus

  5 replies

  11 years, 3 months ago

  By: Gail Shaw

• Use of Function with update

  Hi there, I have a table with 20 million rows of Employee information. This Table has Employee Addr…

  rash3554

  4 replies

  11 years, 3 months ago

  By: Jeff Moden

• Column Descriptions in a table. How do we retrieve them using SQL

  The following adds a description to the column in a view. Good! I am assuming the same can be done …

  mw_sql_developer

  1 replies

  11 years, 3 months ago

  By: ScottPletcher

• how to backup and restore only a table?

  Hello, Is there any way just to backup a table (big table) and restore it on different server (diff…

  Dan121

  3 replies

  11 years, 3 months ago

  By: Adam Angelini

• SQL Query Process Order Help

  Hello I am working on a query in SQL and can't seem to get it to work 100% I have a data set in SQL…

  tlugdon

  8 replies

  11 years, 3 months ago

  By: Adam Angelini

• Updating SQL table using SSRS

  Hi everyone I have the following table in sql server: CREATE TABLE [DBO].[SHIFTS] ( [WEEK_ENDING] …

  ByronOne

  5 replies

  11 years, 3 months ago

  By: brrimes

• Database size growth after Rebuild/reorganize job.

  Hi, I have a VLDB and have setup 'Rebuild' and 'Reorganize' index job every week. after completion …

  Tac11

  8 replies

  11 years, 3 months ago

  By: Tac11

• Tempdb a total mess

  Hi, I'm analyzing a server 2008 R2, build RTM... I was looking at the sys.dm_io_virtual_file_stats …

  PiMané

  8 replies

  11 years, 3 months ago

  By: quackhandle1975