Viewing 15 posts - 1,936 through 1,950 (of 3,232 total)
It looks like you are attempting to insert the comma separated values from your variable into the temp table correct? If so, this is a great job for a...
January 7, 2008 at 7:34 am
I would say the best place to start would be in BOL. Type in Stored Procedures and you'll get a myriad of topics to look at. Start with the...
December 20, 2007 at 1:26 pm
It also really depends on what you mean by valid? You could look at the dependencies to make sure they all exist for that SP.
select object_name(so.id), object_name(depid)
from sysdepends sd
...
December 20, 2007 at 1:23 pm
Yes, Jo. You can use the /3GB switch and set the Max Server Memory to use 3 GB without enabling AWE.
December 19, 2007 at 3:27 pm
Wow, I'll try to keep the ranting to a minimum. Erin, you as the development DBA are the data storage and retrieval expert. That is the value you...
December 19, 2007 at 1:56 pm
I agree with Gail here. That is why I asked the question initially. The simple fact is that 'if it's not broke, don't fix it'! You could...
December 19, 2007 at 1:17 pm
What is your server OS? If you have Windows 2000 Advanced Server or greater, run sp_configure to set your max server memory to 3 GB. The /3GB switch...
December 18, 2007 at 4:20 pm
Try a FULL OUTER JOIN:
DECLARE @Table1 TABLE (Col1 int)
DECLARE @Table2 TABLE (Col1 int)
INSERT INTO @Table1
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 4 UNION ALL
SELECT 5 UNION ALL
SELECT...
December 18, 2007 at 1:33 pm
Is this a one-time operation or a process that will be reused often? How large of a file are you looking at?
December 17, 2007 at 3:52 pm
Here you go Mark:
SELECT t1.Name, t1.Date, t1.Value
FROM Test t1
INNER JOIN (
SELECT name, MAX(date) as...
December 17, 2007 at 3:41 pm
A bookmark lookup means that SQL Server must read from the data pages to handle the query. The only way to avoid a bookmark lookup is to use a...
December 17, 2007 at 3:36 pm
Yep, I second Grant. At least give us your first stab at this and tell us which requirements you are having a problem handling. Help us help you...
December 12, 2007 at 3:18 pm
You are correct. There are 10 ways to skin a cat. I've just skinned enough cats to prefer the fastest way because their guts stink real bad. ...
December 11, 2007 at 3:29 pm
Who did you say was nit-picking?? 😀 We all know that your solution works for you cuz you told us so more than once. I am simply...
December 11, 2007 at 2:50 pm
The problem with the numbers table not out-performing the straight function has nothing to do with the actual numbes table; it is the CTE that is dragging it down. ...
December 11, 2007 at 1:40 pm
Viewing 15 posts - 1,936 through 1,950 (of 3,232 total)