Viewing 15 posts - 3,901 through 3,915 (of 5,685 total)
Thanks Paul, I was worried I was barking up the wrong tree. Apparently I was in the wrong forest. 🙂
I'm going to need to read that a few times...
February 23, 2011 at 1:08 am
What is your recovery method on the database? If it's not simple, you need to also backup the transaction log.
February 22, 2011 at 6:00 pm
Sean Lange (2/22/2011)
INSERT INTO tblHistorySource
select *,...
February 22, 2011 at 3:54 pm
Talk to the SAN guys for their opinion, but in general, let the SAN guys do their thing. I usually only get involved these days in their 'turf' if...
February 22, 2011 at 3:34 pm
Check out LutzM's answer in this thread: http://www.sqlservercentral.com/Forums/Topic1067681-338-1.aspx
It's practically the same problem, but with different value differences. It uses the Quirky Update method to arrive at the solution.
February 22, 2011 at 3:31 pm
Hey Rob,
You have a row's dependency based upon the success/fail of another row's dependency. You're pretty much inside that 1% of necessary RBAR.
You're looking at a manual loop, or...
February 22, 2011 at 3:14 pm
Hey Threadizens, I'm trying to help someone with a MAXDOP issue here. I fear I'm digging for China as I haven't really done the research on this recently nor...
February 22, 2011 at 3:01 pm
SQL Dude-467553 (2/22/2011)
Something like this?CREATE PROCEDURE [dbo].[sp_Myproc]
AS
WHERE 1=2
BEGIN
SELECT convert(NULL AS varchar(850)) AS column1
END
Select....
It should return one row that could be as large as 850 characters.
Well, only if your actual proc...
February 22, 2011 at 2:58 pm
SQL Dude-467553 (2/22/2011)
February 22, 2011 at 2:20 pm
Since you're in SQL 2k8, look up the syntax for the EXCEPT clause in a SELECT. It's like the LEFT JOIN/NULL setup, but built in and optimized, you may...
February 22, 2011 at 2:13 pm
Serge Mirault (2/22/2011)
It's the...
February 22, 2011 at 2:11 pm
Tom.Thomson (2/22/2011)
February 22, 2011 at 2:01 pm
Seems straightforward enough. Since you're working from the historical entry point of view, rather then all items, in your audit, two things.
First, modify this query to be used for...
February 22, 2011 at 1:55 pm
It's compiling and parsing all the components. You can see all the moving parts in the last tab (Execution Results/Progress), and take a look at timing. It'll help...
February 22, 2011 at 1:45 pm
tkacyndra (2/22/2011)
February 22, 2011 at 12:49 pm
Viewing 15 posts - 3,901 through 3,915 (of 5,685 total)