Viewing 15 posts - 2,686 through 2,700 (of 7,429 total)
quote:
1. SELECT blala FROM table WHERE field != valueIs in this case any index used, or does SQL Server always perform a...
July 21, 2003 at 5:05 am
The error means the backup was done using more than one device or backup file and you
are trying to restore using just one. You need to provide all the backup...
July 21, 2003 at 4:55 am
First, check SERVERPROPERTY('SERVERNAME') and see what it returns. You can
try executing the following to fix @@SERVERNAME:
EXEC sp_dropserver 'oldservername'
EXEC sp_addserver 'newservername', 'LOCAL'
restart SQL Server service and generally it should be fixed.
SELECT...
July 21, 2003 at 4:53 am
Unfortunately (and it has been suggested as I made it at least 4 times to reps) no true ROWNUM in SQL 2000. There are a number of tricks you can...
July 21, 2003 at 4:42 am
Normally I would suggest pushing to the filesystem and stroing pointers to that location for you pages or app to be able to retrieve. But with changes in the way...
July 21, 2003 at 3:42 am
You know, I don't think the majority of people even have a clue on this one so they jsut ignore it. Of course it is a good one if you...
July 18, 2003 at 4:48 am
Here I think this is right.
quote:
EIGHTBALL'Eightball' is a highly uncomplimentary slang word standing for a rather objectionable character ('gold brick', 'goof'). The...
July 18, 2003 at 4:37 am
Oh, another thought. What day will you use for people who were born leap-day. I didn't account for that.
July 18, 2003 at 4:03 am
This will give you the age and the people born on that day.
select
[id],
FirstName,
LastName,
Date_born,
DATEDIFF(yyyy,Date_born,GETDATE()) AS Age
from dbo.users
WHERE
DATEADD(yyyy,-(YEAR(Date_born)-1900),Date_born) = DATEADD(yyyy,-(YEAR(GETDATE())-1900),GETDATE())
July 17, 2003 at 4:17 pm
How do you want to compare? Need an example of what it is you want to see.
July 17, 2003 at 5:55 am
When you say compilation time do ou mean when it was last created/altered or the last time it ran, or something else entirely?
July 17, 2003 at 5:26 am
1) What is the error message in the history for each.
2) What account is SQL Server Agent set to run under?
3) Is there anything special that these have in common...
July 17, 2003 at 5:24 am
First keep in mind that tempdb is design to automatically flush to make room for other queries use otherwise you would be doing a manual flush everytime a data set...
July 17, 2003 at 5:09 am
This is how I do it but I do sugegst follow using the TRANSACTION method to be able to recover if you find an error in the data.
July 17, 2003 at 4:59 am
Viewing 15 posts - 2,686 through 2,700 (of 7,429 total)