Viewing 15 posts - 46,861 through 46,875 (of 49,571 total)
A full backup will reset the differential base, meaning diff backups cannot be applied to an older full backup.
Neither full nor diff backups truncate the transaction log, so you should...
April 18, 2008 at 3:01 am
p.beeke (4/18/2008)
AS
UPDATE form_count
SET form_count = form_count +1
I need to get the new form_count into the @return output param
I am a newbie and have not...
April 18, 2008 at 2:48 am
Not sure I fully understood what you want...
Here's a simple example of output parameters
CREATE PROCEDURE TestingOutput
@OutVar int OUTPUT
AS
SET @OutVar = 42
GO
DECLARE @a int
EXEC TestingOutput @OutVar = @a OUTPUT
PRINT @a
Does that...
April 18, 2008 at 2:10 am
What are you trying to open it with? SQL 2000's profiler won't open a trace file created with SQL 2005's profiler or server-side trace commands.
I tested and the error I...
April 18, 2008 at 12:48 am
Around here, I've found that either the recruiting companies or HR don't really know what the job requires, so scatter the add with buzzwords.
April 18, 2008 at 12:26 am
As far as I know, the smallest granularity for freeing the caches is at the database level.
April 18, 2008 at 12:12 am
Anirban Paul (4/17/2008)
Check this whether it works or not:ALTER INDEX [IX_name] ON table DISABLE
GO
Alter Index is only 2005 and higher. 2000 didn't have the command at all.
April 18, 2008 at 12:08 am
Not necessarily useless, just not of value for what you're doing. You can remove the starting event from the trace if you wish.
The client process ID is the ProcessID (from...
April 17, 2008 at 1:41 pm
Are those from the Statement started events?
Those are logged when the statement begins. Since it hasn't finished, there's no duration, reads or CPU to log. Those are logged for the...
April 17, 2008 at 12:58 pm
riga1966 (4/17/2008)
Guys,One more SQL Profiler question.
"Duration" in the results table.
Is it the duration of SQL executed in milliseconds?
It's in microseconds on 2005, but in the profiler GUI it will probably...
April 17, 2008 at 12:49 pm
Shouldn't cause any problems, unless you start tracing the very frequent events (object access, lock taken and such) but there's no need for that here.
The standard template is a good...
April 17, 2008 at 12:43 pm
You've got 1 redundant index. Rest look OK. Depending on the queries, they could maybe be widened.
create index scanndx2 on scan(boxid,client)
create index Boxid_idx on scan(boxid) -- redundant
April 17, 2008 at 11:55 am
An aggregate with a group by will return the 1 value for each unique set of columns as per he group by.
In your case, it will return the max effective...
April 17, 2008 at 7:23 am
No replies here please.
Question has been reposted in the sQL 2000 forums
April 17, 2008 at 6:53 am
sp_executesql
DECLARE @SQLString nvarchar(500);
DECLARE @a int;
SET @SQLString = N'SELECT @OutVariable = bp_id from bug_posts where bp_bug=4648 ';
EXECUTE sp_executesql @SQLString, N'@OutVariable int OUTPUT', @OutVariable=@a OUTPUT;
PRINT @a
April 17, 2008 at 6:32 am
Viewing 15 posts - 46,861 through 46,875 (of 49,571 total)