Viewing 15 posts - 4,861 through 4,875 (of 7,506 total)
I'm running sql2005 sp2 cu6 (client) and I also have the impression the first start takes longer than before.
btw:
did you disable the InternetExplorer settings / advanced / Security "Check for...
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
May 15, 2008 at 12:37 pm
- take a look at your maintenance plan execution history !
(rightclick maintenance plan)
- have a look at SQLServer errorlog.
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
May 15, 2008 at 6:00 am
No doubt about it. The methode Michael Earl proposed is the simplest !
- Simple
- Straight forward
- complete
- no log overhead
- the space you need = the space of your prod...
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
May 15, 2008 at 5:59 am
This would mean the column's value must exist in both "parent" tables ?
IMO that doesn't feel like it should.
A key is just a key and should represent nothing else...
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
May 14, 2008 at 8:02 am
If I'm correct, this is one of the features SQLCMD has.
You can use DOS-variables with it!
Check SQLCMD 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
May 14, 2008 at 7:38 am
Also keep in mind that with Windows 2003 you can use "mounted drives" to get over the 26 letter drive naming.
Each of these mounted drives can point to different luns,...
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
May 14, 2008 at 2:15 am
SELECT COUNT(s.boxid) AS Expr1
In a view each column needs to have a name.
The querybuilder gui just puts Exprn if you don't provide one.
Regarding the layout,...
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
May 13, 2008 at 2:05 pm
John Carlson (5/13/2008)
When executing the following:
exec xp_cmdshell 'sc \\MYSERVER stop MYSERVICE'
I get...
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
May 13, 2008 at 1:59 pm
Are you on RTM, SP1 or SP2 ?
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
May 13, 2008 at 8:25 am
Indeed, you'll spend most of the time getting used to the new GUI with SQL2005.
You can always right click on a table and select "edit" (SP2) then it will show...
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
May 13, 2008 at 7:09 am
can you post the ddl of XML_GSK ?
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
May 12, 2008 at 12:29 pm
did you have a look at "http://www.sqlservercentral.com/scripts/Miscellaneous/30268/ ?
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
May 12, 2008 at 12:25 pm
riga1966 (5/11/2008)
What are synonyms and how you create them?
You may be better off taking this question to a new thread.
Check BOL for "Understanding Synonyms " (Local BOL url) ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6210e1d5-075f-47e4-ac8d-f84bcf26fbc0.htm and...
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
May 11, 2008 at 1:36 pm
- 15 million rows per month = +/- 350 rows a minute. Should not be a problem.
Try to implement as many best practises a you can, because it can go...
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
May 11, 2008 at 12:57 pm
Jeff Moden (5/9/2008)
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
May 10, 2008 at 12:19 pm
Viewing 15 posts - 4,861 through 4,875 (of 7,506 total)