Viewing 15 posts - 3,016 through 3,030 (of 7,499 total)
Don't fool yourself nor the engine and define the column using data type datetime !
Rule no 1: tell the system what you know !
Rule no 2: use the correct data...
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, 2010 at 12:35 am
martinfalch (5/12/2010)
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, 2010 at 7:11 am
You are creating a db of 4Gb datafile + 2Gb log file .... to large !
Can you give it a try using this ddl:
CREATE DATABASE [TimeSeriesSSC] ON PRIMARY
(...
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, 2010 at 5:55 am
Can you script the create database ddl ?
(rightclick on the db-name and then select Script database \ as create \ to query panel and then copy/paste the ddl.)
This will only...
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, 2010 at 5:44 am
Just my 2ct.
Leave your db as it is until you are 100% sure it is actually over sized !
(Someone will have put it to that size for a reason, figure...
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, 2010 at 5:33 am
Your db files are >= 4Gb, which is the maximum for sql2005 express edition.
You'll need to free up some space before your engine will be able to allocate it.
You'll have...
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, 2010 at 5:19 am
another thing ...
Are you sure your instance is listening at the port number you provided ??
If I'm correct, in a connection string, if you provide the port number, it will...
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 9, 2010 at 2:13 am
file 1 is a data file.
Shrinking it 500MB at a time will be to much overhead for your operation, especially if you know it only contains 20% worth of data.
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
May 8, 2010 at 12:56 pm
You could use a server level DDL trigger in combination with a database set AUTO_CLOSE on.
(check BOL DDL Statements with Server Scope (ALTER_DATABASE) )
and just register if it is...
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 7, 2010 at 12:20 pm
afaik you cannot delete a part of a backup file.
A backup device is just a pointer to an actual file.
If you use backup with init, that file wil...
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 3, 2010 at 1:53 pm
That shouldn't be a problem.
please check out Identifiers http://msdn.microsoft.com/en-us/library/ms175874.aspx regarding your table name containing the #.
Avoid special chars in your object names or always use brackets ([ ]) with 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
May 3, 2010 at 1:41 pm
the lack of indexes, clustering indexes and foreign keys will indeed kill this kind of queries.
Determine a primary key for every table and if you can, determine foreign keys 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
May 1, 2010 at 2:08 pm
Denise McMillan (4/30/2010)
Also, what did you mean when you referred to this:
- you also need to...
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 30, 2010 at 2:14 pm
By default you don't need a cursor ! :w00t:
double check your data !
I think you misplaced column names for [CurrentTalkTime] and [IncrementalTalkTime].
VALUES( 2 ,'2010-04-28', 510016, 135, 120, 15, '2010-04-28 15:00:00.000')
Considered...
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 29, 2010 at 12:48 am
Are your schedules enabled ?
What kind of jobs do you have ?
- local sqlinstance only
- ssis packages
- cmdshell
did you change the sqlagent service account lately ? (and does 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 29, 2010 at 12:24 am
Viewing 15 posts - 3,016 through 3,030 (of 7,499 total)