Forum Replies Created
Viewing 15 posts - 6,316 through 6,330 (of 7,502 total)
-
RE: Why is my Sproc sooo slooow .. and how will it be faster!
- Can you try to execute the queries without the TOP-keyword (and order by) in the views ?
- Like you can see, maybe you would be better off by altering...
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: SQL Performance Counters Missing
If I'm correct this issue has been mentiond at SSC-forum last week or the week before.
IF I find the thread, I'll add it
updated :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=265470#bm266005
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: Why is my Sproc sooo slooow .. and how will it be faster!
first of all :
- ... FROM dbo.eventlog
WHERE (RIGHT(attributes, 4) LIKE '%55}')
will cause a table-scan ! because with the function no index...
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: Is there a way to write this in SQL
FYI
check out http://www.microsoft.com/sql/downloads/trial-software.mspx
for an 180-days trial version.
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: Is there a way to write this in SQL
With SQL7 you will have to use a #tempTB in stead of a declare @tb table !
It does not know tablevariables !
If you are only interested in the last...
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: Is there a way to write this in SQL
So your TableA is dynamic ?
if not, write a query to perform your select, determine a maximum...
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: Is there a way to write this in SQL
maybe you'll find it overhere :
http://www.microsoft.com/sql/prodinfo/features/default.mspx
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: Is there a way to write this in SQL
just for the record, to tease a bit
SQL2005 way:
start with RyanRandall 's example ...
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: Is there a way to write this in SQL
so this is a hiarchy.
With SQL2005 you can use a CTE with a recursive part
With SQL2000...
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: Performance tuning for ETL
- avoid non-clustering-indexes at load time (consider drop before / re-create after load)
- sort you data according to the clustering index of your objects before loading.
- use bulk-insert whenever possible
I...
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: SQL Server Agent will not start
thanks for the feedback.
These kind the tiny brainteasers being solved make our day
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: Cluster install: SQL Management Studio won''''t install
I didn't encounter this problem, but I'm using SQL2005EE and I'm installing the client-software at the C-drive ! (default).
I've set up an Active/Active cluster with 3 instances hosted on 2...
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: Server name change
there is offcourse http://msdn2.microsoft.com/en-us/library/ms143799.aspx.
But it does not include any reference to the created local users or groups.
Suppose I create a ghost-image after install, apply the ghost to a new...
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: Difference between table1, table2 and table1 inner join table2
IMO the JOIN-syntax using the on clause differantiates better wat's a join-predicate (on-clause) and what's a filter-predicate (where clause).
This makes is more ease for another person to understand your queries.
Check this...
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: Table Variable with Identity Column
check books online
DBCC CHECKIDENT ('table_name', NORESEED) just for reporting
or
DBCC CHECKIDENT ('table_name', RESEED) reporting and correction !
What error is checkident giving ?
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,316 through 6,330 (of 7,502 total)