Hi all, We are using push transaction replication and distributor is on its own server in a SQL 2008 env. Within a user db, I normally set up one...
Contention issue like Shehap described is likely what caused the delay. Another possibility, although it is less likely, is hard disk (or raid)...
Ghemant, Thanks for the suggestion. This does bring back the replication stored procedures. I have a follow-up question. I am aware of that 'with...
We are on SQL 2008 R2 standard 64 bit. Recently I performed a full backup on a database using native SQL backup tool from a server and restored it...
I do daily full back up of a 150G bytes database to a local drive of its server and it took 2 hours and 45 mins. This database is on SQL 2008...
Frank, As I illustrated in my message, the reason there isn't any where clause is because I use tableC to join the view for all the records I want...
I have two identifcal tables, table A and table B. Both have primary cluster index on field col1. tableA is holding current data and tableB is...
I have an update statement which doesn't involve any aggregate function or group-by but the execution plan shows there is a stream aggregate. Somehow...
We recently purchased a new SAN which has 24 hard disks. I will use 12 of them solely for the main database. Transaction log and tempdb will have...
Our regular database contain 1 default primary group and my user defined file group. I know I can do the backup of just that user defined file group....
I want to use a SQL query to get the 'modifed date' of an external text file. Is it possible? w
Hi, We are on a windows 2008 x64 and SQL 2008 x64. Our cluster is a 2-node active passive one. We need to replace our existing SAN with a new one...
Sorry forget to post the sql statement. Select * from #EmployeeInfo EI left join #EmployeeTitle ET on EI.title = ET.title left join #SpecialSkill ss...
I have the following SQl statement which join with a few #tables. I need to have all the columns from each #table. Unfortunately it consists of...
We are looking into saving money if certain SQL edition can achieve what we need. We have SQl 2008 standard x64 edition running on windows 2008...
Currently we are using MS Access to build reports in which we seperate the report layout and where clause into two seperate parts. The tables in the...
We are using SQL 2008 std. We have a table holding over 22 million records and is being used frequently. We have a need to add a varchar(max) field...
I am trying to run a OpenRowSet query below and gettting the error 'Access to the remote server is denied because no login-mapping exists.' Here is...
We currently are employing Push transactional replication. Publisher and distrisbutor are on the same SQL server, say server A. We have one...
What would happen to the full text search on a table A when the table A is dropped and recreated? Would the full text search still be available...
Separate names with a comma.
