Viewing 7 posts - 3,241 through 3,247 (of 3,247 total)
Thanks.
I've tried that but it doesn't let me reassign the SA account back to the dbo user.
I'm a bit concerned that any further databases created all seem to have this...
September 26, 2001 at 9:08 am
I was recently asked to install some databases for a client and their support company specified that the database should be split into 3 filegroups.
1. PRIMARY - to be...
September 10, 2001 at 2:11 am
The problem is that the number of queries you need to write grows geometrically.
1 variable = 2 queries.
2 variables = 4 queries.
3 variables = 8 queries etc.
In other words the...
August 9, 2001 at 4:59 am
Just to clarify:-
The index is on ColA, ColB.
If the WHERE clause searches on ColA only will the index be used?
August 9, 2001 at 1:34 am
Yes, it works.
I read somewhere that evaluating NULLs has a performance hit, although I suspect it is very minor in this case
August 2, 2001 at 9:27 am
They say that lazy people take most pains!
I had seen a syntax for an INSERT statement that went something like:-
INSERT Tbl_X
EXECUTE Sp_Y
Where Sp_Y returns a recordset.
I was wondering if there...
August 2, 2001 at 6:54 am
Here is the same thing avoiding CURSORs.
Use Test
GO
Declare @MyRecipients nvarchar (255)
Declare @MyMessage nvarchar (255)
Set @MyRecipients=''
Set @MyMessage = ‘Your timesheet is overdue, please send it ASAP.'
WHILE @MyRecipients IS NOT NULL
...
July 16, 2001 at 4:51 am
Viewing 7 posts - 3,241 through 3,247 (of 3,247 total)