Forum Replies Created
Viewing 15 posts - 6,091 through 6,105 (of 7,499 total)
-
RE: Migrating SQL Server 2005 32bit to 64bit
yes
yes
It's your codelibrary that has to be 64-bit, so no change in data.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Selecting Records in the same calendar week as a date.
how about :
select [Meeting Start]
,[Meeting End]
,[MeetingTitle]
from Reservations
where [Meeting Start] between dateadd(dd, (-datepart(dw,@yourdt) + 1), @yourdt)
and dateadd(dd, ((8)-datepart(dw,@yourdt) - 1), @yourdt)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: GUID Primary Keys
this proc may ease your work ...
-- TEST IT - TEST IT --
Create procedure Spc_ALZDBA_PK2NonClustered
@ParentTbName varchar(128)
, @ParentTbOwner varchar(128) = NULL
, @Commentaar varchar(128) = ''
as
-- Declare @ParentTbName varchar(128)
-- , @ParentTbOwner...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Execution time Query analyser vs. asp page = 5 min vs. 2 hours! Help.
- did you create the parameters in your app of the same type and length as for the sp ?
- are the parameters used in the sp of the same...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: I/O Errors
Please post some of the errormessages you get ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: GUID Primary Keys
It is the only way !
When you generate the script for it with EM, you'll see it starts with dropping the relationship(s), dropping the PK, creating the PK and recreating...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Can Linkserver 2005 talk to a 2000 instance?
FYI to solve linked server issues sql2005 to sql2000 sp3/sp4
--
-- KB ref at http://support.microsoft.com/default.aspx?scid=kb;en-us;906954
--
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Problem with stored procedure
just a litle thought...
wouldn't this be easier to get a first glimp of what the last query is doing ?
SELECT
RA
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: DBA member of IT admins?
... Picture no stored procedures, sql server viewed somewhat as a dumb shoe box ...
They must have a raising TCO
People tend to...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Having troubles accessing data after the upgrade to SQL Server 2005
First of all : don't panick
If you still have a copy of the sql2000 (or a backup of it):
have a look at
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: sqlagent service doesn''''t running under a domain account
can you post the sqlagent.out file ?
All our sqlagent's are served using a windows account.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Installation using INI file
you may want to have a look at :
i.e. SQL Server 2005's Undocumented Solution for Unattended Installs
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: I can''''t allocate 7Gb of ram from a total of 8Gb
Aarch yes.... the hotfix is "AWE hotfix SQL2000-KB899761-v8.00.2040-x86x64-ENU"
KB904660 has more on the cumulative hotfix.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Question about indexes
should be FASTFIRSTROW.
search for "table hints" in BOL
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
RE: Question about indexes
implicit_converts will indeed messup things.
rule 1 for any RDBMS : tell the system what you know !
SQL2005 can generate nice xml-plans which show you implict conversions !
<
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 6,091 through 6,105 (of 7,499 total)