Viewing 15 posts - 4,921 through 4,935 (of 7,499 total)
Indeed.
-If you can, migrate;
Reasons:
- in case of disaster you'll have to build your server exactly as your current server. i.e. start with install sql 7.0, restore your sql7.0 databases,...
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
April 28, 2008 at 12:38 am
If your DA / DBA do a good job documenting the relationships, they would for sure use DRI in the database itself AND document the external relationship in the comment...
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
April 26, 2008 at 8:48 am
- Defragging your table will help ! No doubt about it ! Less IO = better performance.
- less IO = less time needed to hold locks
- create an index that...
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
April 25, 2008 at 1:05 pm
There is a little typo in the concatenations ( remove "as colname")
i've also added leading zeros to hours and minutes.
it should be :
Declare @theMinutes int
Set @theMinutes = 2945
Select convert(varchar(15),...
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
April 25, 2008 at 8:01 am
dw (4/25/2008)
Peso (4/25/2008)
The correlated subquery might return NULL if there is no match.
UPDATEmt
SETmt.FKID = x.FKID
FROMMyTable AS mt
LEFT JOINMyFK2Table AS x ON...
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
April 25, 2008 at 6:12 am
You may need to execute this more than once.
-- Shrink_TrxLog.SQL
--INF: How to Shrink the SQL Server 7.0 Transaction Log
-- SQL7 http://support.microsoft.com/support/kb/articles/q256/6/50.asp?id=256650&SD
-- SQL7 http://www.support.microsoft.com/kb/256650
-- SQL2000 http://support.microsoft.com/kb/272318/en-us
-- SQL2005...
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
April 25, 2008 at 6:09 am
Did you try the set-based approach.
[Code]
-- avoid implicit rewrites by adding a nullable column
alter table Mytable add colmigrated datetime NULL; -- to keep track if data has already been processed
go
declare...
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
April 25, 2008 at 3:31 am
as Viking already stated, a column of datatype timestamp is of very little use outside of the sql db.
Even trying to represent it is useless.
btw a timestamp column is automaticaly...
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
April 25, 2008 at 3:19 am
keep in mind the number of rocket scientists is not that high 😉
Declare @theMinutes int
Set @theMinutes = 2945
Select @theMinutes / 1440 as NoDays -- 1440 minutes per...
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
April 25, 2008 at 1:11 am
- Check your sql7 service pac for the prereqs !
- Start with SQL2005 Upgrade advisor !
- run dbcc checkdb for all databases;
- if you can , don't upgrade, but migrate...
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
April 24, 2008 at 2:59 am
BIDS stands for BI-dev studio.
With sql2000 you need to be granted exec of the debug procs.
http://support.microsoft.com/default.aspx/kb/817178
http://support.microsoft.com/kb/280101/
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
April 23, 2008 at 2:05 am
prefer coalesce.
Not only because it is ansi, but also because it can do more for you.
isnull(thecol, thereplacement)
coalesce(thecol,thefirstreplacement, usethisifthefirstreplacementisNULL,...)
and I've had some issues with sql2000 when using isnull is certain...
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
April 22, 2008 at 2:34 pm
With sql2005 the (sqlproc) debugging stuff has been shifted towards BI-dev studio.
This feature is NOT available if you only install the BIDS version MS ships with SQL2005.
Open BIDS
open the server...
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
April 22, 2008 at 2:29 pm
grant VIEW SERVER STATE to xyz ;
Check "GRANT Server Permissions " 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
April 22, 2008 at 6:04 am
This is SQL2005 Right ?
Have a look at the rank functions that can be embedded in the sqlstatement.
Then you would only have the e.g.
Select *
from (
SELECT Rank() OVER (PARTITION...
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
April 22, 2008 at 12:31 am
Viewing 15 posts - 4,921 through 4,935 (of 7,499 total)