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...
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...
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...
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...
We are using SQL 2008 std on two SQL server computers. One is the publisher and the other one is subscriber. We have a query running (see below) on...
Besides writing a query, are there any other ways to search a string in any fields within a database? Is there any system views I can use? I am not...
We are using SQL 2008 std x64, push transactional replication. Both publisher db and distribution db are on the same box. Today we encountered a...
I am trouble shooting a long running query and usually it won't take long to get an estimated execution plan, but when I click the 'Display Estimate...
Separate names with a comma.
