Forum Replies Created
Viewing 15 posts - 7,321 through 7,335 (of 7,498 total)
-
RE: Wrong QOD 16-12-2003
correct.
Should be :
CREATE VIEW v_selectarticle
AS
SELECT TOP 100 PERCENT article_id, headline FROM ARTICLES
ORDER BY article_id desc
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: Database Scripting Issues
This is a long shot, but maybe you could download a trial copy of erwin(CA) or another dbcompare-tool, reverse engineer your scripted db and compare it to a reverse engineered...
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: immediate execution of job via SP or ASP
If you no longer want the jobownership-burden to be able to start a job, create an alert which you let start the job. So when you want to start your...
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: Compress tables or filegroups
IMO this is not supported for sqlserver.
(unlike DB2)
What you could do is alter the clusterd index of those partitioned-view-parts to 100% fill and rebuild it. Keep in mind to put...
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: Search and replace data in a column
I think I've read this in a server-migration descussion/whitepaper.
There is a update sysjobs script which puts the new servername in the "originatingserver"column.
If I'm correct all it took was just a...
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: Comments and Bugs on New Design
FYI: The replies counter in forums is not correct. It goes from 0 to 2.
Is there a way to Unsubscribe from a topic notification ?
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: Database Scripting Issues
maybe this helps :
select o.name
, c.text
FROM dbo.sysobjects O
inner join dbo.syscomments C
on O.id = C.id
and O.xtype = 'V'
where C.text like '%CREATE VIEW %'
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: Comments and Bugs on New Design
when opening a page I already start scrolling down before it is complete.
When it completes, it scrolls to top.
Can you avoid 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
-
RE: Problem with "WITH CHECK OPTION"
just my 2ct
Could you elaborate why your update statement would not qualify to be done using this view ?
If the update works, I presume you'll still find these data through...
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: Comments and Bugs on New Design
- do you all have 56" screens ?
Where 's the time we had automatic wrapping ? I don't like to be scrolling horizontal.
- I also get some...
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: QOD 21 Nov
hanslindgren:
quote:
--------------------------------------------------------------------------------
Oki, in your opinion, what is application needs? Are they never relying on queries?
--------------------------------------------------------------------------------
Of Course it's ALL about queries ! But it's a tradeoff as to which one(s) will be...
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: QOD 21 Nov
I entirely agree happycat59's comments. Plus the fact each clustering index should be picked, based on application-needs. You don't change clustered ix just because a query runs slow. First stage...
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: Reseting Logins after detach and attach
use userdb -- User-db
go
print 'print @@servername + '' / '' + db_name()'
print 'go'
go
declare @username varchar(128)
declare @Musername varchar(128)
declare @IsNtName bit
declare @sql_stmt varchar(500)
--cursor returns with names of each username to be...
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: Error running script Upgrade.sql (SQL7 sp4)
http://support.microsoft.com/?id=264123 might have been the problem.
Due to production pressure, I've had to solve it with uninstall reinstall of SQL7 up to SP4 and then reattatch the db and recreate the...
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: dev's using sa on production - help
grab "the best of sqlservercentral.com 2002", you'll find more info regarding this.
maybe a search on this site gets you in the right direction.
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,321 through 7,335 (of 7,498 total)