Viewing 15 posts - 4,126 through 4,140 (of 7,499 total)
As Manu stated you need to use SQL_Latin1_General_CP1_CI_AS
CREATE DATABASE [yourDbName] ON PRIMARY
( NAME = N'yourDbName_data'
, FILENAME = N'X:\MSSQL.1\MSSQL\Data\yourDbName_data.mdf'
, SIZE = ..., MAXSIZE = ..., FILEGROWTH =...
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
January 19, 2009 at 7:20 am
vikas bindra (1/19/2009)
Also, you don't need the outer cusor: ...
Right on target :exclamationmark:
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
January 19, 2009 at 6:19 am
No reason to shout 😉
Why are you using a cursor for this in the first place ?
SELECT MAX(TRANSACTIONID) FROM UDMLastTransaction
It would be better to just select it directly into 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
January 19, 2009 at 5:18 am
are you using 'implicit transactions' ?
If yes: that will issue a "begin transaction" before the first statement you perform and you'll need to commit/rollbak in the end of whatever...
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
January 19, 2009 at 5:14 am
neil (1/19/2009)
Investigating...
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
January 19, 2009 at 5:08 am
Joe Celko (1/17/2009)
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
January 19, 2009 at 4:39 am
Gabe (1/18/2009)
For some reason, both partitions have to be empty for it to be an instant...
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
January 19, 2009 at 2:27 am
- one of the advantages is the awareness of what one is creating.
( cfr select only the columns you need)
- if in the case, some columns should always 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
January 19, 2009 at 12:10 am
It is a bad practise to restart sqlserver instances if not explicitly needed !
(all cached objects will need physical IO to get cached again (your apps will notice !), all...
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
January 18, 2009 at 1:56 pm
one thing that can bite you nasty is your local (temptb) copy of source data.
1) create your temp tables up front in stead of using select into.
2) only select 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
January 18, 2009 at 3:08 am
DBADave (1/16/2009)
...If they don't I will turn off auto grow and restart the instance and see if this resoves the issue of the files not growing proportionally....
turn off auto...
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
January 16, 2009 at 7:33 am
the article has been mentioned by Nicholas Cain in one of the previous replies.
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx)
Nicholas Cain (1/15/2009)
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
January 16, 2009 at 6:45 am
Nicholas Cain (1/15/2009)
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
January 16, 2009 at 2:06 am
The tricky part for most of us is: How do you size your tempdb ?
Nicholas Cain (1/15/2009)
...My tempdb is vastly larger than it will ever need to be. ....
Do you...
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
January 16, 2009 at 1:55 am
Phillip Oyog (1/15/2009)
This is my first post ever on SqlServerCentral so bear with me. We have a high-availability mirror set up in our office running on Windows 2003 srvr...
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
January 16, 2009 at 1:46 am
Viewing 15 posts - 4,126 through 4,140 (of 7,499 total)