Looks like the backup file cannot be read by SQL Server due to the disk damage (or the file recovery process). At this point your options include...
Frank. Just hibernating - saving power for a rainy day.
;WITH UserColumns (col,tab) AS (SELECT c.name AS [COLUMN] , t.name AS [TABLE] FROM sys.sysobjects AS t INNER JOIN sys.syscolumns AS c ON t.id = c.id...
I don't think using a join would impact greatly (if at all) on the performance of your delete operation. Check the estimated execution plans for the...
Think of a linked server as a definition for a data connection. By linking directly to a database, you would be missing one important component of a...
With the advent of ADO.NET and SQL Server 2005, choosing between ODBC and OLEDB is no longer the question. If you are using a programming language...
Why not break the line into: DECLARE @histid int; SET @histid =(SELECT auditHistoryId FROM INSERTED); INSERT INTO DBO.XXX_XRefConnection VALUES...
This came as a surprise to me since I am a rare visitor to the site these days (no need to explain, I hope). But welcome to the SSP fold Mr. O'Kelly!...
Just one more tweak to your tests. Do a Full database backup of the NEW adventureworks database and then run the same test exactly. You will see what...
What you are seeing is not the Log Size but the Log size used. And if you look closely at the data on the perf picture you posted, there are actually...
Mark Russinovich (Former SysInternals, now MSFT) says: "Probably of most importance, however, is the outcome of the various meetings I#%92ve had...
Various T-SQL commands can be used to get log space usage. You can start off with the good old sp_helpdb stored procedure which will give you the...
Depending on the kind of executable (Windows PE or .NET MSIL) you will need a disassembler to reverse engineer SOME of the code. There may be legal...
SELECT <columns > FROM StudentsTable WHERE StudentIdentifier NOT IN (SELECT StudentIdentifier FROM ClassRosterTable WHERE...
Please check this out: http://support.microsoft.com/default.aspx?kbid=241743&product=acc2000 Nathan H. Omukwenyi MVP [SQL Server]
If your using SQL Server 2005 , you would replace 'MINUS' with 'EXCEPT'. With SQL Server 2000 you can use the 'NOT IN' operator to prune the results:...
1. Re-write as: INSERT INTO VACATION_REQUESTS (e_seid, fifo_date, day_off) SELECT @SEID, @FIFO, * FROM TABLE OR 2. I have a feeling the other...
Good one. But where is the DBA in that list? Doesn't the DBA think that the woman is too slow? 9 months! What would Satya suggest for optimizing this...
Windows Transformation Framework. I would give a whooping WTF! to that. Though I wouldn't be surprised since WPF and WWF have already become...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Separate names with a comma.
