Why is SELECT INTO writting to the tran log? (simple recovery mode
Tue, 16 Mar 2010 12:30:01 -0700
I'm seeing a SELECT INTO statement in a database whose recovery mode is
Simple come up with the same query plan as an INSERT INTO. Same execution
time too (within seconds).
In addition, just in case, I've done a DBCC TRACEON(160) in the SELECT
INTO's query window and checked its' status with DBCC TRACESTAT ...
|
SQL view with detail and subtotal row ?
Tue, 16 Mar 2010 09:31:55 -0700 (PDT)
Hello. MSSQL is 2008. I'm trying to create a view with detail rows
and the last row is the subtotal of all the detail rows. Is it
possible? I'm using a UNION but it throws an error. The last row
uses the same columns as the detail but uses an aggregate Sum
function. Any way to do this?
Here is my code:
...
|
Re: Scheduling legacy DTS packages in SQL 2008 SP1
Tue, 16 Mar 2010 07:08:37 -0700
Hello,
Any luck?
*** Sent via Developersdex http://www.developersdex.com *** ...
|
How to restore Point In Time in this situation ?
Tue, 16 Mar 2010 20:36:50 +1100
Hi,
We are new to SQL Server 2008.
We make daily FULL backup of production database at night and
transaction log backup every hour by maintenance plan.
We also grant privilege to run FULL Database Backup by using the
following SQL:
BACKUP DATABASE [Finance_Live] TO DISK = N'D:\FINBackup\FLIVE.bak' WITH ...
|
message not appearing
Mon, 15 Mar 2010 23:06:53 -0700
I don't know where to post this so I thought I'd start here.
I posted 2 messaged in the microsoft.public.sqlserver.integrationsvcs
newsgroup last Monday - neither have appeared. I reposted today and it
still hasn't shown up. The last message in that newsgroup is from
3/10/2010 - 5 days ago. This doesn't ...
|
How to find the string with (utf-8) and no sign but all the same results in MS S
Tue, 16 Mar 2010 02:48:18 GMT
How to find the string with (utf-8) and no sign but all the same results in
MS SQL 2005
Example: I want to search string "nhà Ä?ẹp" or "nha dep" all the result in
"nhà Ä?ẹp"
Thanks,
nhphuong
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201003/1
...
|
SQL Server maxes out at 100% CPU!
Mon, 15 Mar 2010 12:15:01 -0700
Every few days, our SQL 2008 server comes to a crawl and we have to reboot
it. The CPU becomes pegged at 100%. I ran a query to roll-up my wait type
counts. The top 3 wait types are SOS_SCHEDULER_YIELD, CXPACKET, and
ASYNC_NETWORK_IO. Their wait time in seconds are 828426, 183026, 156414
respectively. D ...
|
|
|
Resolving issues identified by DBCC CHECKDB DATA_PURITY
Mon, 15 Mar 2010 11:31:01 -0700
SQL Server 2008 SP1.
After doing a restore to migrate a SQL 2000 database to SQL 2008 we ran the
DBCC CHECKDB DATA_PURITY command which identified Invalid Rows in several
tables.
The data type of many of the identified columns was numeric(16,2), and we
have been attempting to follow the directions for lo ...
|
Cannot insert explicit value for identity column in table x
Mon, 15 Mar 2010 11:17:02 -0700
Sql Server 2005 9.00.4035.
We have a hub and spoke topology which includes 6 tables with identity
columns.
I need to add a new subscription to a new server (same version/sp). I took
backup from another subscriber and restored to new server, ran snapshot, push
subscription. To make sure a new record would r ...
|
DST time change and SQL agent jobs
Mon, 15 Mar 2010 10:01:02 -0700
Hi All,
I got a problem with our SQL agent jobs due to DST time change, and hope you
can shed some light on what might have happened. We are running SQL 2005 SP2
CU9 64bit EE on Win 2k3 64bit EE.
The problem: We have about 10 log backup jobs for manual log shipping
purposes. Jobs are schedule to run hour ...
|
