Forum Replies Created
Viewing 15 posts - 7,291 through 7,305 (of 7,502 total)
-
RE: New Forums are Live!
Very nice !
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: Agent Job wont run - HELP!
Make sa jobowner.
Your sql-agent-service-account needs to be able to access all needed files, db, ...
You could also open the commandline setting a proxy-account (check BOL), but I don't know if...
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: Agent Job won't run - HELP!
Can you open the DTS-package with EM on the server itself ?
If not, MDAC is your problem.
Only create an maintain DTS-packages at the server itself, not using a client...
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: New DB – Determining the data and log file size
Check http://support.microsoft.com/default.aspx?scid=kb;en-us;272318 (sql2000)
http://support.microsoft.com/support/kb/articles/q256/6/50.asp?id=256650&SD (SQL7.0)
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: DTS package corrupts in 7.0 - help
mdac-components are stored in the dts-package, that is the problem !
ALWAYS (shout is out as loud as you can) edit packages on the server itself ! Not from a client!...
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: Count Distinct values
quote:
select distinct p.product, c.currency, c.customerfrom ...
where ...
...
You may even get advantage by...
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: How to Find Default File Group
exec sp_msforeachdb "select '?',
groupname from ?.dbo.sysfilegroups
where FILEGROUPPROPERTY(groupname, 'IsDefault') = 1 "
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: Free space in Data file
quote:
sp_helpfile will tell you the database file size which have been allocated to your database.SELECT FILEPROPERTY('yourdatabaselogicalfilename', 'spaceused') will give you space used...
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: restoring db on cluster
it reads the filelocations from the backup-set, so you'll have to change file-locations to those available on your clustered-sqlserver-instance.
e.g. :
Restore database mydb
from DISK = '\\myserver\drive$\msSQL\BACKUP\mydbFull.BAK'
with MOVE N'mydb_data' TO N'x:\MSSQL$instance\Data\mydb_data.mdf'
,...
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: Accessing 2 servers from the same SP
check books online (BOL) for "Linked server"
you would create a linked server on server A to server B and then you can use Server B tables like this :
select ......
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: Date Operation
Maybe this is wat you're looking for to add the remaining 50%
CREATE FUNCTION dbo.udf_convert_date2WeekRange (@RefDate datetime, @FirstLast char(1) = 'F')
RETURNS datetime
AS
BEGIN
DECLARE @return_date as datetime
...
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: Date Operation
Might be conveniant if you had a dates-table (like in most datawarehouse-env)
Then you would have a materialized week-start and week-end date, so you could join both tables.
table might contain :
[Calender_YEAR]...
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: %COMPUTERNAME% does not work
"It returns the computer name on which the command runs. Why are you asking?"
to start on the quest for "why isn't this working".
"So basically I'm guessing no environment variables...
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: A Sticky One
- can you define "last" ?
does your table Test_Results contain a column with datetime of registration ?
- can you post both tables DDL ?
Edited by - alzdba on 12/30/2003 ...
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: New DB – Determining the data and log file size
- which Recovery-model did you specify on your sql2000 db ?
Maybe switching to bulk-logged may help out.
Edited by - alzdba on 12/30/2003 01:24:52 AM
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 - 7,291 through 7,305 (of 7,502 total)