Hi , I manage to start the SSRS services , but when I try to connect to report server , I encounter the Invalid Name space issue. Any idea on this...
Hi , I having a server running on W2008 & SQL 2008 with 8 CPU. When I perform an batch update query , I notice it only utilize one of the CPU...
Hi , I just read an article on Nonkey Columns in Nonclustered Indexes , which using the Include keywords when create index. If the table having...
Hi , I created a standby DB to restore the transaction logs. It running fine quite some times , but recently having an issue , the replicated DB...
Hi , We having a server windows 2003 R2 Enterprise , 32GB Memory , 4 quad core CPU. Running on RAID 10 , DB files / Log / and tempdb was...
Hi , I perform a update stat command and one of my DB tables return the msg as show below. By right this table consist on ].[F_FLT] [PK_F_FLT] as...
Hi , I having a DB (Sql 2005) which having 32 GB RAM and 16 CPU. This DB server purely is for ETL and Reporting purposes. It is a ROLAP DB. 1....
hi , Thanks. Do you means should use "DBCC SHRINKFILE (DataFil1, TruncateOnly) " ? Thanks , Travis
Hi , I intend to cut down the size of DB due to hdd size constraint. First I drop the unused table , and defrag all the index. Do DBCC...
Hi When I try to connect Sql Server 2005 from my PC to server , the error occur "Timeout Expired. The timeout period elapsed prior to completino...
Hi , It just connecting to local DB.
Hi , When running DTS on Sql 2005 , some of the package might encounter "general network error" problem , it is due to any setting on sql server...
Hi , I would like to have a query to select the records below with the conditions below , 1. Unique record 2. If the TransNo is duplicate , then...
Hi , If my table size = 1GB with 10000 Rows of records. How can I calculate the space to be use when I want to create a non-clustered index on...
Hi , How can I Make Read Only DB Online (Using Enterpise Manager) ? Thanks ,
Hi Rich , For the specify task. For instance , I have 10 records to be insert , but some how record number 5 having primary constraint issue...
Hi , 1. Can I reset the initial size of the trans log to 1GB whihc previously I set to 5GB ? I have encounter issue when hard disk size is not...
Hi , How can I set the DTS 2000 package to continue run the rest of the data although have primary key error occur ? Thanks ,Travis
Hi , Try to create a update trigger , when ever a changes on any fields on Customer table on that customer , the [date] will automatically updated...
Hi , Any query function that can convert the string backwards ? For instance , Convert the ABC to CBA .. Thanks , Travis
Separate names with a comma.
