Forum Replies Created
Viewing 15 posts - 7,291 through 7,305 (of 7,498 total)
-
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
-
RE: Index rebuild made it worse ?
keep in mind that rebuild index will not affect your datapages, unless you have specified a clustered index. (there should be one "by default dba behaviour" for every table )
Also...
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: Generate Sequence Number Safely
"as part of the invoicenumber" ?
Is your invoicenumber still numeric ?
Is this to-be-generated-sequence-number used as a suffix to a fixed prefix (e.g. yearmonth&sequencenumber) ?
maybe this can help out :
You would...
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: Stars
proposition:
4 stars = SQLSir
5 stars = SQLKnight/SQLord
6 stars = SQLSaint
I guess an indication based on # of accepted responses might be preferable over a "rating" but...
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
What is it returning when you schedule a job (owned by sa) which runs TSQL:
exec xp_cmdshell 'echo %computername%'
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,498 total)