SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• want to convert the underlying query into indexed view,Not getting any help from database tuning advisor, kindly help

  Select 'Customer' AS 'USERTYPE', DT1.DT, DT1.DT_KEY, SUM(A1.BLNC_AMNT) ,G1.GOGRPHY_KEY , '' …

  saxena200

  9 replies

  13 years, 3 months ago

  By: saxena200

• Database Size

  Hi All, I am told by one DBA that the Database which is used in company is carry forward.. means th…

  OnlyOneRJ

  17 replies

  13 years, 3 months ago

  By: OnlyOneRJ

• Shrinking log is bad?

  Hi All, I am aware that shrinking leads to fragmentation and doing it often is a very bad practice.…

  karthik.catchme

  10 replies

  13 years, 3 months ago

  By: karthik.catchme

• PAGEIOLATCH_SH blocking

  Hi all, I have 2 sessions: Session1: UPDATE a SET Column1 = fnc_calculatecost(b.ID) FROM Table_A a…

  Dung Dinh

  3 replies

  13 years, 3 months ago

  By: Gail Shaw

• what is the need for placing mdf and ldf files in different drives

  Is there any special reason for placing these files in separate disks.

  m.rajesh.uk

  4 replies

  13 years, 3 months ago

  By: Koen Verbeeck

• regarding output of Set Statistics IO on

  Hello I am running queries, in production to test the performance issues. This is what i get from t…

  vihaan

  2 replies

  13 years, 3 months ago

  By: Gail Shaw

• Xquery -- Select not returning all the attributes

  I have a table: CREATE TABLE [dbo].[XmlTable]( [XmlId] [int] IDENTITY(1,1) NOT NULL, [XmlDocument…

  mail4bbt

  4 replies

  13 years, 3 months ago

  By: Steven Willis

• Structure of SQL Server

  Hi every one, Thanks for your great support and contribution to this forum. My client want me to c…

  m.rajesh.uk

  6 replies

  13 years, 3 months ago

  By: m.rajesh.uk

• Script object into a text file

  Hi All, After this: EXEC master.dbo.sp_configure 'show advanced options', 1 RECONFIGURE EXEC master…

  Igor Micev

  3 replies

  13 years, 3 months ago

  By: Igor Micev

• Deadlock Issues (Why Certain Locks?)

  I am having some problems with frequent deadlocks in a vendor-supplied database and I have been ana…

  Jason Givens

  6 replies

  13 years, 3 months ago

  By: Orlando Colamatteo

• SQL partition

  I got a database which has serveral database files. Some are used and some are not. How can I find …

  will75

  10 replies

  13 years, 3 months ago

  By: Baguckis

• database restore 2008 r2

  Hi all, approximately how much time the sql server 2008 r2 will take to restore 66GB of .BAK…

  sathiyan00

  4 replies

  13 years, 3 months ago

  By: Anonymous

• Identify DML changes between two databases?

  I've existing DB called A which contains 410 tables. I created another DB called B from the backup …

  Easwaran-336667

  2 replies

  13 years, 3 months ago

  By: Baguckis

• set SSRS date parameter default value to previous date(getdate()-1

  Hi, What is the expression to set the default date of date parameter to getdate()-1. I want the SSR…

  sql_ques

  2 replies

  13 years, 3 months ago

  By: LaDBAinTx

• Help explaining query results.

  Hi Guys, I was working on a script that would show all records in Table A that didnt have correspon…

  Don.

  5 replies

  13 years, 3 months ago

  By: Don.